On Thu, Oct 11, 2012 at 8:15 PM, Vishalakshi Navaneethakrishnan <nvishalakshi@xxxxxxxxxx> 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..? As downtime required approaches zero, the likelyhood of needing slony approaches 1. -- Sent via pgsql-general mailing list (pgsql-general@xxxxxxxxxxxxxx) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-general