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

From: Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
To: jeffroberts(at)telus(dot)net
Cc: pgsql-admin(at)postgresql(dot)org
Subject: Re: One machine connects, the other doesn't???
Date: 2003-11-04 15:19:10
Message-ID: 22003.1067959150@sss.pgh.pa.us
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-admin

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

In response to

Responses

Browse pgsql-admin by date

  From Date Subject
Next Message Rob Fielding 2003-11-04 15:27:23 PGSQL Mailing List Reply-To field
Previous Message Jaskier 2003-11-04 15:03:46 Re: Forcing pg_dump NOT to use "INSERT..."