pg_dump 8.4.9 failing after upgrade to openssl-1.0.1e-30.el6_6.11.x86_64 on redhat linux - Mailing list pgsql-general

From Douglas Stetner
Subject pg_dump 8.4.9 failing after upgrade to openssl-1.0.1e-30.el6_6.11.x86_64 on redhat linux
Date
Msg-id 47D43FC6-7854-4AA2-B0CE-C2FE0743105F@stetner.org
Whole thread Raw
Responses Re: pg_dump 8.4.9 failing after upgrade to openssl-1.0.1e-30.el6_6.11.x86_64 on redhat linux
List pgsql-general
Hi all,

Looking for confirmation there is an issue with pg_dump failing after upgrade to openssl-1.0.1e-30.el6_6.11.x86_64 on
redhatlinux. 

-bash-4.1$ pg_dump -V
pg_dump (PostgreSQL) 8.4.9

-bash-4.1$ pg_dump -h localhost -C Hogwarts -a -t mafs -f zz
pg_dump: Dumping the contents of table "mafs" failed: PQgetCopyData() failed.
pg_dump: Error message from server: SSL error: unexpected message
pg_dump: The command was: COPY public.mafs (hugo_symbol,
...
...
analysis_id) TO stdout;


This is only happening on 2 tables in this database.  The same database can be backed up with pgAdmin3.app remotely
froma Mac 

As stated I am fairly sure the cause was the upgrade of openssl as it started to fail the next day:
Jun 16 05:18:25 qcmg-database1 yum[2965]: Updated: openssl-1.0.1e-30.el6_6.11.x86_64




Douglas Stetner
Mobile 0474 082 019
UNIX - Live Free Or Die




Attachment

pgsql-general by date:

Previous
From: Venkata Balaji N
Date:
Subject: Re: pg_xlog on a hot_stanby slave
Next
From: Sameer Kumar
Date:
Subject: Re: pg_xlog on a hot_stanby slave