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

Re: Restoring 8.0 db to 8.1

From: Vivek Khera <vivek(at)khera(dot)org>
To: PGSQL Mailing List <pgsql-general(at)postgresql(dot)org>
Subject: Re: Restoring 8.0 db to 8.1
Date: 2007-12-21 20:59:21
Message-ID: (view raw, whole thread or download thread mbox)
Lists: pgsql-general
On Dec 21, 2007, at 11:09 AM, Martijn van Oosterhout wrote:

> The usual answer is use slony. You can use it to replicate the 8.0
> server onto an 8.1 server. This may take weeks/months/years/whatever  
> to
> synchronise. When the slave is up to date, you pull the plug on the  
> 8.0
> server and get everyone to use the 8.1 server... No downtime...

except he has large objects, which slony can't replicate.

In response to


pgsql-general by date

Next:From: Glyn AstillDate: 2007-12-21 21:03:00
Subject: Warm standby system - FATAL: the database system is starting up
Previous:From: Webb SpragueDate: 2007-12-21 20:36:35
Subject: Re: FK creation -- "ON DELETE NO ACTION" seems to be a no-op

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