Skip site navigation (1) Skip section navigation (2)

Re: [INTERFACES] connecting: unix socket? Yes. TCPIP port? No. -i? Yes.

From: Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
To: Bob VonMoss <bvonmoss(at)bigfoot(dot)com>
Cc: pgsql-interfaces(at)postgreSQL(dot)org
Subject: Re: [INTERFACES] connecting: unix socket? Yes. TCPIP port? No. -i? Yes.
Date: 1999-02-06 19:01:39
Message-ID: 20420.918327699@sss.pgh.pa.us (view raw or flat)
Thread:
Lists: pgsql-generalpgsql-interfaces
Bob VonMoss <bvonmoss(at)bigfoot(dot)com> writes:
> [ can connect via unix socket, but not via TCP ]

> The administrator says this is how postmaster is invoked:
> /usr/local/pgsql/bin/postmaster -S -i -D /usr/local/pgsql/data -p 5432

OK, that eliminates the "forgot -i" gotcha.

James Thompson is almost certainly right that the problem is that
Postgres' pg_hba.conf file is not set up to allow connections from
whichever IP address you are connecting from.

We heard about a similar problem recently which turned out to be
due to use of "virtual server" IP addresses.  I've forgotten now
whether Postgres saw the connection as coming from the virtual IP
address or the underlying machine's real address, but anyway it wasn't
what the user was expecting :-(.

			regards, tom lane

Responses

pgsql-interfaces by date

Next:From: Pete (Linux)Date: 1999-02-06 23:45:23
Subject: JDBC-JServ Servlet problem
Previous:From: KoPra WorkshopDate: 1999-02-06 09:00:26
Subject: postmaster confiugration and hardware configuration

pgsql-general by date

Next:From: Jonny HinojosaDate: 1999-02-06 19:13:24
Subject: No MAX function
Previous:From: Gu fengDate: 1999-02-06 13:31:41
Subject:

Privacy Policy | About PostgreSQL
Copyright © 1996-2014 The PostgreSQL Global Development Group