Viewing your PostgreSQL password, is going to be much like viewing your MySQL password with slight changes. Please see below for more information:
If you wish to view your PostgreSQL root password, you can. Please do the following:
- Login to your SSH (Secure Shell)
- Run the following command # cat /root/.pgpass
- It should show you something that looks like this:
Password = **************
That's it! You're your PostgreSQL root password is mentioned above.