Re: client connection problem

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 nickf(at)ontko(dot)com Phone 1.765.935.4283 Fax 1.765.962.9788
Ray Ontko & Co. Software Consulting Services http://www.ontko.com/

> -----Original Message-----
> From: pgsql-admin-owner(at)postgresql(dot)org
> [mailto:pgsql-admin-owner(at)postgresql(dot)org]On Behalf Of Rasmus Mohr
> Sent: Wednesday, January 16, 2002 8:52 AM
> To: 'pgsql-admin(at)postgresql(dot)org'
> 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 : rmo(at)netpointers(dot)com
>
> ---------------------------(end of broadcast)---------------------------
> TIP 1: subscribe and unsubscribe commands go to majordomo(at)postgresql(dot)org
>