Resetting main PostgreSQL password

Sometimes we can forget main password for PostgreSQL.

We should edit config file:

Restart postgresql service, so the configuration will take affect:

Login on postgresql:

Remember to recover original setting of pg_hba.conf

Facebooktwittergoogle_plusreddit