Re: Erros with pg-Admin

From: "Roberto Mason" <systemtech(at)robertomason(dot)pointclark(dot)net>
To: "'Juan C(dot) Casamayor'" <jcarlos(at)dsic(dot)upv(dot)es>, <pgadmin-support(at)postgresql(dot)org>
Subject: Re: Erros with pg-Admin
Date: 2003-02-18 17:03:53
Message-ID: 000701c2d76f$b822b820$1401a8c0@rmwxp
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgadmin-support


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(at)postgresql(dot)org
[mailto:pgadmin-support-owner(at)postgresql(dot)org]On Behalf Of Juan C.
Casamayor
Sent: 17 fevrier 2003 13:31
To: pgadmin-support(at)postgresql(dot)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(at)dsic(dot)upv(dot)es
(SPAIN) www: http://www.dsic.upv.es/~jcarlos

---------------------------(end of broadcast)---------------------------
TIP 1: subscribe and unsubscribe commands go to majordomo(at)postgresql(dot)org

In response to

Browse pgadmin-support by date

  From Date Subject
Next Message radha.manohar 2003-02-19 19:21:36 Re: Concurrency Control
Previous Message Sutto Zoltan 2003-02-17 20:34:36 Re: Erros with pg-Admin