Re: Problem connecting to PostgreSQL 7.3 using pgAdmin II v1.4.12

From: "Dave Page" <dpage(at)vale-housing(dot)co(dot)uk>
To: "Lin Jianfong" <ljfong(at)hotmail(dot)com>, <pgadmin-support(at)postgresql(dot)org>
Subject: Re: Problem connecting to PostgreSQL 7.3 using pgAdmin II v1.4.12
Date: 2003-04-03 09:01:19
Message-ID: 03AF4E498C591348A42FC93DEA9661B8259EDB@mail.vale-housing.co.uk
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgadmin-support

Hi,

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

Trying 192.168.1.43...
Connected to nibbler.vale-housing.co.uk.
Escape character is '^]'.

EFATAL: invalid length of startup packet
Connection closed by foreign host.

Regards, Dave.

> -----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
>
>
> Hi,
>
> 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*.
> http://join.msn.com/?page=features/virus
>
>
> ---------------------------(end of
> broadcast)---------------------------
> 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
>

Browse pgadmin-support by date

  From Date Subject
Next Message Carol and Doug Hutcheson 2003-04-03 10:34:05 itss.dll fails to register - even crashes regsvr32
Previous Message Dave Page 2003-04-03 08:13:00 Re: How to use the pgAdmin II Migration Wizard