On Fri, Oct 12, 2012 at 7:45 AM, Vishalakshi Navaneethakrishnan < nvishalak...@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
