Re: Recovery using Online Backup+WAL and broken passwords - Mailing list pgsql-admin

From Michael Klatt
Subject Re: Recovery using Online Backup+WAL and broken passwords
Date
Msg-id 420402AB.5060202@olympus.net
Whole thread Raw
In response to Re: Recovery using Online Backup+WAL and broken passwords  (Tom Lane <tgl@sss.pgh.pa.us>)
Responses Re: Recovery using Online Backup+WAL and broken passwords
List 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

pgsql-admin by date:

Previous
From: Jonel Rienton
Date:
Subject: Re: Regarding Postgres 8.0 !
Next
From: Tom Lane
Date:
Subject: Re: Recovery using Online Backup+WAL and broken passwords