Re: [GENERAL] losing db user password going from 7.4 to 8.2

2008-01-17 Thread Steve Clark
Scott Marlowe wrote: On Jan 17, 2008 10:35 AM, Steve Clark <[EMAIL PROTECTED]> 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

Re: [GENERAL] losing db user password going from 7.4 to 8.2

2008-01-17 Thread Scott Marlowe
On Jan 17, 2008 10:35 AM, Steve Clark <[EMAIL PROTECTED]> 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?

[GENERAL] losing db user password going from 7.4 to 8.2

2008-01-17 Thread Steve Clark
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 reloadin