I would unix su, edit pg_hba.conf to allow open access
temporarily, connect to pg and change the posgres password.
Don't forget to change pg_hba.conf back again to password
protect the db!
TJ
>
> 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)?
>
