Sometimes we can forget main password for PostgreSQL.
We should edit config file:
|
1 2 3 |
vim /etc/postgresql/<version>/main/pg_hba.conf local all postgres peer |
Restart postgresql service, so the configuration will take affect:
|
1 |
service postgres restart |
Login on postgresql:
|
1 2 3 4 |
postgres psql #set new password ALTER USER postgres PASSWORD 'new_password'; |
Remember to recover original setting of pg_hba.conf
