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 <[EMAIL PROTECTED]>/* 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
> [EMAIL PROTECTED]
> ---------------------------------------------------------------
>
> ---------------------------(end of
broadcast)---------------------------
> TIP 1: if posting/reading through Usenet, please send an appropriate
> subscribe-nomail command to [EMAIL PROTECTED] 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!
---------------------------(end of broadcast)---------------------------
TIP 5: don't forget to increase your free space map settings