Another option on Windows would be to get the Sysinternals utilities, and use tcpview, which is superior to netstat.
From: pgsql-admin-owner@postgresql.org [mailto:pgsql-admin-owner@postgresql.org] On Behalf Of Melissa Peterson Sent: Tuesday, April 01, 2008 10:29 AM To: pgsql-admin@postgresql.org Subject: Re: [ADMIN] connection problems
Netstat is a separate program that shows the status of your network interfaces. It should come with your operating system. On Windows, you can get to it via the command console. Typing “netstat –ab” at the command prompt should generate a list of the ports on which your server is listening, the ports that have a connection established, and the program bound to that port. For the port that PostgreSQL is supposed to be listening on, you can check that it is actually doing so.
This message and any attachments are solely for the intended recipient and may contain confidential or privileged information. If you are not the intended recipient, any disclosure, copying, use, or distribution of the information included in this message and any attachments is strictly prohibited. If you have received this communication in error, please notify us by reply email and immediately and permanently delete this message and any attachments.
From: pgsql-admin-owner@postgresql.org [mailto:pgsql-admin-owner@postgresql.org] On Behalf Of Shavonne Marietta Wijesinghe Sent: Tuesday, April 01, 2008 8:52 AM To: pgsql-admin@postgresql.org Subject: Re: [ADMIN] connection problems
Thanks Tino. But what do you mean by "netstat -tln" i use the pgadmin.
Shavonne
Did you restart the postmaster after setting listen_addresses?
Does netstat -tln display the appropiate port listening on *:5432 (or
