Re: Replication for migration

From: Martin Spinassi <martins(dot)listz(at)gmail(dot)com>
To: Kenneth Marshall <ktm(at)rice(dot)edu>
Cc: pgsql-admin(at)postgresql(dot)org
Subject: Re: Replication for migration
Date: 2009-05-14 14:20:15
Message-ID: 1242310815.3314.65.camel@kr0sty.livra.local
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-admin

On Thu, 2009-05-14 at 08:59 -0500, Kenneth Marshall wrote:
> On Thu, May 14, 2009 at 10:57:26AM -0300, Martin Spinassi wrote:
> > Hi list!
> >
[snip]
> >
> > I'd love to read some experiences or advices, since I haven't done it
> > before. Also if you have some link o document that you think I must
> > read, it'll be welcomed.
> >
> >
> > Thanks to all.
> >
> >
> > Mart??n
> >
>
> 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.
>
> Cheers,
> Ken

Thanks for the advice Ken.

I've seen that slony documentation is huge! I'll give it a shot in
testing environment.

Cheers

Martin

In response to

Responses

Browse pgsql-admin by date

  From Date Subject
Next Message Dimitri Fontaine 2009-05-14 14:39:25 Re: Replication for migration
Previous Message Kenneth Marshall 2009-05-14 13:59:40 Re: Replication for migration