Quick Links

Postgres DB Migration from 8.3 to 9.1

From:	Vishalakshi Navaneethakrishnan <nvishalakshi(at)sirahu(dot)com>
To:	pgsql-general(at)postgresql(dot)org
Subject:	Postgres DB Migration from 8.3 to 9.1
Date:	2012-10-12 02:15:47
Message-ID:	CAP-PUP3-xbZ9O9BDm+sA9B07gW9hqG5j6n-Sd+n2GLbXh9p0gg@mail.gmail.com
Views:	Raw Message \| Whole Thread \| Download mbox \| Resend email
Thread:
Lists:	pgsql-general

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

Responses

Re: Postgres DB Migration from 8.3 to 9.1 at 2012-10-12 02:33:18 from Gavin Flower
Re: Postgres DB Migration from 8.3 to 9.1 at 2012-10-12 02:38:07 from John R Pierce
Re: Postgres DB Migration from 8.3 to 9.1 at 2012-10-12 15:05:49 from Amitabh Kant
Re: Postgres DB Migration from 8.3 to 9.1 at 2012-10-12 22:07:09 from Scott Marlowe
Re: Postgres DB Migration from 8.3 to 9.1 at 2012-10-13 23:56:23 from Jasen Betts

Browse pgsql-general by date

	From	Date	Subject
Next Message	Tom Lane	2012-10-12 02:18:21	Re: AS s(a) vs. AS a
Previous Message	Tom Lane	2012-10-12 00:27:15	Re: How to raise index points when equal and like is used with gist ?