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

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 (view raw or flat)
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

pgsql-admin by date

Next:From: Dimitri FontaineDate: 2009-05-14 14:39:25
Subject: Re: Replication for migration
Previous:From: Kenneth MarshallDate: 2009-05-14 13:59:40
Subject: Re: Replication for migration

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