SEO

permalink · #1 (**permalink**) 04-10-2008, 12:25 AM

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

---------------------------(end of broadcast)---------------------------
TIP 9: the planner will ignore your desire to choose an index scan if your
joining column's datatypes do not match

permalink · #2 (**permalink**) 04-10-2008, 12:25 AM

On Tue, Feb 22, 2005 at 15:07:45 +0100,
Zouari Fourat <fourat@gmail.com> 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

Edit pg_hba.conf to use trust or ident authentication for "postgres".
You probably want to make sure there is no external access to the database
while doing this.

SELECT usename FROM pg_user;

---------------------------(end of broadcast)---------------------------
TIP 2: you can get off all lists at once with the unregister command
(send "unregister YourEmailAddressHere" to majordomo@postgresql.org)

permalink · #3 (**permalink**) 04-10-2008, 12:25 AM

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.

---------------------------(end of broadcast)---------------------------
TIP 4: Don't 'kill -9' the postmaster

Thread Tools
Show Printable Version Email this Page
Display Modes
Linear Mode Switch to Hybrid Mode Switch to Threaded Mode

SEO

postgres user, forgotten password