On your windows machine, if you telnet to your server on port 5432, then
hit return a couple of times, what do you see? It should be something
like the following:
Microsoft Windows XP [Version 5.1.2600]
(C) Copyright 1985-2001 Microsoft Corp.
C:\>telnet postgresql 5432
Connected to nibbler.vale-housing.co.uk.
Escape character is '^]'.
EFATAL: invalid length of startup packet
Connection closed by foreign host.
> -----Original Message-----
> From: Lin Jianfong [mailto:ljfong(at)hotmail(dot)com]
> Sent: 03 April 2003 01:37
> To: pgadmin-support(at)postgresql(dot)org
> Subject: [pgadmin-support] Problem connecting to PostgreSQL
> 7.3 using pgAdmin II v1.4.12
> I have been having this odd problem for a while of sometimes
> being able to
> connect to the database server and at other times, pgAdmin II
> simply refuses
> to connect with error message "could not connect to server. Could not
> connect to remote socket".
> I know the primary reason for this is postgresql.conf
> "tcpip_socket = 1" is
> not set, but I have checked that and it was set to 1. The
> really odd thing
> is, I have no problem whatsoever to connect to the database
> server using php
> script I wrote, which implies that the database server is
> indeed listening
> on port 5432 and it is accepting tcp ip connection, and
> firewall is not
> causing a problem. Just that, pgAdmin II cannot do it. At
> least pgAdmin II
> worked for a while and for some reason, it no longer worked
> this morning.
> The database server is installed and run on a Linux RH 8.0
> machine, and
> pgAdmin II is installed on a Windows 2000 machine. Both
> machines are on the
> same network.
> I'm really stumped on this. Any ideas appreciated.
> MSN 8 helps eliminate e-mail viruses. Get 2 months FREE*.
> ---------------------------(end of
> TIP 3: 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
pgadmin-support by date
|Next:||From: Carol and Doug Hutcheson||Date: 2003-04-03 10:34:05|
|Subject: itss.dll fails to register - even crashes regsvr32|
|Previous:||From: Dave Page||Date: 2003-04-03 08:13:00|
|Subject: Re: How to use the pgAdmin II Migration Wizard|