Another option on Windows would be to get the Sysinternals utilities,
and use tcpview, which is superior to netstat.
________________________________
From: [EMAIL PROTECTED]
[mailto:[EMAIL PROTECTED] 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.
Mel Peterson
R&D Engineer
[EMAIL PROTECTED] <mailto:[EMAIL PROTECTED]>
GigaCrete, Inc.
6775 Speedway Boulevard, Suite M-104
Las Vegas, NV 89115
Phone 702-643-6363
Fax 702-543-7010
www.gigacrete.com <http://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: [EMAIL PROTECTED]
[mailto:[EMAIL PROTECTED] 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
whatever your port number is)?
Tino.
