Re: Upgrading on RH72 - Mailing list pgsql-general

From Alvaro Herrera
Subject Re: Upgrading on RH72
Date
Msg-id Pine.LNX.4.44.0208101753280.13280-100000@cm-lcon1-46-187.cm.vtr.net
Whole thread Raw
In response to Re: Upgrading on RH72  (Patrick Nelson <pnelson@neatech.com>)
List pgsql-general
Patrick Nelson dijo:

> 7. tried step 5 again, but this time the error is:
>     psql: FATAL 1: No pg_hba.conf entry for host xxx.xxx.xxx.122, user root,
> database template1
> xxx.xxx.xxx.122 is the IP of the pg server that I'm working on
>
> How do I move forward if I can not get past this to ever start restoring?

You have to modify pg_hba.conf (should be in /var/lib/pgsql/data) and
add a line for xxx.xxx.xxx.122 as the comments in the file show.  Note
that is it not usually considered wise to do this kind of thing using
``root''.

Maybe you can just restore the pg_hba.conf that was in the old data
directory (you probably will need to anyway).

--
Alvaro Herrera (<alvherre[a]atentus.com>)
"El dia que dejes de cambiar dejaras de vivir"


pgsql-general by date:

Previous
From: Lamar Owen
Date:
Subject: Re: Upgrading on RH72
Next
From: James West
Date:
Subject: postgres 7.2.1 and PAM