Re: Network Connection Problem

Joe,

> I am trying to setup a fresh install of Postgresql 7.2.1 on a fresh install
> of Debian Woody. I am using the debian version of Postgresql. I have
> enabled set tcpip_socket = 1 in the postgresql.conf file and verified the
> postmaster is running with the -i option. I have also added the line
> host all 192.168.100.34 255.255.255.0 trust
> to my pg_hba.conf file. For good measure, I also restarted the server. I
> have no problems connecting locally, but if I attempt to connect remotely, I
> get the error No pg_hba.conf entry for host 192.168.100.34, user postgres,
> database template1. I have tried it with the netmask set to 255.255.255.255
> as well.

As of 7.2, after changing the pg_hba.conf file, you have to restart Postgres
to utilize the changes. This is an annoying change of behavior which was
made to speed up connection creation (which it did).

--
-Josh Berkus

______AGLIO DATABASE SOLUTIONS___________________________
Josh Berkus
Complete information technology josh(at)agliodbs(dot)com
and data management solutions (415) 565-7293
for law firms, small businesses fax 621-2533
and non-profit organizations. San Francisco