Date: prev next · Thread: first prev next last
2013 Archives by date, by thread · List index


On Tue, Nov 19, 2013 at 4:31 PM, Andrew Cassidy <> wrote:

I'm kinda glad Postgres was thrown in (on the last call I was in on,
anyway)... In Postgres you can configure continuous transaction logging
which basically uses the replication infrastructure to dump a binary
transaction log file every 16MB (configurable) of transactions. These can
be replayed in conjunction with a base backup to do a restore and doesn't
add much extra load to the server. That's how replication worked pre 9.1.

This can also be implemented on MySQL.

The base backup still takes time though, but could potentially be done
from a slave.

That's assuming you do have a slave available.

To unsubscribe e-mail to:
Posting guidelines + more:
List archive:
All messages sent to this list will be publicly archived and cannot be deleted


Privacy Policy | Impressum (Legal Info) | Copyright information: Unless otherwise specified, all text and images on this website are licensed under the Creative Commons Attribution-Share Alike 3.0 License. This does not include the source code of LibreOffice, which is licensed under the Mozilla Public License (MPLv2). "LibreOffice" and "The Document Foundation" are registered trademarks of their corresponding registered owners or are in actual use as trademarks in one or more countries. Their respective logos and icons are also subject to international copyright laws. Use thereof is explained in our trademark policy.