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.
Mel Peterson
R&D Engineer
melissa@gigacrete.com
GigaCrete, Inc.
6775 Speedway Boulevard, Suite M-104
Las Vegas, NV 89115
Phone 702-643-6363
Fax 702-543-7010
www.gigacrete.com
B U I L D S T R O N G. B U I L D F O R W A R D.
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.
Did you restart the postmaster after setting listen_addresses?
Does netstat -tln display the appropiate port listening on *:5432 (or
whatever your port number is)?
Tino.