Search Postgresql Archives

Re: database backup throws errors

[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]

 



"Michael Molz" <michael.molz@xxxxxxxxxxxxxxx> writes:
> 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.

> 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

-- 
Sent via pgsql-general mailing list (pgsql-general@xxxxxxxxxxxxxx)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-general


[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]
[Index of Archives]     [Postgresql Jobs]     [Postgresql Admin]     [Postgresql Performance]     [Linux Clusters]     [PHP Home]     [PHP on Windows]     [Kernel Newbies]     [PHP Classes]     [PHP Books]     [PHP Databases]     [Postgresql & PHP]     [Yosemite]
  Powered by Linux