Part I left off is I will also be moving the cluster to another  
server, so I need something that replicates over the network over time.
Nice to know such a tool is being developed  for future upgrades.

thx

On Mar 21, 2007, at 9:25 AM, Shoaib Mir wrote:

> 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> 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
>
>

Warren Little
Chief Technology Officer
Meridias Capital Inc
ph 866.369.7763



-------------- next part --------------
An HTML attachment was scrubbed...
URL: http://lists.slony.info/pipermail/slony1-general/attachments/20070321/c546d71a/attachment-0001.htm