Re: connection problems

"Benjamin Krajmalnik" <kraj@xxxxxxxxxxx> · Tue, 1 Apr 2008 11:27:28 -0600

Another option on Windows would be to get the Sysinternals utilities, and 
use tcpview, which is superior to netstat.

  From: pgsql-admin-owner@xxxxxxxxxxxxxx 
  [mailto:pgsql-admin-owner@xxxxxxxxxxxxxx] On Behalf Of Melissa 
  Peterson
Sent: Tuesday, April 01, 2008 10:29 AM
To: 
  pgsql-admin@xxxxxxxxxxxxxx
Subject: Re:  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
  melissa@xxxxxxxxxxxxx
  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@xxxxxxxxxxxxxx 
  [mailto:pgsql-admin-owner@xxxxxxxxxxxxxx] On Behalf Of Shavonne 
  Marietta Wijesinghe
Sent: Tuesday, April 01, 2008 8:52 
  AM
To: pgsql-admin@xxxxxxxxxxxxxx
Subject: Re:  
  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.