From: | Patrick Nelson <pnelson(at)neatech(dot)com> |
---|---|
To: | "PostgreSQL List (E-mail)" <pgsql-general(at)postgresql(dot)org> |
Subject: | Re: Upgrading on RH72 |
Date: | 2002-08-10 21:46:46 |
Message-ID: | 4165C48DE9A0D211B6400800095C585F172E01@WASHINGTON |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-general |
OK got the upgrade installed using
rpm -Fh postgresql*
Everything went ok. The server didn't come up because the data was in a
previous format. Had already run pg_dumpall on the database so I went
straight to moving the old data out of the way:
1. in /var/lib/pgsql/data/ moved the base dir out of the way
2. did a service postgresql start and it said the initialization was OK but
server failed to start
3. in /var/lib/pgsql/ moved the data dir out of the way
4. tried step 2 again and it worked, server started
5. did psql -e template1 < pg-upg-dump.sql which errored saying couldn't
connect to <domain name of server>
6. checked /etc/init.d/postgresql and added the -o "-i" to the startup to
get it to listen
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?
From | Date | Subject | |
---|---|---|---|
Next Message | Lamar Owen | 2002-08-10 21:47:18 | Re: Upgrading on RH72 |
Previous Message | Oliver Elphick | 2002-08-10 21:20:37 | Re: [HACKERS] Linux Largefile Support In Postgresql RPMS |