Re: [ADMIN] postgres user, forgotten password

2005-02-22 Thread Scott Marlowe
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 ver

Re: [ADMIN] postgres user, forgotten password

2005-02-22 Thread Bruno Wolff III
On Tue, Feb 22, 2005 at 15:07:45 +0100, Zouari Fourat <[EMAIL PROTECTED]> 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 auth

[ADMIN] postgres user, forgotten password

2005-02-22 Thread Zouari Fourat
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