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
