Thread: database backup throws errors
Hi folks,
we´re running PostgreSQL 8.4.7 for an CRM System on a Linux machine. Database contains about 540 tables with summary about 2.5 million records. Since this weeks the backup stops with an error message always at the same table. It´s irrelevant what tool we use to backup (pgAdmin III, pg_dump from a windows client; backup on the Linux machine directly, …), error stays the same.
On Windows pg_dump reports:
pg_dump: Dumping the contents of table "gdvaus" failed: PQgetCopyData() failed.
pg_dump: Error message from server: server closed the connection unexpectedly
This probably means the server terminated abnormally
before or while processing the request.
pg_dump: The command was: COPY iwm.gdvaus (nvirtnr, ngesell, ngdvsatz, nimplauf, ngdvteilsatz, cagentur, cgesellnr, cpolnn, csatzart, cspartenr, iadresskz, ifolgenr, nfiliale, nfilaender, msatz) TO stdout;
pg_dump: *** aborted because of error
The log contains the following lines:
2011-04-05 17:57:35 CEST STATEMENT: COPY iwm.gdvaus (nvirtnr, ngesell, ngdvsatz, nimplauf, ngdvteilsatz, cagentur, cgesellnr, cpolnn, csatzart, cspartenr, iadresskz, ifolgenr, nfiliale, nfilaender, msatz) TO stdout;
2011-04-05 17:57:35 CEST LOG: SSL-error: unsafe legacy renegotiation disabled
While searching for a solution to the first notification “PQgetCopyData() failed” I found some notes about a possible OOM Kill so I monitored RAM Usage during the backup and found out that this is not the reason; none of the PostgreSQL processes catches more than about 15 MB and there´s enough free Memory left.
Furthermore, I found a hint to the SSL connection problem. It was recommended to add the parameter ssl_renegotiation_limit with value 0 to postgresql.conf to turn off the SSL renegotiation. As I do this, database system will not start again.
Does anyone have some more hints for me?
Thanks a lot for all responses.
Greetings
Michael
-- Diese Mail wurde auf Viren geprüft mit Hilfe von Astaro Mail Gateway. http://www.astaro.com
"Michael Molz" <michael.molz@iwm-software.de> writes: > we´re running PostgreSQL 8.4.7 for an CRM System on a Linux machine. Database contains about 540 tables with summary about2.5 million records. Since this weeks the backup stops with an error message always at the same table. It´s irrelevantwhat tool we use to backup (pgAdmin III, pg_dump from a windows client; backup on the Linux machine directly, ...),error stays the same. > The log contains the following lines: > 2011-04-05 17:57:35 CEST LOG: SSL-error: unsafe legacy renegotiation disabled That looks like your problem --- the SSL library is breaking the connection. > Furthermore, I found a hint to the SSL connection problem. It was recommended to add the parameter ssl_renegotiation_limitwith value 0 to postgresql.conf to turn off the SSL renegotiation. As I do this, database system willnot start again. And that's the solution (at least till you can get hold of a non-broken SSL library). What do you mean by "database system will not start"? An 8.4.7 server should definitely accept that parameter. regards, tom lane