client connection problem

From: Rasmus Mohr <rmo(at)Netpointers(dot)com>
To: "'pgsql-admin(at)postgresql(dot)org'" <pgsql-admin(at)postgresql(dot)org>
Subject: client connection problem
Date: 2002-01-16 13:52:03
Message-ID: 910513A5A944D5118BE900C04F67CB5A0BFD01@MAIL
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-admin

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 : rmo(at)netpointers(dot)com

Responses

Browse pgsql-admin by date

  From Date Subject
Next Message Nick Fankhauser 2002-01-16 14:14:43 Re: client connection problem
Previous Message Jeff Boes 2002-01-16 13:39:43 Re: VACUUM ANALYZE--how often?