Re: Remote Connection - Mailing list pgsql-general

From Bill Moran
Subject Re: Remote Connection
Date
Msg-id 20110110085517.65219572.wmoran@potentialtech.com
Whole thread Raw
In response to Remote Connection  ("Bob Pawley" <rjpawley@shaw.ca>)
Responses Re: Remote Connection  ("Bob Pawley" <rjpawley@shaw.ca>)
List pgsql-general
In response to "Bob Pawley" <rjpawley@shaw.ca>:

> Hi
>
> I am attempting to connect from two local interfaces to a remote database.
>
> With one interface (SharpMap developed in C#) I have no problems.
>
> With the other interface (Delphi) I have no problem connecting in design mode.
>
> However when I compile Delphi it just hangs, until timeout, without opening.
>
> The postgresql log follows. Can someone please interpret  it for me?
>
> Bob
>
> 2011-01-07 09:03:55 PSTERROR:  unrecognized configuration parameter "ssl_renegotiation_limit"
> 2011-01-07 09:03:55 PSTSTATEMENT:  SET ssl_renegotiation_limit=0
> 2011-01-07 09:04:08 PSTLOG:  could not receive data from client: No connection could be made because the target
machineactively refused it. 
>
>
> 2011-01-07 09:04:08 PSTLOG:  unexpected EOF on client connection
> 2011-01-07 09:22:58 PSTLOG:  could not receive data from client: No connection could be made because the target
machineactively refused it. 
>
>
> 2011-01-07 09:22:58 PSTLOG:  unexpected EOF on client connection

What version of PostgreSQL are you using and what version does Delphi
think you're using?  It seems to me that the Delphi IDE is connecting
differently than the app it compiles for you, and that said app is
trying to set a configuration parameter that doesn't exist, then aborting
when that fails.

Can't imagine what version you'd be using ... that option seems to have
been around since 8.0 at least.

--
Bill Moran
http://www.potentialtech.com
http://people.collaborativefusion.com/~wmoran/

pgsql-general by date:

Previous
From: Vick Khera
Date:
Subject: Re: Realtime Query Dashboard Results
Next
From: "Ing. Yunior Mesa Reyes"
Date:
Subject: Para participantes extranjeros en el Tercer PGDay Latinoamericano.