Change Postgres Password

 

To change the the postgres user’s password follow this steps

1. Login into the psql:

$ sudo -u postgres psql

2. Then in the psql console change the password and quit:

postgres=# password postgres
Enter new password: <new-password>
postgres=# q