Re: Replication for migration - Mailing list pgsql-admin

From Martin Spinassi
Subject Re: Replication for migration
Date
Msg-id 1242310815.3314.65.camel@kr0sty.livra.local
Whole thread Raw
In response to Re: Replication for migration  (Kenneth Marshall <ktm@rice.edu>)
Responses Re: Replication for migration  (Dimitri Fontaine <dfontaine@hi-media.com>)
List 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


pgsql-admin by date:

Previous
From: Kenneth Marshall
Date:
Subject: Re: Replication for migration
Next
From: Dimitri Fontaine
Date:
Subject: Re: Replication for migration