Re: SSL connection lost after long-lasting copy command - Mailing list pgsql-general

From Steve Atkins
Subject Re: SSL connection lost after long-lasting copy command
Date
Msg-id 6034EF04-97EC-4153-AEAE-9D33ADB1DC73@blighty.com
Whole thread Raw
In response to Re: SSL connection lost after long-lasting copy command  (Seb <spluque@gmail.com>)
List pgsql-general
On Feb 9, 2010, at 9:55 AM, Seb wrote:

> On Tue, 9 Feb 2010 14:44:23 -0300,
> Alvaro Herrera <alvherre@commandprompt.com> wrote:
>
> [...]
>
>> Err, remove the renegotiation code from the server.
>
> Oh I meant something from a user's point of view, not hacking the source
> code.  If there's not a user option, I don't mind the connection loss as
> long as the data do get copied to the table.  Thanks.

Your only real option that doesn't require recompilation right now
is to avoid using SSL.

Your operating system provider is shipping openssl libraries that are
(intentionally) broken. If you want to use the versions of openssl and
postgresql they provide they won't work with long running SSL
connections until they've fixed one or the other.

Cheers,
  Steve


pgsql-general by date:

Previous
From: John R Pierce
Date:
Subject: Re: vacuumdb ERROR: out of memory
Next
From: Scott Marlowe
Date:
Subject: Re: vacuumdb ERROR: out of memory