Re: postgres user, forgotten password

From: Scott Marlowe <smarlowe(at)g2switchworks(dot)com>
To: Zouari Fourat <fourat(at)gmail(dot)com>
Cc: pgsql-admin(at)postgresql(dot)org
Subject: Re: postgres user, forgotten password
Date: 2005-02-22 15:46:46
Views: Raw Message | Whole Thread | Download mbox | Resend email
Lists: pgsql-admin

On Tue, 2005-02-22 at 08:07, Zouari Fourat wrote:
> Hello,
> i forgot the postgres user password, how to resolve this problem.
> once i have my postgres user working, how to list all users on the server ?
> thanks a bunch

First off, PostgreSQL stores passwords as md5 hashes (well, the last few
versions do anyway) so you won't be able to retrieve the password,
although a brute force md5 cracker might be able to eventually guess it
if it isn't too complex.

However, the standard way I use for getting back in is:

edit pg_hba.conf and set it to have an entry for local all all trust at
the top. restart postgresql. Log in as postgres (psql template1 -U
postgres) change the postgres password. Edit pg_hba.conf and get rid of
the trust line, restart postgres, psql template1 -U postgres to get back
in, and use select * from pg_shadow to see all the usernames.

In response to

Browse pgsql-admin by date

  From Date Subject
Next Message Dick Davies 2005-02-22 16:14:23 Re: pg_hba.conf
Previous Message Zouari Fourat 2005-02-22 15:35:49 psql work but not phppgadmin neither pgadmin3