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
---------------------------(end of broadcast)--------------------------- TIP 8: explain analyze is your friend
