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

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