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 420400A5.3000608@olympus.net
Whole thread Raw
In response to Re: Recovery using Online Backup+WAL and broken passwords  (Tom Lane <tgl@sss.pgh.pa.us>)
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: Robby Russell
Date:
Subject: Re: [GENERAL] PHP/PDO Database Abstraction Layer
Next
From: "Chris Hoover"
Date:
Subject: pg_restore question