Re: Remote Connection

In response to "Bob Pawley" <rjpawley(at)shaw(dot)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 machine actively 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 machine actively 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/