Fwd: resetting superuser password

From: "Marc A(dot) Donis" <mad7(at)runbox(dot)com>
To: pgsql-admin(at)postgresql(dot)org
Subject: Fwd: resetting superuser password
Date: 2005-11-09 12:38:24
Message-ID: E1EZpDc-0001mP-2c@garm.runbox.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-admin

I have lost the superuser (user postgres) password, but I still have the unix root password. Is there anything I can do to reset the postgres user's password (short of reinstalling Postgres)?

Obviously, I can su to unix user postgres, but this does not seem to advance my cause, as doing "psql -U postgres" still prompts me for a password, which is not the same as the unix postgres user's password.

OS: RedHat 9

Help!

Thanks,
Marc

Responses

Browse pgsql-admin by date

  From Date Subject
Next Message Devrim GUNDUZ 2005-11-09 12:44:25 Re: Fwd: resetting superuser password
Previous Message Rafael Martinez Guerrero 2005-11-09 11:57:25 Re: upgrade from 8.0.3 to 8.1.0