upgrading postgresql from 7.2 to 7.3, getting error

From: Adam Williams <awilliam(at)mdah(dot)state(dot)ms(dot)us>
To: pgsql-general(at)postgresql(dot)org
Subject: upgrading postgresql from 7.2 to 7.3, getting error
Date: 2004-04-14 21:07:22
Message-ID: 407DA80A.5020503@mdah.state.ms.us
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

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?

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Dennis Gearon 2004-04-14 22:42:59 when restoring or loading
Previous Message Tom Lane 2004-04-14 20:53:00 Re: [HACKERS] Remove MySQL Tools from Source?