| From: | Alvaro Herrera <alvherre(at)atentus(dot)com> |
|---|---|
| To: | Patrick Nelson <pnelson(at)neatech(dot)com> |
| Cc: | "PostgreSQL List (E-mail)" <pgsql-general(at)postgresql(dot)org> |
| Subject: | Re: Upgrading on RH72 |
| Date: | 2002-08-10 21:57:01 |
| Message-ID: | Pine.LNX.4.44.0208101753280.13280-100000@cm-lcon1-46-187.cm.vtr.net |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Thread: | |
| Lists: | 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"
| From | Date | Subject | |
|---|---|---|---|
| Next Message | James West | 2002-08-10 22:28:39 | postgres 7.2.1 and PAM |
| Previous Message | Lamar Owen | 2002-08-10 21:47:18 | Re: Upgrading on RH72 |