Thread: Erros with pg-Admin

Erros with pg-Admin

From
"Juan C. Casamayor"
Date:
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



Re: Erros with pg-Admin

From
"Dave Page"
Date:
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.



Re: Erros with pg-Admin

From
"Sutto Zoltan"
Date:
 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
>


Re: Erros with pg-Admin

From
"Roberto Mason"
Date:
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