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