Re: Moving a live production database to different server and postgres release

From: Raymond O'Donnell <rod(at)iol(dot)ie>
To: Ulas Albayrak <ulas(dot)albayrak(at)gmail(dot)com>
Cc: pgsql-general(at)postgresql(dot)org
Subject: Re: Moving a live production database to different server and postgres release
Date: 2010-06-11 10:36:16
Message-ID: 4C1211A0.4030500@iol.ie
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

On 11/06/2010 11:24, Ulas Albayrak wrote:

> My initial idea was to use WAL archiving to reproduce the db on the
> new server and then get it up to date with the logs from the time of
> base backup creation to the time the new server can get up. That was
> until I found out WAL archiving doesn’t work between major postgreSQL
> releases.

Slony-I (http://www.slony.info) can handle different major releases,
allowing you to switch from one server to another in seconds.

Ray.

--
Raymond O'Donnell :: Galway :: Ireland
rod(at)iol(dot)ie

In response to

Browse pgsql-general by date

  From Date Subject
Next Message Merlin Moncure 2010-06-11 11:20:41 Re: Can ARRAY( ... ) generate text[][]?
Previous Message Ulas Albayrak 2010-06-11 10:24:15 Moving a live production database to different server and postgres release