| 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: | Whole Thread | Raw Message | 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?
| 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? |