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