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?