pg.ddx.io pgsql-admin@postgresql.org mailing list archive
help / color / mirror / Atom feedPostgreSQL Connection Problem via TCP/IP socket
2+ messages / 2 participants
[nested] [flat]
* PostgreSQL Connection Problem via TCP/IP socket
@ 2004-06-05 19:02 Andrei Verovski (aka MacGuru) <andreil1@starlett.lv>
0 siblings, 1 reply; 2+ messages in thread
From: Andrei Verovski (aka MacGuru) @ 2004-06-05 19:02 UTC (permalink / raw)
To: pgsql-admin
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/
************************************************
^ permalink raw reply [nested|flat] 2+ messages in thread
* Re: PostgreSQL Connection Problem via TCP/IP socket
@ 2004-06-06 21:37 Tom Lane <tgl@sss.pgh.pa.us>
parent: Andrei Verovski (aka MacGuru) <andreil1@starlett.lv>
0 siblings, 0 replies; 2+ messages in thread
From: Tom Lane @ 2004-06-06 21:37 UTC (permalink / raw)
To: Andrei Verovski (aka MacGuru) <andreil1@starlett.lv>; +Cc: pgsql-admin
"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
^ permalink raw reply [nested|flat] 2+ messages in thread
end of thread, other threads:[~2004-06-06 21:37 UTC | newest]
Thread overview: 2+ messages (download: mbox mbox.gz follow: Atom feed)
-- links below jump to the message on this page --
2004-06-05 19:02 PostgreSQL Connection Problem via TCP/IP socket Andrei Verovski (aka MacGuru) <andreil1@starlett.lv>
2004-06-06 21:37 ` Tom Lane <tgl@sss.pgh.pa.us>
This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox