OmniPITR – update

OmniPITR project that I wrote about some time ago is going on.

Just today I finished tests for omnipitr-backup-slave – part of OmniPITR which lets you make hot-backups of WAL-slave machine – without any additional load on master.

As previously – please download (svn co) and test. In case you have problems – please mail me or contact me on – I'm usually on #postgresql.

7 thoughts on “OmniPITR – update”

  1. @Valentine

    not sure what could have go wrong – please check source of omnipitr-backup-slave – perhaps you will notice some step that it takes, and you do not. Sorry I’m not more helpful, but I just don’t know what could have not worked there.

  2. Hm… actually I was looking in your script to build the backup procedure and practically copied the wait for checkout location procedure in bash.

    Did you have a chance to check the consistency of the database, restored from the backup done by omnipitr-backup-slave? We found the problem with indexes by accident actually when some of the records could not have been found in some table…

    — Valentine

  3. @Valentine:

    of course.

    we made a lot of slave backups, and we test them a lot. this included 400GB database, with really heavy traffic.

  4. Hi again, I hope I am not bothering you too much 🙂

    can that be, that all that databases are getting full_page written WAL files? Our main database is configured with full_page_writes set to off. Maybe that is the difference that leads to the problems with indexes?

  5. @Valentine:

    Of course we use full page writes. Turning it off is dangerous, and can lead to data loss.

  6. Probably that is our problem…

    The issue with the full_page written WAL files for us was that on the normal operation, we have such a big full_page written WAL stream, that the standby database was not able to replay them on the machine with identical parameters 🙁 And I could not find the way to speed up replay or to reduce the WAL files steam other then turning full_page_write to off… 🙁

Comments are closed.