PostgreSQL Connection Problem via TCP/IP socket

[Andrei Verovski (aka MacGuru)]

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/
************************************************

---------------------------(end of broadcast)---------------------------
TIP 6: Have you searched our list archives?

http://archives.postgresql.org

[Tom Lane]

Post by Andrei Verovski (aka MacGuru)
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

---------------------------(end of broadcast)---------------------------
TIP 7: don't forget to increase your free space map settings