Thread: losing db user password going from 7.4 to 8.2
Hello List, I am doing a pg_dumpall -c on 7.4. I then use psql to load into 8.2 everything seems to be right except my db user passwords don't work anymore. What am I missing. I have already tried starting 8.2 postgres with both #password_encryption = on password_encryption = off then reloading the database dump. Thanks, Steve
On Jan 17, 2008 10:35 AM, Steve Clark <sclark@netwolves.com> wrote: > Hello List, > > I am doing a pg_dumpall -c on 7.4. > I then use psql to load into 8.2 everything seems to be right except my > db user passwords don't work anymore. > > What am I missing. > What error message are you getting?
Scott Marlowe wrote: > On Jan 17, 2008 10:35 AM, Steve Clark <sclark@netwolves.com> wrote: > >>Hello List, >> >>I am doing a pg_dumpall -c on 7.4. >>I then use psql to load into 8.2 everything seems to be right except my >>db user passwords don't work anymore. >> >>What am I missing. >> > > > What error message are you getting? > > Duh - my bad - my browser had the wrong password in it - so i thought things were broken. Sorry for the noise - as he hides his head in shame. Steve