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