From: | "Michael Molz" <michael(dot)molz(at)iwm-software(dot)de> |
---|---|
To: | <pgsql-general(at)postgresql(dot)org> |
Subject: | database backup throws errors |
Date: | 2011-04-07 06:23:55 |
Message-ID: | 8189337A5B736B44A838BCABD57E571DBDE794@IWM5.IWM.LOCAL |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-general |
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
From | Date | Subject | |
---|---|---|---|
Next Message | rsmogura | 2011-04-07 09:39:51 | Arrays of arrays |
Previous Message | Allan Kamau | 2011-04-07 06:16:32 | Re: Critical Bug |