Re: resetting superuser password

From: TJ O'Donnell <tjo(at)acm(dot)org>
To:
Cc: pgsql-general(at)postgresql(dot)org, mad7(at)runbox(dot)com
Subject: Re: resetting superuser password
Date: 2005-11-09 16:13:56
Message-ID: 43722044.6050201@acm.org
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

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)?
>

Browse pgsql-general by date

  From Date Subject
Next Message Harald Fuchs 2005-11-09 16:14:35 Re: newbie design question re impact of VACUUM
Previous Message codeWarrior 2005-11-09 16:08:42 Re: insert on duplicate update?