Re: Recovery using Online Backup+WAL and broken passwords

From: Michael Klatt <tcimk(at)olympus(dot)net>
To:
Cc: pgsql-admin(at)postgresql(dot)org
Subject: Re: Recovery using Online Backup+WAL and broken passwords
Date: 2005-02-04 23:09:25
Message-ID: 420400A5.3000608@olympus.net
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-admin

Tom Lane wrote:
> [ thinks about that... ] Hmm, you're right, there is no mechanism to
> cause the flat password file to be rebuilt after a restore. So newly
> created users won't be in it (and for that matter it won't reflect
> post-backup password changes for existing users). Just (re)assign any
> one user's password and things should be ok.

Great, this gives me a great short-term work-around solution to the
problem. I've verified that setting any user password automatically
fixes all of them.

Do you think a fix will show up in 8.0.2?

Thanks!

Michael

In response to

Browse pgsql-admin by date

  From Date Subject
Next Message Michael Klatt 2005-02-04 23:18:03 Re: Recovery using Online Backup+WAL and broken passwords
Previous Message Jonel Rienton 2005-02-04 22:52:46 Re: Regarding Postgres 8.0 !