Re: Postgres DB Migration from 8.3 to 9.1 - Mailing list pgsql-general

From Jasen Betts
Subject Re: Postgres DB Migration from 8.3 to 9.1
Date
Msg-id k5cv37$rst$2@reversiblemaps.ath.cx
Whole thread Raw
In response to Postgres DB Migration from 8.3 to 9.1  (Vishalakshi Navaneethakrishnan <nvishalakshi@sirahu.com>)
List pgsql-general
On 2012-10-12, Vishalakshi Navaneethakrishnan <nvishalakshi@sirahu.com> wrote:
> --e0cb4efe29e2435cf104cbd3459b
> Content-Type: text/plain; charset=ISO-8859-1
>
> Hi Friends,
>
> We have our production environment database server in Postgres 8.3 version.
> we have planned to upgrade to lastest version 9.1. Dump from 8.3  and
> restore in Postgres 9.1 takes more than 5 hours. Any other quick method to
> upgrade from 8.3 to 9.1. We need to reduce our downtime  below 1 hour. Any
> Possibilities..?

Using slony1 you can continue to operate the 8.3 until the instant you
want to change over.

--
⚂⚃ 100% natural

pgsql-general by date:

Previous
From: Jasen Betts
Date:
Subject: Re: Postgres DB Migration from 8.3 to 9.1
Next
From: "Albe Laurenz"
Date:
Subject: Re: Improve MMO Game Performance