Thread: PostgreSQL Connection Problem via TCP/IP socket

Hi,

I have (again) dumb problem with PostgreSQL connection (from PHP) on SuSE 9.1
via tcp/ip socket. I have set "tcpip_socket = true" in postgresql.conf, and
enabled all connections from localhost, and of course, restarted PostgreSQL
server.

Quite strange, I CAN connect to PostgreSQL with Webmin and PhpPgAdmin (with
connection set via UNIX domain socket). However, I CANNOT connect via tcp/ip
socket despite option in postgresql.conf.

Anyone knows what cause this problem?


************************************************
***   with best regards
***   Andrei Verovski (aka MacGuru)
***   Mac, Linux, DTP, Programming Web Site
***
***   http://snow.prohosting.com/guru4mac/
************************************************

"Andrei Verovski (aka MacGuru)" <andreil1@starlett.lv> writes:
> Quite strange, I CAN connect to PostgreSQL with Webmin and PhpPgAdmin (with
> connection set via UNIX domain socket). However, I CANNOT connect via tcp/ip
> socket despite option in postgresql.conf.

Define "cannot connect" --- what happens, exactly?

If nothing happens for awhile and then you get a "connection timed out"
kind of error, then look to see if you have kernel packet filtering
interfering with the connection.

            regards, tom lane