Re: database backup throws errors

"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