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 < [email protected]> 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 >> (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. > > > Florian > > -- > To unsubscribe e-mail to: [email protected] > Problems? http://www.libreoffice.org/get-help/mailing-lists/how-to- > unsubscribe/ > Posting guidelines + more: http://wiki.documentfoundation.org/Netiquette > List archive: http://listarchives.libreoffice.org/global/website/ > All messages sent to this list will be publicly archived and cannot be > deleted > -- *Andrew Cassidy BSc (Hons) MBCS SSCA* Managing Director *T <[email protected]> *03300 100 960 *F <[email protected]> *03300 100 961 *E <[email protected]> *[email protected] *W <[email protected]> *www.cassidywebservices.co.uk -- To unsubscribe e-mail to: [email protected] Problems? http://www.libreoffice.org/get-help/mailing-lists/how-to-unsubscribe/ Posting guidelines + more: http://wiki.documentfoundation.org/Netiquette List archive: http://listarchives.libreoffice.org/global/website/ All messages sent to this list will be publicly archived and cannot be deleted
