Re: Upgrading on RH72

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?