On 23rd of January, Robert Haas committed patch: pg_isready New command-line utility to test whether a server is ready to accept connections. Phil Sorber, reviewed by Michael Paquier and Peter Eisentraut

April 4th, 2012 by depesz | Tags: , , , , | 23 comments »

Important disclaimer: the module that I'm writing about was written by my colleague Phil Sorber. We all have been in, or heard about, situation like this: $ update users set password = '...'; where id = 123; (hint: first ; is before where). Of ...

Today, I released new version of OmniPITR - 0.5.0. This new version has one important new feature - which is so called "direct destination" for backups. What it means? What it does? How it helps? Let's see...

During last months I wrote some tools to help me with my daily duties. I'd like to let you know you about them, as you might find them useful. So, here we go:

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

Really cool news. Thanks to sponsoring from AWeber.com, and code by Brian Dunavant OmniPITR has now support for additional tablespaces in backup creation. This works on both master and slave, and happens automatically without any kind of user interaction or changing ...

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

June 2nd, 2010 by depesz | Tags: , , , , | 16 comments »

Thanks to the company I work for OmniTI I was working on pretty cool project. Name of the project is OmniPITR, and here is what it is, why, how, and where to get it.