Wed Mar 21 08:19:04 PDT 2007
- Previous message: [Slony1-general] RFC tool to support development / operations work with slony replicated databases, second revision.
- Next message: [Slony1-general] using slony to migrate large database from pg8.1 to pg8.2
- Messages sorted by: [ date ] [ thread ] [ subject ] [ author ]
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 -------------- next part -------------- An HTML attachment was scrubbed... URL: http://lists.slony.info/pipermail/slony1-general/attachments/20070321/cc5391f7/attachment.htm
- Previous message: [Slony1-general] RFC tool to support development / operations work with slony replicated databases, second revision.
- Next message: [Slony1-general] using slony to migrate large database from pg8.1 to pg8.2
- Messages sorted by: [ date ] [ thread ] [ subject ] [ author ]
More information about the Slony1-general mailing list