Postgres Pro
Downloads
Home   >   mailing lists

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

From Gavin Flower
Subject Re: Postgres DB Migration from 8.3 to 9.1
Date
Msg-id 5077816E.705@archidevsys.co.nz
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  (Raghavendra <raghavendra.rao@enterprisedb.com>)
List pgsql-general
Tree view
On 12/10/12 15:15, Vishalakshi Navaneethakrishnan 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

Have you considered migrating to 9.2?  It has some performance and other useful enhancements over 9.1.

I suspect that testing on early versions of 9.2.2 might be a good idea, with the intent of migrating to 9.2.2 when it is ready for production use.


Cheers.
Gavin

pgsql-general by date:

Previous
From: Tom Lane
Date:
Subject: Re: AS s(a) vs. AS a
Next
From: John R Pierce
Date:
Subject: Re: Postgres DB Migration from 8.3 to 9.1