Обсуждение: Re: pgsql connection

Hi,

what does "iptables -L" and "/var/log/postgresql" say? Is there a packetfilter? The socket sems to be ok.
Can you telnet to the the socket?

Regards,

Martin

Am Mittwoch, den 21.09.2005, 16:08 +0800 schrieb Nirav Parikh:

Hi Martin,

Thanks for prompt reply. As I said before I can connect through different server but can't connect locally.
 
This is the result of  netstat -anp | grep postmaster
 
tcp        0      0 0.0.0.0:5432                0.0.0.0:*                   LISTEN      2094/postmaster
tcp        0      0 :::5432                     :::*                        LISTEN      2094/postmaster
udp        0      0 127.0.0.1:32769             127.0.0.1:32769             ESTABLISHED 2094/postmaster
unix  2      [ ACC ]     STREAM     LISTENING     5996   2094/postmaster     /tmp/.s.PGSQL.5432

I changed settings in posgresql.conf but still no luck.
 
listen_addresses = 'localhost'
port = 5432
 
Is there anything else I can try?


 
regards,
 
Nirav



--
No virus found in this outgoing message.
Checked by AVG Anti-Virus.
Version: 7.0.344 / Virus Database: 267.11.3/107 - Release Date: 20/09/2005