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?
