Postgres Pro
Downloads
Home   >   mailing lists

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

From Amitabh Kant
Subject Re: Postgres DB Migration from 8.3 to 9.1
Date
Msg-id CAPTAQBJH5Kvu+mNOdWSNxmaOX29RDTGor2WuFnyKVBAyJ3bXaA@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  (Steve Crawford <scrawford@pinpointresearch.com>)
List pgsql-general
Tree view
On Fri, Oct 12, 2012 at 7:45 AM, 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..?

Thanks in Advance.

--
Best Regards,
Vishalakshi.N


Try using the -j <number-of-jobs> option to speed up restore process. See http://www.postgresql.org/docs/9.1/static/app-pgrestore.html . Not  sure though whether it will bring it up within your range. 

Amitabh

pgsql-general by date:

Previous
From: Lonni J Friedman
Date:
Subject: Re: Strategies/Best Practises Handling Large Tables
Next
From: Ondrej Ivanič
Date:
Subject: Re: Strategies/Best Practises Handling Large Tables