Re: Postgres DB Migration from 8.3 to 9.1

From: Scott Marlowe <scott(dot)marlowe(at)gmail(dot)com>
To: Vishalakshi Navaneethakrishnan <nvishalakshi(at)sirahu(dot)com>
Cc: pgsql-general(at)postgresql(dot)org
Subject: Re: Postgres DB Migration from 8.3 to 9.1
Date: 2012-10-12 22:07:09
Message-ID: CAOR=d=0po_a931G44e1hWjMp-QU-=JZ_bbrn_MAxNv1CuKBm3g@mail.gmail.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

On Thu, Oct 11, 2012 at 8:15 PM, Vishalakshi Navaneethakrishnan
<nvishalakshi(at)sirahu(dot)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.

In response to

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Tom Lane 2012-10-12 23:00:57 Re: tablespace_oid alias?
Previous Message Thalis Kalfigkopoulos 2012-10-12 21:23:16 tablespace_oid alias?