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


Leave a Reply

Your email address will not be published. Required fields are marked *