Re: [ADMIN] upgrading postgres version

2009-10-23 Thread Scott Marlowe
On Fri, Oct 23, 2009 at 4:26 PM, Anj Adu wrote: > All our postgres versions are 8.1.x. pg_migrator supports only 8.2 > and above.. We used slony to migrate from 8.1 to 8.3 flawlessly. The nice this is it let us run the 8.3 database as a slave, where we could point x% of traffic to it to see

Re: [ADMIN] upgrading postgres version

2009-10-23 Thread Anj Adu
All our postgres versions are 8.1.x. pg_migrator supports only 8.2 and above.. I''ll check out slony..thanks On Fri, Oct 23, 2009 at 3:06 PM, Scott Marlowe wrote: > On Fri, Oct 23, 2009 at 4:00 PM, Anj Adu wrote: >> We have several databases over 700Gb. A full dump can take  a very long ti

Re: [ADMIN] upgrading postgres version

2009-10-23 Thread Scott Marlowe
On Fri, Oct 23, 2009 at 4:00 PM, Anj Adu wrote: > We have several databases over 700Gb. A full dump can take  a very long time. > > is there any plan in the future to address migration of databases from > a 8.x.y release to a 8.y.x release.. Oh and there's a migration application as of 8.4 that m

Re: [ADMIN] upgrading postgres version

2009-10-23 Thread Scott Marlowe
On Fri, Oct 23, 2009 at 4:00 PM, Anj Adu wrote: > We have several databases over 700Gb. A full dump can take  a very long time. > > is there any plan in the future to address migration of databases from > a 8.x.y release to a 8.y.x release.. > > Due to the current nature of migration(  full dump a

[ADMIN] upgrading postgres version

2009-10-23 Thread Anj Adu
We have several databases over 700Gb. A full dump can take a very long time. is there any plan in the future to address migration of databases from a 8.x.y release to a 8.y.x release.. Due to the current nature of migration( full dump and restore)...we simply cannot migrate without a lot of dow