Skip site navigation (1) Skip section navigation (2)

Re: Replication for migration

From: Dimitri Fontaine <dfontaine(at)hi-media(dot)com>
To: martins(dot)listz(at)gmail(dot)com
Cc: Kenneth Marshall <ktm(at)rice(dot)edu>, pgsql-admin(at)postgresql(dot)org
Subject: Re: Replication for migration
Date: 2009-05-14 14:39:25
Message-ID: (view raw, whole thread or download thread mbox)
Lists: pgsql-admin

Martin Spinassi <martins(dot)listz(at)gmail(dot)com> writes:
> On Thu, 2009-05-14 at 08:59 -0500, Kenneth Marshall wrote:
>> I used Slony replication to upgrade a database from 8.2 -> 8.3 and
>> it worked quite well. You will need an outage to change the master
>> to the 8.3 database and re-point your apps, but if scripted, that
>> is minimal.
> I've seen that slony documentation is huge! I'll give it a shot in
> testing environment.

The skytools project's documentation is an easy read ;)

Londiste in its current stable version (2.1.9) doesn't support failover,
but as long as you're migrating away from 8.2 I suppose you don't need
to be able to switch back.

The procedure would then be:
 - setup londiste and replicate data
 - enter site maintenance mode (no more writes on the database)
 - wait for the londiste logs to show there's nothing to replicate
   (while waiting, maybe setup the site to point to 8.3)
 - open up the site again, on 8.3
 - shut down the londiste daemons and the 8.2 pg server

The waiting for emptying queues shouldn't be very long, expect 3s to
30s, but be sure to test it before switching for real, of course.


In response to

pgsql-admin by date

Next:From: Devrim GÜNDÜZDate: 2009-05-14 14:56:59
Subject: Re: pg_top problem
Previous:From: Martin SpinassiDate: 2009-05-14 14:20:15
Subject: Re: Replication for migration

Privacy Policy | About PostgreSQL
Copyright © 1996-2017 The PostgreSQL Global Development Group