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

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.

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

On 19 November 2013 14:16, Florian Effenberger <> wrote:

Hello Alin,

thanks for the fast reply!

Alin Crețu wrote on 2013-11-19 15:08:

 The sql statement for dumping the data out of the DB server is part of the
regular backups.

For kermit the window for executing automatic backups is every night
in Germany) between 2:00 and 6:00.
I exepect that we will have this dump started tonight at around 2:00. If
not, then something is wrong with the schedule for the automatic backups
and TDF admins will get an automatic email.

Hmm... I'm definitely asleep late in the night. :-) Is there an option of
triggering it manually at a time that is convenient for us, when at least
one of us is in front of the machines to react?

If so, I'd then shut down the help wiki tonight again before going to
sleep, start it back the next morning and we could try to manually invoke
the backup tomorrow.


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

*Andrew Cassidy BSc (Hons) MBCS SSCA*
Managing Director

*T <> *03300 100 960  *F
<> *03300 100 961
*E <> *
*W <> *

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.