PostgreSQL change user password

Preamble

A PostgreSQL database’s user password can change using the ALTER USER operator.

The syntax for changing the password with ALTER USER statement in PostgreSQL

ALTER USER user_name
WITH [ ENCRYPTED | UNENCRYPTED ] PASSWORD 'new_password'
| VALID UNTIL 'expiration';

Parameters and arguments of the statement

• user_name – User whose password you want to change.
• new_password – The user will give a new password.
• expiration – date/time when the password expires. If you do not want your password to expire, set it to ‘infinity’.

Example of using an ALTER USER operator

Consider an example that shows how to use the ALTER USER operator in PostgreSQL to change the password.
For example, if you want to update a user with the Zorg username and password zub*a*stik, you must execute the following ALTER USER operator in PostgreSQL:

ALTER USER zorg
WITH PASSWORD 'zub*a*stik';

If you want to set a password for user Zorg, which expires on January 1, 2020, use the ALTER USER operator as follows:

ALTER USER zorg
VALID UNTIL 'Jan 1, 2020';

If you want the password for a trizor user never to expire, you must use the ALTER USER operator as follows:

ALTER USER trizor
VALID UNTIL 'infinity';

PostgreSQL Change PostgreSQL password

About Enteros

Enteros offers a patented database performance management SaaS platform. It proactively identifies root causes of complex business-impacting database scalability and performance issues across a growing number of clouds, RDBMS, NoSQL, and machine learning database platforms.