Re: postgres user, forgotten password - Mailing list pgsql-admin

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;