Re: Postgres DB Migration from 8.3 to 9.1
| От | Amitabh Kant |
|---|---|
| Тема | Re: Postgres DB Migration from 8.3 to 9.1 |
| Дата | |
| Msg-id | CAPTAQBJH5Kvu+mNOdWSNxmaOX29RDTGor2WuFnyKVBAyJ3bXaA@mail.gmail.com обсуждение исходный текст |
| Ответ на | Postgres DB Migration from 8.3 to 9.1 (Vishalakshi Navaneethakrishnan <nvishalakshi@sirahu.com>) |
| Ответы |
Re: Postgres DB Migration from 8.3 to 9.1
|
| Список | pgsql-general |
On Fri, Oct 12, 2012 at 7:45 AM, Vishalakshi Navaneethakrishnan <nvishalakshi@sirahu.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
В списке pgsql-general по дате отправления: