Обсуждение: Erros with pg-Admin
Hello:
I tried to connect pgAdmin running on Windows 2000 to Postgres 7.2.3
runnig on another computer with RH8.0 received this error:
2003-02-17 18:46:05 -
*******************************************************************
2003-02-17 18:46:05 - Error(s)
2003-02-17 18:46:05 -
*******************************************************************
2003-02-17 18:46:05 - Error in pgAdmin II:frmConnect.cmdConnect_Click:
-2147467259 - Could not connect to the server;
Could not connect to remote socket.
2003-02-17 18:46:05 - Windows Version: Windows 2000 v5.0 build 2195
Service Pack 2
2003-02-17 18:46:05 - pgSchema Version: 1.4.12
2003-02-17 18:46:05 - MDAC Version: 2.5
2003-02-17 18:46:05 - cnPostgreSQL.State = adStateClosed
I have checked that the client and the server can connect with "ping"
and, also, that the server is listening (it was started up with the
option "-i").
Thanks in advance
--
---------------------------------------------------------------------------
Juan C. Casamayor
Dept. Sistemas Informaticos y Computacion
Universidad Politecnica de Valencia Tel: ++ 34 6 3877007 (ext. 73594)
Camino de Vera s/n Fax: ++ 34 6 3877359
46071 Valencia email: jcarlos@dsic.upv.es
(SPAIN) www: http://www.dsic.upv.es/~jcarlos
It's rumoured that Juan C. Casamayor once said: > Hello: > > I tried to connect pgAdmin running on Windows 2000 to Postgres 7.2.3 > > runnig on another computer with RH8.0 received this error: Hi Juan, What do you see if you telnet to the PostgreSQL port on the server from the workstation and hit return a couple of times? e.g. C:\> telnet server.mydomain.com 5432 Regards, Dave.
Set
tcpip_socket = true
in /var/lib/pgsql/data/postgresql.conf
an set the necessary host access control in
/var/lib/pgsql/data/pg_hba.conf to access your DB from your windows 2000
host
I hope it will help
Zoltan Sutto
>
>
>
>
> ----- Original Message -----
> From: "Juan C. Casamayor" <jcarlos@dsic.upv.es>
> To: <pgadmin-support@postgresql.org>
> Sent: Monday, February 17, 2003 7:30 PM
> Subject: [pgadmin-support] Erros with pg-Admin
>
>
> > Hello:
> >
> > I tried to connect pgAdmin running on Windows 2000 to Postgres 7.2.3
> > runnig on another computer with RH8.0 received this error:
> >
> > 2003-02-17 18:46:05 -
> > *******************************************************************
> > 2003-02-17 18:46:05 - Error(s)
> > 2003-02-17 18:46:05 -
> > *******************************************************************
> > 2003-02-17 18:46:05 - Error in pgAdmin II:frmConnect.cmdConnect_Click:
> > -2147467259 - Could not connect to the server;
> > Could not connect to remote socket.
> >
> > 2003-02-17 18:46:05 - Windows Version: Windows 2000 v5.0 build 2195
> > Service Pack 2
> > 2003-02-17 18:46:05 - pgSchema Version: 1.4.12
> > 2003-02-17 18:46:05 - MDAC Version: 2.5
> > 2003-02-17 18:46:05 - cnPostgreSQL.State = adStateClosed
> >
> > I have checked that the client and the server can connect with "ping"
> > and, also, that the server is listening (it was started up with the
> > option "-i").
> >
> > Thanks in advance
> >
> > --
>
> --------------------------------------------------------------------------
> -
> > Juan C. Casamayor
> > Dept. Sistemas Informaticos y Computacion
> > Universidad Politecnica de Valencia Tel: ++ 34 6 3877007 (ext. 73594)
> > Camino de Vera s/n Fax: ++ 34 6 3877359
> > 46071 Valencia email: jcarlos@dsic.upv.es
> > (SPAIN) www:
> http://www.dsic.upv.es/~jcarlos
> >
> >
> >
> > ---------------------------(end of broadcast)---------------------------
> > TIP 1: subscribe and unsubscribe commands go to majordomo@postgresql.org
>
I had the same problem, running Redhat 8.0 and postgresql 7.2.3. You have to
go to postgresql.conf and set the following:
tcpip_socket = true
If after successfully running pgadminII you see it's slow, I found on the
internet a reference to the problem. It says to turn off in you ODBC the
tracing. It worked for me.
There's another issue about turning off reverse lookup to solve the problem
(see previous post), but I haven't yet had the time to look into that.
Roberto
-----Original Message-----
From: pgadmin-support-owner@postgresql.org
[mailto:pgadmin-support-owner@postgresql.org]On Behalf Of Juan C.
Casamayor
Sent: 17 fevrier 2003 13:31
To: pgadmin-support@postgresql.org
Subject: [pgadmin-support] Erros with pg-Admin
Hello:
I tried to connect pgAdmin running on Windows 2000 to Postgres 7.2.3
runnig on another computer with RH8.0 received this error:
2003-02-17 18:46:05 -
*******************************************************************
2003-02-17 18:46:05 - Error(s)
2003-02-17 18:46:05 -
*******************************************************************
2003-02-17 18:46:05 - Error in pgAdmin II:frmConnect.cmdConnect_Click:
-2147467259 - Could not connect to the server;
Could not connect to remote socket.
2003-02-17 18:46:05 - Windows Version: Windows 2000 v5.0 build 2195
Service Pack 2
2003-02-17 18:46:05 - pgSchema Version: 1.4.12
2003-02-17 18:46:05 - MDAC Version: 2.5
2003-02-17 18:46:05 - cnPostgreSQL.State = adStateClosed
I have checked that the client and the server can connect with "ping"
and, also, that the server is listening (it was started up with the
option "-i").
Thanks in advance
--
---------------------------------------------------------------------------
Juan C. Casamayor
Dept. Sistemas Informaticos y Computacion
Universidad Politecnica de Valencia Tel: ++ 34 6 3877007 (ext. 73594)
Camino de Vera s/n Fax: ++ 34 6 3877359
46071 Valencia email: jcarlos@dsic.upv.es
(SPAIN) www: http://www.dsic.upv.es/~jcarlos
---------------------------(end of broadcast)---------------------------
TIP 1: subscribe and unsubscribe commands go to majordomo@postgresql.org