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