Re: [GENERAL] Postgres DB Migration from 8.3 to 9.1

2012-10-15 Thread Bruce Momjian
On Sun, Oct 14, 2012 at 12:13:03AM +, Jasen Betts wrote: > On 2012-10-12, Bruce Momjian wrote: > > On Thu, Oct 11, 2012 at 07:38:07PM -0700, John R Pierce wrote: > >> On 10/11/12 7:15 PM, Vishalakshi Navaneethakrishnan wrote: > >> >We have our production environment database server in Postgres

Re: [GENERAL] Postgres DB Migration from 8.3 to 9.1

2012-10-15 Thread Jasen Betts
On 2012-10-12, Vishalakshi Navaneethakrishnan 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 a

Re: [GENERAL] Postgres DB Migration from 8.3 to 9.1

2012-10-15 Thread Jasen Betts
On 2012-10-12, Bruce Momjian wrote: > On Thu, Oct 11, 2012 at 07:38:07PM -0700, John R Pierce wrote: >> On 10/11/12 7:15 PM, Vishalakshi Navaneethakrishnan wrote: >> >We have our production environment database server in Postgres 8.3 >> >version. we have planned to upgrade to lastest version 9.1.

Re: [GENERAL] Postgres DB Migration from 8.3 to 9.1

2012-10-12 Thread John R Pierce
On 10/12/12 9:52 PM, Vishalakshi Navaneethakrishnan wrote: While testing upgrade facility, I have installed postgres 9.2 using source package. Because it needs to be compiled with --disable-integer-datetimes. I have used this command ./configure --prefix=/opt/PostgreSQL/9.2/ --disable-integ

Re: [GENERAL] Postgres DB Migration from 8.3 to 9.1

2012-10-12 Thread Vishalakshi Navaneethakrishnan
Hi all, While testing upgrade facility, I have installed postgres 9.2 using source package. Because it needs to be compiled with --disable-integer-datetimes. I have used this command ./configure --prefix=/opt/PostgreSQL/9.2/ --disable-integer-datetimes --without-readline After installation i

Re: [GENERAL] Postgres DB Migration from 8.3 to 9.1

2012-10-12 Thread Scott Marlowe
On Thu, Oct 11, 2012 at 8:15 PM, Vishalakshi Navaneethakrishnan 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

Re: [GENERAL] Postgres DB Migration from 8.3 to 9.1

2012-10-12 Thread Bruce Momjian
On Thu, Oct 11, 2012 at 07:38:07PM -0700, John R Pierce wrote: > On 10/11/12 7:15 PM, Vishalakshi Navaneethakrishnan wrote: > >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

Re: [GENERAL] Postgres DB Migration from 8.3 to 9.1

2012-10-12 Thread Steve Crawford
On 10/12/2012 08:05 AM, Amitabh Kant wrote: On Fri, Oct 12, 2012 at 7:45 AM, Vishalakshi Navaneethakrishnan mailto: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

Re: [GENERAL] Postgres DB Migration from 8.3 to 9.1

2012-10-12 Thread Amitabh Kant
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 mo

Re: [GENERAL] Postgres DB Migration from 8.3 to 9.1

2012-10-11 Thread Raghavendra
> > 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 > h

Re: [GENERAL] Postgres DB Migration from 8.3 to 9.1

2012-10-11 Thread John R Pierce
On 10/11/12 7:15 PM, Vishalakshi Navaneethakrishnan wrote: 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.

Re: [GENERAL] Postgres DB Migration from 8.3 to 9.1

2012-10-11 Thread Gavin Flower
On 12/10/12 15:15, Vishalakshi Navaneethakrishnan 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 upg