[OSGeo-Discuss] Migrating to Postgres 9 for replication?

[Benjamin Henrion]

On Thu, May 10, 2012 at 2:08 PM, Jo Walsh <jo.walsh at ed.ac.uk> wrote:
> I would love to hear success stories or horror stories about migrating from
> Postgres 8.3 or 8.4 to 9, in order to get replication working. At least that
> is what I have been told we need to do. One master database and two failover
> copies.
>
> It would save a lot of maintenance time, I am imagining!

I wrote some scripts to do point in time recovery (PITR), live backup
using rsync, and booting a slave with pgbackup.

I will release them soon on github, will keep you posted.

-- 
Benjamin Henrion <bhenrion at ffii.org>
FFII Brussels - +32-484-566109 - +32-2-3500762
"In July 2005, after several failed attempts to legalise software
patents in Europe, the patent establishment changed its strategy.
Instead of explicitly seeking to sanction the patentability of
software, they are now seeking to create a central European patent
court, which would establish and enforce patentability rules in their
favor, without any possibility of correction by competing courts or
democratically elected legislators."