Re: Upgrading on RH72
От | Patrick Nelson |
---|---|
Тема | Re: Upgrading on RH72 |
Дата | |
Msg-id | 4165C48DE9A0D211B6400800095C585F172E02@WASHINGTON обсуждение исходный текст |
Ответ на | Upgrading on RH72 (Patrick Nelson <pnelson@neatech.com>) |
Ответы |
Re: Upgrading on RH72
Re: Upgrading on RH72 |
Список | pgsql-general |
Lamar Owen wrote: ----------------->>>> You shouldn't do that. Edit postgresql.conf (in /var/lib/pgsql/data) to do this -- uncomment the tcpip_socket line and set it to true. This is documented in /usr/share/doc/postgresql-7.2.1/README.rpm-dist Did you make a copy of your previous pg_hba.conf? It gets overwritten during initdb. You will need to edit it. ----------------->>>> Thanks Alvaro and Lamar! Cool changed that startup thing as suggested. Yes have a copy of pg_hba.conf, format doesn't seem to have changed... I have simply host based access like: local all trust host all 127.0.0.1 255.255.255.255 trust host all xxx.xxx.xxx.0 255.255.0.0 trust A "service postgresql restart" and "psql -e template1 < pg-upg-dump.sql" errors a bit differently: psql: FATAL 1: user "root" does not exist Any ideas on this one?
В списке pgsql-general по дате отправления: