AFAIK the tool only handles 8.1-8.2 right now. It also won't automatically handle any tables that would need the physical files re-written; in 8.1-8.2 that means any tables that have any internet address data types (inet, etc).
On Wed, Mar 21, 2007 at 10:15:43AM -0700, Tomeh, Husam wrote: > Good to know that such tool is available now. Hopefully it'll be > integrated to the core distribution of postgres. > Is the tool capable of migrating earlier version such as 7.4.5 and 8.0 > to the latest ? > > Thanks, > > -- > Husam > > ________________________________ > > From: [EMAIL PROTECTED] > [mailto:[EMAIL PROTECTED] On Behalf Of Shoaib Mir > Sent: Wednesday, March 21, 2007 8:25 AM > To: Warren Little > Cc: [email protected] > Subject: Re: [Slony1-general] using slony to migrate large database from > pg8.1 to pg8.2 > > > In order to do the same you can use pg_migrator > (http://pgfoundry.org/projects/pg-migrator/) as well. It will take a LOT > less time then normal backup/restore. > > -- > Shoaib Mir > EnterpriseDB (www.enterprisedb.com) > > > On 3/21/07, Warren Little < [EMAIL PROTECTED] > <mailto:[EMAIL PROTECTED]> > wrote: > > Hello, > I need to get data migrated from a pg8.1 cluster to a pg8.2 > cluster and was wondering how well slony will accomplish this task. > The database size is about 250GB, so doing a dump and restore > will take longer than the maintenance window for system downtime. > I have read several posts on the postgres mailing lists that > people recommend using slony to do major version upgrades, so I thought > to give it a try. > One of the concerns I have is regarding the limitation that > slony does not support large objects, is this referring to the postgres > LargeObject type? > ie are bytea fields of significant size replicated? > > Also, is there a guide to configuring Slony-I on an active > system, or is the procedure the same (aside for the standard "backup all > data before you begin") > > thanks > > > > Warren Little > Chief Technology Officer > Meridias Capital Inc > ph 866.369.7763 > > > > > _______________________________________________ > Slony1-general mailing list > [email protected] > http://lists.slony.info/mailman/listinfo/slony1-general > > > > > > ********************************************************************** > This message contains confidential information intended only for the use of > the addressee(s) named above and may contain information that is legally > privileged. If you are not the addressee, or the person responsible for > delivering it to the addressee, you are hereby notified that reading, > disseminating, distributing or copying this message is strictly prohibited. > If you have received this message by mistake, please immediately notify us by > replying to the message and delete the original message immediately > thereafter. > > Thank you. > > FADLD Tag > ********************************************************************** > _______________________________________________ > Slony1-general mailing list > [email protected] > http://lists.slony.info/mailman/listinfo/slony1-general -- Jim C. Nasby, Database Architect [EMAIL PROTECTED] Give your computer some brain candy! www.distributed.net Team #1828 Windows: "Where do you want to go today?" Linux: "Where do you want to go tomorrow?" FreeBSD: "Are you guys coming, or what?" _______________________________________________ Slony1-general mailing list [email protected] http://lists.slony.info/mailman/listinfo/slony1-general
