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
>
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 |