How to change root password for PostgreSql phpPgAdmin?

Question

What is the simplest way to change root password for PostgreSql phpPgAdmin ?

Solution 1

# sudo su - postgres
# psql -d template1
template1=# ALTER USER postgres WITH PASSWORD 'new password';
# service postgresql restart

Solution 2

• sudo su - postgres
• psql
• \password postgres
• TYPE THE POSTGRES PASSWORD
• \q
• exit

Comments

[VinoCoder]

Please add explanation for the commands :)