Re: Server not listening

[Andy Shellam <andy(dot)shellam-lists(at)mailnetwork(dot)co(dot)uk>]

Hi George,

From the server's console, do "telnet <servers_ip> 5432."
Make sure to use the server's remote IP, not localhost.  If that fails, 
your PostgreSQL is not listening on that port correctly.  If it 
succeeds, then you've got a firewall problem.

If it's PostgreSQL isn't listening, make sure you have done a restart 
(not just a reload) since making the chance in your configuration file 
(just to make sure, if you can, stop then start it.)  Also check you are 
editing the correct file!  (I.e. the one in the same cluster directory 
that PostgreSQL is starting.)

Andy.

George Heller wrote:
> Hi,
>  
> I tried a telnet, and it doesnt work. So atleast now I know there is 
> something wrong with the server side, but I dont quite know what to do 
> next..... Any suggestions?
>  
> Is there some particular setup that needs to be done? I have disabled 
> the Windows Firewall.
>  
> Thanks.
> George
>
> */Andy Shellam <andy(dot)shellam-lists(at)mailnetwork(dot)co(dot)uk>/* wrote:
>
>     Also from the machine you tried the ping from, do telnet
>     5432 - see if that connects.
>     Something's definitely not quite correct on the server-side.
>
>     Check any firewalls (particularly the Windows Firewall if running
>     an XP
>     SP2 or 2003 client machine.)
>
>     Andy
>
>     Raymond O'Donnell wrote:
>     > On 18/04/2007 21:29, GeorgeHeller wrote:
>     >
>     >> I have changed the postgresql.conf file to have
>     listen_addresses='*' and
>     >> port=5432, and have restarted the server.
>     >
>     > if you have psql on another computer, try using it to connect to
>     the
>     > server and see what happens.
>     >
>     > psql -h (serveraddress) -U (username) -d (databasename) etc.
>     >
>     > Ray.
>     >
>     > ---------------------------------------------------------------
>     > Raymond O'Donnell, Director of Music, Galway Cathedral, Ireland
>     > rod(at)iol(dot)ie
>     > ---------------------------------------------------------------
>     >
>     > ---------------------------(end of
>     broadcast)---------------------------
>     > TIP 1: if posting/reading through Usenet, please send an appropriate
>     > subscribe-nomail command to majordomo(at)postgresql(dot)org so that your
>     > message can get through to the mailing list cleanly
>     >
>     >
>     >
>     >
>
>
> ------------------------------------------------------------------------
> Ahhh...imagining that irresistible "new car" smell?
> Check out new cars at Yahoo! Autos. 
> <http://us.rd.yahoo.com/evt=48245/*http://autos.yahoo.com/new_cars.html;_ylc=X3oDMTE1YW1jcXJ2BF9TAzk3MTA3MDc2BHNlYwNtYWlsdGFncwRzbGsDbmV3LWNhcnM-> 
> !DSPAM:37,4627d7de89291495521781!