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
>
>
-------------- next part --------------
An HTML attachment was scrubbed...
URL: http://lists.slony.info/pipermail/slony1-general/attachments/20070321/=
50c6d1e4/attachment.htm