Postgres Pro
Downloads
Home   >   mailing lists

Re: One machine connects, the other doesn't??? - Mailing list pgsql-admin

From Tom Lane
Subject Re: One machine connects, the other doesn't???
Date
Msg-id 22003.1067959150@sss.pgh.pa.us
Whole thread Raw
In response to One machine connects, the other doesn't???  (Jeff <jeffroberts@telus.net>)
List pgsql-admin
Tree view 
Jeff <jeffroberts@telus.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

pgsql-admin by date:

Previous
From: "Jaskier"
Date:
Subject: Re: Forcing pg_dump NOT to use "INSERT..."
Next
From: Tom Lane
Date:
Subject: Re: Forcing pg_dump NOT to use "INSERT..."