To connect to a database using in Postgres , you need to be provide a password to connect. If you have forgotten the password, please follow the steps below:
Step 1. Edit PostgreSQL config file to establish trust relationship to login without password:
$ vi /var/lib/pgsql/data/pg_hba.conf
# Old Line:
local all postgres password
# Change it to:
local all postgres trust
Step 2. Restart PostgreSQL Server:
You should be able to connect from pgadmin III without a password or any other authentication.
Comments
0 comments
Please sign in to leave a comment.