Postgres Pro
Downloads
Home   >   mailing lists

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

From Scott Marlowe
Subject Re: Postgres DB Migration from 8.3 to 9.1
Date
Msg-id CAOR=d=0po_a931G44e1hWjMp-QU-=JZ_bbrn_MAxNv1CuKBm3g@mail.gmail.com
Whole thread Raw
In response to Postgres DB Migration from 8.3 to 9.1  (Vishalakshi Navaneethakrishnan <nvishalakshi@sirahu.com>)
Responses Re: Postgres DB Migration from 8.3 to 9.1  (Vishalakshi Navaneethakrishnan <nvishalakshi@sirahu.com>)
List pgsql-general
Tree view 
On Thu, Oct 11, 2012 at 8:15 PM, Vishalakshi Navaneethakrishnan
<nvishalakshi@sirahu.com> wrote:
> 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..?

As downtime required approaches zero, the likelyhood of needing slony
approaches 1.

pgsql-general by date:

Previous
From: Thalis Kalfigkopoulos
Date:
Subject: tablespace_oid alias?
Next
From: Tom Lane
Date:
Subject: Re: tablespace_oid alias?