Long time ago I wrote first version of explain.depesz.com. Since then I gradually improve it. But, what was lacking was a way to paste queries too - explain.depesz.com handles explains, but not plain queries. Now this has changed. I created new ...

December 22nd, 2013 by depesz | Tags: , , , , , , , | Comments Off on OmniPITR 1.3.2

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.

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:

One of the features that is actually disliked is anonymization. But, regardless of the dislike - it has some users. And one of the user mailed me with information about a bug - namely - foreign table file names were ...

July 2nd, 2012 by depesz | Tags: , , | Comments Off on OmniPITR 1.0.0 released

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" - ...

May 7th, 2012 by depesz | Tags: , , , , , | Comments Off on OmniPITR 0.7.0

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 ...

April 26th, 2012 by depesz | Tags: , , , , | Comments Off on OmniPITR 0.6.0

Just released new version, 0.6.0 (it should be visible on pgxn soon) of OmniPITR set of tools. New version has one new feature - parallelism. This works in omnipitr-archive and omnipitr-backup-* programs, and allows for parallel delivery to remote destinations (multiple -dr ...

January 4th, 2012 by depesz | Tags: , , , , , , , | Comments Off on OmniPITR 0.3.0

Just released version 0.3.0 of our tool for handling WAL based replication in PostgreSQL - OmniPITR. Version jump is related to addition of another tool - omnipitr-synch. This tool is used to copy PostgreSQL data dir (including all tablespaces of course) ...