Hi Suranjana,
This means that PostgreSQL is not listening on that port which iis why you cannot connect. Check you server config is
correct,and that you have editted the right postgresql.conf file (it's not unusual to get the wrong one especially on
distroslike Redhat where there might be a preinstalled version.
Regards, Dave.
_____________Original message ____________
Subject: RE: Pgadmin error
Sender: "Ratta, Suranjana" <SRatta@dow.com>
Date: Sat, 1 Feb 2003 11:15:43 +0000
Dave,
C:\>telnet localhost 5432,
gives,
No connection could be made because the target machine actively refuses it.
Regards,
Suranjana
-----Original Message-----
From: Dave Page [mailto:dpage@vale-housing.co.uk]
Sent: Friday, January 31, 2003 2:23 PM
To: Ratta, Suranjana; pgadmin-support-owner@postgresql.org
Subject: RE: Pgadmin error
> -----Original Message-----
> From: Ratta, Suranjana [mailto:SRatta@dow.com]
> Sent: 31 January 2003 20:05
> To: pgadmin-support-owner@postgresql.org
> Subject: Pgadmin error
>
>
> I installed, PostGreSql 7.3 for win, on Win XP and PgAdmin ,
> but nothing is working.
> The Pgadmin is giving me this error:
>
> Cannot connect to the server; could not connect to the remote
> socket. Number: -2147467259
>
> All I am trying to do is connect to the database in my local computer.
>
> I have also changed the Tcpip_socket = true in the .conf file
> and also the network connect is fine.
>
If you telnet to the PostgreSQL port on your server and hit return a
couple of times, what to you see?
Eg.
C:\>telnet localhost 5432
Trying 127.0.0.1...
Connected to 127.0.0.1.
Escape character is '^]'.
EFATAL: invalid length of startup packet
Connection closed by foreign host.
Regards, Dave.