PostgreSQL is known for supporting many client authentication methods, so, in this case, we will only be concerned about two : (i) password and (ii) md5.
Prerequisites:
1) The instruction is specially used for changing a password in PostgreSQL.
2) The instructions are performed by using a MilesWeb Core Managed CentOS 7 server and we are logged in a root.
3) PostgreSQL is already installed.
Step 1: Switch to the PostgreSQL user: postgres
N case you are working from a default PostgreSQL installation, then PostgreSQL will be configured with the user postgres.
As we are logged in as root, it can be assumed that root doesn’t have a user for PostgreSQL, switch to the default PostgreSQL user: postgres
1 |
su - postgres |
Now, attempt to connect to PostgreSQL :
1 |
psql |
At the prompt, enter your password
1 |
Password: |
The correct and valid response will be similar to :
1 2 3 4 |
psql (9.3.9) Type "help" for help. postgres=# |
Step 2: Add and Change the password for the PostgreSQL user: postgres
Using the following command you can change the password for your current user, which is now postgres :
1 |
\password |
Enter your new password. Re-enter it to confirm.
1 2 |
Enter new password: Enter it again: |
Now quit the PostgreSQL interface using the following command :
1 |
\q |
Tip :
You can perform all the above-mentioned steps in only one command :
1 |
su -c "psql" - postgres |
That’s it.
Also Read :