Skip site navigation (1) Skip section navigation (2)

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 (view raw or flat)
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

pgsql-general by date

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

Privacy Policy | About PostgreSQL
Copyright © 1996-2014 The PostgreSQL Global Development Group