25th Anniversary Savings | 25% Off Dedicated Servers*Shop Now
25th Anniversary Savings | 25% Off VPS Hosting* †††Shop Now
Limited Inventory: High-Performance AMD-Powered Servers Now Available.* Shop Now >
Dedicated Hosting Deals | From $99/moShop Now
Reading Time: 2 minutes

PostgreSQL supports many client authentication methods, but in this case we’re only going to concern ourselves with two: password and md5.

Note: The default authentication method for PostgreSQL is ident. If you’d like to change the PostgreSQL authentication method from ident to md5, then visit the linked tutorial!

Change a Password for PostgreSQL on Linux via Command Line

Before Getting Started

  • These instructions are intended specifically for changing a password in PostgreSQL.
  • I’ll be working from a Liquid Web Core Managed CentOS 7 server, and I’ll be logged in as root.
  • PostgreSQL is installed per our tutorial on: How to Install and Connect to PostgreSQL on CentOS 7.

Step #1: Switch to the PostgreSQL User: postgres

If you’re working from a default PostgreSQL installation, then PostgreSQL will be configured with the user postgres.

Since we’re logged in as root, and we’re assuming that root doesn’t have a user for PostgreSQL, switch to the default PostgreSQL user: postgres.

su - postgres

… then attempt a connection to PostgreSQL.

psql

… enter your password at the prompt.

Password:

… the correct, valid response will be similar to the following.

psql (9.3.9)
Type "help" for help.


postgres=#

Step #2: Add/Change the PostgreSQL Password for the User: postgres

Use the following command to change the PostgreSQL password for your current user, which is now postgres.

\password

Enter your new password, and then enter it again to confirm it.

Enter new password:
Enter it again:

Now quit the PostgreSQL interface.

\q

Bonus Information!

You can do all of step one in exactly one command.

su -c "psql" - postgres

Avatar for Justin Palmer

About the Author: Justin Palmer

Justin Palmer is a professional application developer with Liquid Web

Latest Articles

How to Install the Pip Package Manager on AlmaLinux

Read Article

cPanel EA NGINX vs Engintron: What is the Best Option?

Read Article

cPanel EA NGINX vs Engintron: What is the Best Option?

Read Article

Troubleshooting: Too Many Redirects

Read Article

What Is a Time Series Database? How It Works & Use Cases

Read Article