the entry should like
host all all 192.168.1.77/32 password
host all all 192.168.1.0/24 password
do not forget to reload the server (pg_ctl reload) when making changes
try connecting to the DB manually from the webserver
psql -h <hostname> <dbname> -U <username>
if you still have problems change the setting password to trust and try
again to make sure the problem is related to the network and not to the
JORGE MALDONADO wrote:
> I am writing a web app which should connect to a database in a server
> within my personal network but I am having trouble. I get the
> following error message:
> There is no record on pg_hba.conf for 192.168.1.77, user postgres,
> database restaurant, SSL inactive.
> I have checked the configuration files on the server machine as follows:
> * The listen_addresses parameter in postgresql.conf equals *.
> * The pg_hba.conf has an entry of type=host, database=all, user=all,
> IP-Address=192.168.1.77/32 <http://192.168.1.77/32>, Password=md5.
> I have tried changing the IP-Address to 192.168.1.0/24
> <http://192.168.1.0/24> and 192.168.0.0/16 <http://192.168.0.0/16>;
> also I tried Password=Trust and Password=Password.
> What else can I check?
> Jorge Maldonado
In response to
pgsql-novice by date
|Next:||From: Machiel Richards||Date: 2010-05-27 09:28:12|
|Subject: Setting up postgresql-8.3 on Debian|
|Previous:||From: A. Kretschmer||Date: 2010-05-27 06:53:07|
|Subject: Re: UNABLE TO CONNECT TO A DATABASE IN A WEB SERVER.|