From: | "Campbell, Lance" <lance(at)illinois(dot)edu> |
---|---|
To: | "Campbell, Lance" <lance(at)illinois(dot)edu>, "pgsql-admin(at)postgresql(dot)org" <pgsql-admin(at)postgresql(dot)org> |
Subject: | Re: pg_dump error |
Date: | 2015-07-20 13:03:58 |
Message-ID: | B75CD08C73BD3543B97E4EF3964B7D701FF53DCE@CITESMBX1.ad.uillinois.edu |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-admin |
I contacted my server manager to make sure you have the proper version numbers of the software I am using. But I may or may 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(at)postgresql(dot)org [mailto:pgsql-admin-owner(at)postgresql(dot)org] On Behalf Of Campbell, Lance
Sent: Monday, July 20, 2015 7:31 AM
To: pgsql-admin(at)postgresql(dot)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.conf and 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, postgresql because of changes to the SSL libraries?
Lance
-----Original Message-----
From: Campbell, Lance
Sent: Monday, July 20, 2015 6:23 AM
To: Campbell, Lance <lance(at)illinois(dot)edu>; pgsql-admin(at)postgresql(dot)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(at)postgresql(dot)org [mailto:pgsql-admin-owner(at)postgresql(dot)org] On Behalf Of Campbell, Lance
Sent: Monday, July 20, 2015 5:52 AM
To: pgsql-admin(at)postgresql(dot)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(at)postgresql(dot)org) To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-admin
--
Sent via pgsql-admin mailing list (pgsql-admin(at)postgresql(dot)org) To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-admin
From | Date | Subject | |
---|---|---|---|
Next Message | Tom Lane | 2015-07-20 13:59:50 | Re: pg_dump error |
Previous Message | Campbell, Lance | 2015-07-20 12:31:17 | Re: pg_dump error |