Re: pg_dump error - Mailing list pgsql-admin
From | Campbell, Lance |
---|---|
Subject | Re: pg_dump error |
Date | |
Msg-id | B75CD08C73BD3543B97E4EF3964B7D701FF53DCE@CITESMBX1.ad.uillinois.edu Whole thread Raw |
In response to | Re: pg_dump error ("Campbell, Lance" <lance@illinois.edu>) |
List | 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 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
pgsql-admin by date: