Postgres Pro
Downloads
Home   >   mailing lists

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

From Vishalakshi Navaneethakrishnan
Subject Postgres DB Migration from 8.3 to 9.1
Date
Msg-id CAP-PUP3-xbZ9O9BDm+sA9B07gW9hqG5j6n-Sd+n2GLbXh9p0gg@mail.gmail.com
Whole thread Raw
Responses Re: Postgres DB Migration from 8.3 to 9.1  (Gavin Flower <GavinFlower@archidevsys.co.nz>)
Re: Postgres DB Migration from 8.3 to 9.1  (John R Pierce <pierce@hogranch.com>)
Re: Postgres DB Migration from 8.3 to 9.1  (Amitabh Kant <amitabhkant@gmail.com>)
Re: Postgres DB Migration from 8.3 to 9.1  (Scott Marlowe <scott.marlowe@gmail.com>)
List pgsql-general
Tree view
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

pgsql-general by date:

Previous
From: Thalis Kalfigkopoulos
Date:
Subject: AS s(a) vs. AS a
Next
From: Tom Lane
Date:
Subject: Re: AS s(a) vs. AS a