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