Rasmus- Try adding a line to pg_hba.conf for localhost specifically- I'd guess that the request is coming in with that address rather than the local machine's IP address.
use a line like this: host all 127.0.0.1 255.0.0.0 trust -Nick -------------------------------------------------------------------------- Nick Fankhauser [EMAIL PROTECTED] Phone 1.765.935.4283 Fax 1.765.962.9788 Ray Ontko & Co. Software Consulting Services http://www.ontko.com/ > -----Original Message----- > From: [EMAIL PROTECTED] > [mailto:[EMAIL PROTECTED]]On Behalf Of Rasmus Mohr > Sent: Wednesday, January 16, 2002 8:52 AM > To: '[EMAIL PROTECTED]' > Subject: [ADMIN] client connection problem > > > Hmmm... I've installed PostgreSQL 7.1.3 with the Red Hat 7.2 installation > package, and everything works fine when connecting from localhost as the > postgres user, but when I try to connect via TCP I get the usual > "connectDBStart() -- ..." error suggesting that postmaster was started > without the "-i" option. > > "-i" is added to /etc/init.d/postgresql - a "ps ax | grep postmaster" > confirms this. The pg_hba.conf has modified to allow incoming connections > from the subnet, as shown > > ... > host all 192.168.1.164 255.255.255.0 trust > host all 192.168.1.150 255.255.255.0 trust > host all 192.168.1.0 255.255.255.0 trust > ... > > and I've set "tcpip_socket=true" in the postgresql.conf file... > > Yet I'm unable to establish a connection - what is wrong? > > (nmap confirms that postgresql is listening at port 5432) > > ----------------------------------------------------------- > Rasmus T. Mohr Phone : +45 70 117 117 > Application Developer Direct : +45 36 910 122 > Netpointers Intl. Mobile : +45 28 731 827 > Vestergade 18 B Website : www.netpointers.com > 1456 Copenhagen K Email : [EMAIL PROTECTED] > > ---------------------------(end of broadcast)--------------------------- > TIP 1: subscribe and unsubscribe commands go to [EMAIL PROTECTED] > ---------------------------(end of broadcast)--------------------------- TIP 6: Have you searched our list archives? http://archives.postgresql.org
