Обсуждение: upgrading postgresql from 7.2 to 7.3, getting error
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?
Adam Williams <awilliam@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
thank you that worked :) Tom Lane wrote: >Adam Williams <awilliam@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 > > >