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

[GENERAL] Postgres DB Migration from 8.3 to 9.1

2012-10-11 Thread Vishalakshi Navaneethakrishnan
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