| From: | Amitabh Kant <amitabhkant(at)gmail(dot)com> |
|---|---|
| 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 15:05:49 |
| Message-ID: | CAPTAQBJH5Kvu+mNOdWSNxmaOX29RDTGor2WuFnyKVBAyJ3bXaA@mail.gmail.com |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-general |
On Fri, Oct 12, 2012 at 7:45 AM, Vishalakshi Navaneethakrishnan <
nvishalakshi(at)sirahu(dot)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
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Ondrej Ivanič | 2012-10-12 15:10:43 | Re: Strategies/Best Practises Handling Large Tables |
| Previous Message | Lonni J Friedman | 2012-10-12 15:00:08 | Re: Strategies/Best Practises Handling Large Tables |