Re: database backup throws errors

"Michael Molz" <michael(dot)molz(at)iwm-software(dot)de> writes:
> were 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. Its 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.

> 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_limit with value 0 to postgresql.conf to turn off the SSL renegotiation. As I do this, database system will not 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