postgres-8.4SS, pg_dump from macosx-10.6 has "ssl handshake error" 26% in

From: raf <raf(at)raf(dot)org>
To: pgsql-general(at)postgresql(dot)org
Subject: postgres-8.4SS, pg_dump from macosx-10.6 has "ssl handshake error" 26% in
Date: 2010-07-28 00:46:31
Message-ID: 20100728004631.GA29427@raf.org
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

hi,

i'm having a little openssl problem with pg_dump over a wireless
lan with postgres-8.4SS (on linux) from enterprisedb and
a macosx-10.6 client.

when i run pg_dump from a wired linux client it's always fine
but since i switched from a macosx-10.4 laptop to a
macosx-10.6 laptop, every time i run pg_dump from the laptop
over the wireless lan, it's fine for a few minutes and then,
26% of the way in, it stalls and never completes.

the postgres logs show many repeated instances of the following
messages:

payrollLOG: SSL renegotiation failure
payrollSTATEMENT: COPY public.table_name (id, ...
payrollLOG: SSL error: ssl handshake failure

there's no special openssl configuration on the laptop
that i'm aware of.

all connections to postgres use ssl.
there are no client certificates.

both psql and pg_dump on the laptop link to the same
libssl (/usr/lib/libssl.0.9.7.dylib) and i never have
trouble with pgsql.

it's odd that the postgres installation on the server
contains its own libssl.so.4 but the installation on the
client (same version) doesn't have its own and uses one
of the system supplied ones. no doubt there's some good
reason for that.

so it probably has something to do with openssl on the mac.
any ideas?

cheers,
raf

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Tom Lane 2010-07-28 00:55:42 Re: Blocked inserts on tables with FK to tables for which UPDATE has been revoked
Previous Message Tom Lane 2010-07-28 00:27:48 Re: Incorrect FTS result with GIN index