upgrading postgresql from 7.2 to 7.3, getting error

[Adam Williams]

Hi, as my title states I'm trying to upgrade from 7.2 to 7.3 on redhat
linux 9. I've been following the documentation instructions on the
website but ran into problems. I searched on google but could not find
my answer. On postgresql as user postgres I ran the command pg_dumpall

sroom1 and then after installing 7.3 I ran psql template1 < sroom1

but when I run that after a bunch of grants, revokes, etc, it prints the
error:

\connect: FATAL 1: IDENT authentication failed for user "jtate"

I tried playing around with my pg_hba.conf file to have it "local all
all ident sameuser" right now, i've tried other variations such as
taking out sameuser, one of the alls, pam , i have identd running on the
server as well and hosts.allow setup properly for identd. The user
jtate does exist on the computer (normal unix password account). any
suggestions, thanks?
---------------------------(end of broadcast)---------------------------
TIP 2: you can get off all lists at once with the unregister command
(send "unregister YourEmailAddressHere" to ma*******@postgresql.org)

[Tom Lane]

Adam Williams <aw******@mdah.state.ms.us> writes:

Hi, as my title states I'm trying to upgrade from 7.2 to 7.3 on redhat
linux 9. I've been following the documentation instructions on the
website but ran into problems. I searched on google but could not find
my answer. On postgresql as user postgres I ran the command pg_dumpall

sroom1 and then after installing 7.3 I ran psql template1 < sroom1

but when I run that after a bunch of grants, revokes, etc, it prints the
error:

\connect: FATAL 1: IDENT authentication failed for user "jtate"

Your best bet is to switch the authentication mode to "trust" for long
enough to load the dump file. 7.2's pg_dump tends to use
"\connect - otheruser" to switch object ownership, and this will not
work when you are using IDENT authorization.

regards, tom lane

---------------------------(end of broadcast)---------------------------
TIP 8: explain analyze is your friend

[Adam Williams]

thank you that worked :)

Tom Lane wrote:

Adam Williams <aw******@mdah.state.ms.us> writes:

Hi, as my title states I'm trying to upgrade from 7.2 to 7.3 on redhat
linux 9. I've been following the documentation instructions on the
website but ran into problems. I searched on google but could not find
my answer. On postgresql as user postgres I ran the command pg_dumpall

sroom1 and then after installing 7.3 I ran psql template1 < sroom1

but when I run that after a bunch of grants, revokes, etc, it prints the
error:

\connect: FATAL 1: IDENT authentication failed for user "jtate"

Your best bet is to switch the authentication mode to "trust" for long
enough to load the dump file. 7.2's pg_dump tends to use
"\connect - otheruser" to switch object ownership, and this will not
work when you are using IDENT authorization.

regards, tom lane

---------------------------(end of broadcast)---------------------------
TIP 8: explain analyze is your friend

---------------------------(end of broadcast)---------------------------
TIP 5: Have you checked our extensive FAQ?

http://www.postgresql.org/docs/faqs/FAQ.html