By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
464,828 Members | 1,140 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 464,828 IT Pros & Developers. It's quick & easy.

upgrading postgresql from 7.2 to 7.3, getting error

P: n/a
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)

Nov 23 '05 #1
Share this Question
Share on Google+
2 Replies

P: n/a
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

Nov 23 '05 #2

P: n/a
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

Nov 23 '05 #3

This discussion thread is closed

Replies have been disabled for this discussion.