Скачать или смотреть How to Fix PostgreSQL Password Issues with Old Users When Upgrading to v15

Learn how to resolve password authentication failures for older PostgreSQL users after upgrading to version 15. Follow our step-by-step guide to recreate users and set up new passwords.
---
This video is based on the question https://stackoverflow.com/q/75044314/ asked by the user 'Timothy W. Times' ( https://stackoverflow.com/u/19677744/ ) and on the answer https://stackoverflow.com/a/75045571/ provided by the user 'Laurenz Albe' ( https://stackoverflow.com/u/6464308/ ) at 'Stack Overflow' website. Thanks to these great users and Stackexchange community for their contributions.

Visit these links for original content and any more details, such as alternate solutions, latest updates/developments on topic, comments, revision history etc. For example, the original title of the Question was: psql cmd command using old user

Also, Content (except music) licensed under CC BY-SA https://meta.stackexchange.com/help/l...
The original Question post is licensed under the 'CC BY-SA 4.0' ( https://creativecommons.org/licenses/... ) license, and the original Answer post is licensed under the 'CC BY-SA 4.0' ( https://creativecommons.org/licenses/... ) license.

If anything seems off to you, please feel free to write me at vlogize [AT] gmail [DOT] com.
---
Troubleshooting PostgreSQL User Authentication Issues After Upgrade to Version 15

Have you recently upgraded your PostgreSQL installation, only to find yourself locked out of an old user account? If you’ve uninstalled previous versions while forgetting passwords or deleted user settings, you’re not alone. In this post, we’ll explore effective steps to overcome password authentication issues for older users after upgrading to PostgreSQL v15.

The Problem:

After installing PostgreSQL v15, you encounter difficulties logging in with an older user account (chris). You receive an error message stating:

[[See Video to Reveal this Text or Code Snippet]]

Additionally, when you type psql in PowerShell, it prompts you for the old user (chris), but you don’t remember the password. Confusingly, you can't even find this user listed in PgAdmin or any associated databases. So, what can you do?

Understanding the Issue

When a new version of PostgreSQL is installed, it's important to note the following:

New Database Cluster: The latest version (in this case, v15) creates a new database cluster, separate from any older versions.

User Management: Users from earlier versions may not be automatically migrated to the new cluster, which means you might need to recreate them.

Environment Variables: As you've uninstalled the old version and cleaned up files, relevant settings associated with previous users may also be lost.

Steps to Resolve the Issue

Here’s a structured approach to fix the password problem and create the missing user:

Step 1: Connect to PostgreSQL as a Superuser

To get started, you need to access the PostgreSQL command line interface (CLI) as a superuser (default user is usually postgres). Open your command prompt or PowerShell, and type:

[[See Video to Reveal this Text or Code Snippet]]

Step 2: Create the Missing User

Once you are connected to the PostgreSQL prompt, you can create the old user chris. Follow these commands:

[[See Video to Reveal this Text or Code Snippet]]

This command initializes the user with login privileges.

Step 3: Set the Password for the User

After creating the user, you will want to set a new password. Still within the PostgreSQL prompt, type the following command:

[[See Video to Reveal this Text or Code Snippet]]

When prompted, enter a new password for the user chris. This will be the password you will use moving forward.

Step 4: Verify the New User

Now that you've created the user and set a password, it's a good idea to verify that everything is working correctly. Exit the PostgreSQL prompt and attempt to log in as the new user:

[[See Video to Reveal this Text or Code Snippet]]

Conclusion

Upgrading PostgreSQL can sometimes lead to login issues if you have older user accounts that are no longer available in the updated version. But with the steps outlined above, you can easily recreate an older user account and set a new password.

In summary:

Connect as a superuser.

Create any missing users.

Set passwords for those users.

Check for successful logins.

Remember, maintaining a list of your database users and their passwords can save you from future headaches. Happy database managing!