On 2012-10-12, Vishalakshi Navaneethakrishnan <nvishalakshi@xxxxxxxxxx> wrote: > --e0cb4efe29e2435cf104cbd3459b > Content-Type: text/plain; charset=ISO-8859-1 > > 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..? Using slony1 you can continue to operate the 8.3 until the instant you want to change over. -- ⚂⚃ 100% natural -- Sent via pgsql-general mailing list (pgsql-general@xxxxxxxxxxxxxx) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-general