Now I am going to show you something amazing solution for this problem.
Guys, Can you believe that PostgreSQL store it’s postgres super user password into plain text.
Wow, If it is in plain text then its very easy to change.
I have found that there are many ways to reset postgres super user password like, editing pg_hba.conf file but this change is require to restart postgres service. I have found this kind of solution on internet from different source.
But, I am wondering something about the new solution.
This amazing solution for the windows postgres user is , to change content of pgpass.conf file.
I read document of PostgreSQL organization and found postgres storing all passwords as a plain text into pgpass.conf.
Now time to search this file in our windows storage directory.
I found this file in :
C:\Document and Settings\..\Application Data\postgresql\pgpass.conf
- You can find your postgres super user password in this file.
- If you find blank file then please write your new password in this file and this password will work for postgres super user
Please note, this password is only for client side location after reset this you can connect your pgadmin tool.
Please share your ideas and opinions about this topic with me, your contribution will add true value to this topic.
If anyone has doubts on this topic then please do let me know by leaving comments or send me an email.
If you like this post, then please share it with others.
Please follow dbrnd.com, I will share my experience towards the success of Database Research and Development Activity.
I put up a post every day, please keep reading and learning.
Discover Yourself, Happy Blogging !
Anvesh M. Patel.