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