I was editing /usr/local/pgsql/data/pg_hba.conf when I should have been editing /var/lib/pgsql/data/pg_hba.conf
Now everything works.
Jeff
Tom Lane wrote:
Jeff <[EMAIL PROTECTED]> writes:
I get:
psql: FATAL 1: No pg_hba.conf entry for host 192.168.24.4, user ownerofmydatabase, database mydatabase
My pg_hba.conf file has two lines
local all trust host all 192.168.24.0 255.255.255.0 password
Hm. Are you sure you are looking at the right pg_hba.conf file? Did you SIGHUP the postmaster after your latest change to pg_hba.conf? Try looking in the postmaster log to see if it emits any complaints about syntax problems in pg_hba.conf when you SIGHUP it and/or connect.
regards, tom lane
---------------------------(end of broadcast)--------------------------- TIP 8: explain analyze is your friend
---------------------------(end of broadcast)---------------------------
TIP 3: if posting/reading through Usenet, please send an appropriate
subscribe-nomail command to [EMAIL PROTECTED] so that your
message can get through to the mailing list cleanly
