Re: pg_dump error

I contacted my server manager to make sure you have the proper version numbers of the software I am using.  But I may
ormay not have compiled postgresql with the openSSL library listed below.  The server managers do regular patching.   

Postgresql 9.4.4
RHEL version is 6.6.
OpenSSL version is 1.0.1e-30.el6_6.11

Thanks,

Lance Campbell



-----Original Message-----
From: pgsql-admin-owner@postgresql.org [mailto:pgsql-admin-owner@postgresql.org] On Behalf Of Campbell, Lance
Sent: Monday, July 20, 2015 7:31 AM
To: pgsql-admin@postgresql.org
Subject: Re: [ADMIN] pg_dump error

Postgresql 9.4.4
Linux Redhat

When I trigger pg_dump of the database I am doing it locally on the server running postgresql.  I also went in to
pg_hba.confand made sure that the local user does not use SSL. 

I know our servers were patched recently.  Would there ever be a case where we have to rebuild build, compile and make,
postgresqlbecause of changes to the SSL libraries? 

Lance

-----Original Message-----
From: Campbell, Lance
Sent: Monday, July 20, 2015 6:23 AM
To: Campbell, Lance <lance@illinois.edu>; pgsql-admin@postgresql.org
Subject: RE: pg_dump error

As a follow-up I ran this command:

pg_dump -U username -h localhost databasename -f databasename.20150720

I get this in the console:
pg_dump: [archiver (db)] query failed: SSL error: unexpected message
pg_dump: [archiver (db)] query was: SET search_path = calendar, pg_catalog

PG Admin is telling me the database is 57 G.
I was able to do the following command in order to just backup the "calendar" schema with data:

pg_dump -U username -h localhost --schema=calendar databasename -f calendar.20150720

So why am I unable to backup my entire database?

Lance

-----Original Message-----
From: pgsql-admin-owner@postgresql.org [mailto:pgsql-admin-owner@postgresql.org] On Behalf Of Campbell, Lance
Sent: Monday, July 20, 2015 5:52 AM
To: pgsql-admin@postgresql.org
Subject: [ADMIN] pg_dump error

Postgresql 9.4.x

I am performing the following pg_dump command:

pg_dump -U username -h localhost --jobs=3 --format=d --compress=0 databasename -f databasename.20150720

I am getting this error:

pg_dump: [parallel archiver] could not get relation name for OID 58363761: connection not open

How can I work around this issue?  Should I just not used --jobs=3 when backing up the full database?

Lance Campbell
Software Architect
Web Services at the University of Illinois



--
Sent via pgsql-admin mailing list (pgsql-admin@postgresql.org) To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-admin


--
Sent via pgsql-admin mailing list (pgsql-admin@postgresql.org) To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-admin