I had to deal with this question, or some version of it, quite a few times. So, decided to write a summary on what one could (or should) do, after data is in database, and application is running. Namely - ...

February 3rd, 2015 by depesz | Tags: , , , , , , | No comments »

Just thought I'll share a "fun" story. Friend reported weird bug - OmniPITR reported that xlogs are sent to archive, but they actually weren't. After some checking we found out that he was giving custom rsync-path (--rsync-path - path to rsync ...

Otto Bretz reported bug in OmniPITR. The bug was that when using -dr (remote destinations for backups) - you couldn't use --skip-xlogs. Obvious overlook on my side. Fix was trivial, and so 1.3.2 version was born.

On 12th of December, Simon Riggs committed patch: Allow time delayed standbys and recovery Set min_recovery_apply_delay to force a delay in recovery apply for commit and restore point WAL records. Other records are replayed immediately. Delay is measured between WAL record time and local ...

December 18th, 2013 by depesz | Tags: , , , , , , | No comments »

Right after releasing 1.3.0 I realized that I forgot about one thing. If you're using ext3 (and possibly other, not sure) file system, removal of large file can cause problems due to heavy IO traffic. We did hit this problem earlier at ...

December 16th, 2013 by depesz | Tags: , , , , , | 2 comments »

I just now committed new version of OmniPITR. You can download it from: GitHub PGXN The important change about 1.3.0 is that there is new tool - omnipitr-backup-cleanup. What is it for?

Title: OmniPITR v1.2.0 released It's been a while since last release, but the new one finally arrived, and has some pretty cool goodies :)

Yesterday, I did release new version of OmniPITR - 1.1.0. You can get it from github or from PgXN. What's new? Couple of things:

Finally, after all these years, version 1.0.0 of OmniPITR got Released. The reason I went to 1.0.0, and not 0.8.0 is very simple - finally, all programs in bin/ actually work :) By that I mean: since beginning there was "omnipitr-monitor" - ...

Just released new version of OmniPITR. This version has one important new feature: when you're calling omnipitr-backup-slave, it will make backups only of required xlog files, and not, as previously, of all in walarchive directory. This is important, especially in case you ...