From: | Tuna Chatterjee <tchatter(at)alert(dot)infoplease(dot)com> |
---|---|
To: | pgsql-novice(at)postgresql(dot)org |
Subject: | 7.2 upgrade |
Date: | 2002-02-20 22:05:52 |
Message-ID: | 1014242753.14228.42.camel@steamer.infoplease.com |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-novice |
hi all,
i'm pretty new to postgres, and thus the post to novice.
i tried to perform an upgrade to 7.2 today and have run into some
problems at the very end of the process.
after making 2 pg_dumpalls (one for globals and one for the data),
stopping postgresql, installing the appropriate 7.2 rpms, and then
starting postgresql again, i tried to put the data dumps back in and had
an error thrown back at me.
here's what i did pre install:
sudo -u postgres pg_dumpall -g -h myDB > /u/tchatter/globals_dbdump.txt
sudo -u postgres pg_dumpall -o -h myDB > /u/tchatter/all_dbdump.txt
post install:
sudo -u postgres /usr/bin/psql -d template1 -f
/u/tchatter/globals_dbdump.txt
sudo -u postgres /usr/bin/psql -d template1 -f
/u/tchatter/all_dbdump.txt
at which point i got:
psql:/u/tchatter/all_dbdump.txt:323: \connect: FATAL 1: IDENT
authentication failed for user "karl"
so i figured that something was wrong with the pg_hba.conf file
but i'm not quite sure what i'm looking for in order to correct it.
i'd appreciate any pointers for where to look next.
thanks!
tuna
From | Date | Subject | |
---|---|---|---|
Next Message | Josh Berkus | 2002-02-20 22:18:02 | Re: 7.2 upgrade |
Previous Message | Jon Hassen | 2002-02-20 21:57:32 | Adding CLUSTERING removed my indexes |