Knowledge Base Hub

Browse through our helpful how-to guides to get the fastest solutions to your technical issues.

Home  >  How-Tos  >  How to change a password for PostgreSQL on Linux via Command line?
Top Scroll

How to change a password for PostgreSQL on Linux via Command line?

 2 min

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.


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

su - postgres

Now, attempt to connect to PostgreSQL :


At the prompt, enter your password


The correct and valid response will be similar to :

psql (9.3.9)
Type "help" for help.


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 :


Enter your new password. Re-enter it to confirm.

Enter new password:
Enter it again:

Now quit the PostgreSQL interface using the following command :


Tip :

You can perform all the above-mentioned steps in only one command :

su -c "psql" - postgres

That’s it.

Also Read :

Learn to Install PostgreSQL on Ubuntu 18.04

How To Install Chkrootkit Security Scanner On Ubuntu 18.04

For our Knowledge Base visitors only
Get 10% OFF on Hosting
Special Offer!
Claim the discount before it’s too late. Use the coupon code:
Note: Copy the coupon code and apply it on checkout.