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[color=blue]
> sroom1 and then after installing 7.3 I ran psql template1 < sroom1[/color]
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 YourEmailAddres sHere" to majordomo@postg resql.org)

[Tom Lane]

Re: upgrading postgresql from 7.2 to 7.3, getting error

Adam Williams <awilliam@mdah. state.ms.us> writes:[color=blue]
> 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[color=green][color=darkred]
>>> sroom1 and then after installing 7.3 I ran psql template1 < sroom1[/color][/color]
> but when I run that after a bunch of grants, revokes, etc, it prints the
> error:[/color]
[color=blue]
> \connect: FATAL 1: IDENT authentication failed for user "jtate"[/color]

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]

Re: upgrading postgresql from 7.2 to 7.3, getting error

thank you that worked :)

Tom Lane wrote:
[color=blue]
>Adam Williams <awilliam@mdah. state.ms.us> writes:
>
>[color=green]
>>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
>>
>>[color=darkred]
>>>>sroom1 and then after installing 7.3 I ran psql template1 < sroom1
>>>>
>>>>[/color]
>>but when I run that after a bunch of grants, revokes, etc, it prints the
>>error:
>>
>>[/color]
>
>
>[color=green]
>>\connect: FATAL 1: IDENT authentication failed for user "jtate"
>>
>>[/color]
>
>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
>
>
>[/color]



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

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