Re: Upgrading on RH72
От | Patrick Nelson |
---|---|
Тема | Re: Upgrading on RH72 |
Дата | |
Msg-id | 4165C48DE9A0D211B6400800095C585F172E01@WASHINGTON обсуждение исходный текст |
Ответ на | Upgrading on RH72 (Patrick Nelson <pnelson@neatech.com>) |
Ответы |
Re: Upgrading on RH72
Re: Upgrading on RH72 |
Список | 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?
В списке pgsql-general по дате отправления: