| From: | Gavin Flower <GavinFlower(at)archidevsys(dot)co(dot)nz> |
|---|---|
| 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 02:33:18 |
| Message-ID: | 5077816E.705@archidevsys.co.nz |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-general |
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
| From | Date | Subject | |
|---|---|---|---|
| Next Message | John R Pierce | 2012-10-12 02:38:07 | Re: Postgres DB Migration from 8.3 to 9.1 |
| Previous Message | Tom Lane | 2012-10-12 02:18:21 | Re: AS s(a) vs. AS a |