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: slony1-general-bounces at lists.slony.info
> [mailto:slony1-general-bounces at lists.slony.info] On Behalf Of Shoaib Mir
> Sent: Wednesday, March 21, 2007 8:25 AM
> To: Warren Little
> Cc: slony1-general at lists.slony.info
> 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 < warren.little at meridiascapital.com
> <mailto:warren.little at meridiascapital.com> > 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
> 	Slony1-general at lists.slony.info
> 	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
> Slony1-general at lists.slony.info
> http://lists.slony.info/mailman/listinfo/slony1-general


-- 
Jim C. Nasby, Database Architect                decibel at decibel.org 
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?"