Thread: 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
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
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
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
"Campbell, Lance" <lance@illinois.edu> writes: > 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 That looks like you've run into the renegotiation bug that Red Hat introduced in their last openssl patch: https://bugzilla.redhat.com/show_bug.cgi?id=1234487 So basically things will work until you exceed a couple gigabytes of traffic on the connection, and then bang. The workaround we're recommending to people is to set ssl_renegotiation_limit to zero (disable it) in postgresql.conf, as renegotiation seems to create way more problems than it fixes (this RH bug was very far from the first such problem, and it's not likely to be the last either). See recent discussions on pgsql-hackers, where it was more or less agreed that we're going to remove the feature altogether in the future. regards, tom lane