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: BB9A9755-561D-438A-A024-90D5CC7DDF60@khera.org
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
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

Responses

Browse pgsql-general by date

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