[GENERAL] Tracking down log segment corruption

2008-12-21 Thread Charles Duffy
Howdy, all. I have a log-shipping replication environment (based on PostgreSQL 8.3.4) using pg_lesslog+LZOP for compression of archived segments (kept around long-term for possible use doing PITR). The slave came out of synchronization recently, restoring a series of segments and then failing

Re: [GENERAL] Backing up and deleting a database.

2008-07-15 Thread Charles Duffy
o periodically dump out the oldest partition, drop it, create a new partition, and maintain the associated triggers. Charles Duffy -- Sent via pgsql-general mailing list (pgsql-general@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-general