PostgreSQL Administration - Re: pgsql connection

You are viewing an archived Text-only version of the thread. To view this thread in it's original format and/or if you want to reply to this thread please [click here]

Author

Re: pgsql connection

Nirav Parikh

2005-09-21, 3:24 am

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

Sponsored Links