Re: One machine connects, the other doesn't???

Thanks Tom!

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 <jeffroberts(at)telus(dot)net> 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
>