pg.ddx.io  pgsql-admin@postgresql.org mailing list archive  
help / color / mirror / Atom feed
PostgreSQL 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>
  2004-06-06 21:37 ` Re: PostgreSQL Connection Problem via TCP/IP socket Tom Lane <tgl@sss.pgh.pa.us>
  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-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>
  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