<HTML><BODY style="word-wrap: break-word; -khtml-nbsp-mode: space; -khtml-line-break: after-white-space; ">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.<DIV>Nice to know such a tool is being developed for future upgrades.</DIV><DIV><BR class="khtml-block-placeholder"></DIV><DIV>thx</DIV><DIV><BR><DIV><DIV>On Mar 21, 2007, at 9:25 AM, Shoaib Mir wrote:</DIV><BR class="Apple-interchange-newline"><BLOCKQUOTE type="cite">In order to do the same you can use <SPAN style="font-weight: bold;">pg_migrator</SPAN> (<A href="http://pgfoundry.org/projects/pg-migrator/">http://pgfoundry.org/projects/pg-migrator/</A>) as well. It will take a LOT less time then normal backup/restore. <BR><BR>--<BR>Shoaib Mir<BR>EnterpriseDB (<A href="http://www.enterprisedb.com">www.enterprisedb.com</A>)<BR><BR><DIV><SPAN class="gmail_quote">On 3/21/07, <B class="gmail_sendername">Warren Little</B> <<A href="mailto:warren.little@meridiascapital.com"> warren.little@meridiascapital.com</A>> wrote:</SPAN><BLOCKQUOTE class="gmail_quote" style="border-left: 1px solid rgb(204, 204, 204); margin: 0pt 0pt 0pt 0.8ex; padding-left: 1ex;"><DIV style=""><DIV>Hello,</DIV><DIV>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.</DIV><DIV>The database size is about 250GB, so doing a dump and restore will take longer than the maintenance window for system downtime. </DIV><DIV>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.</DIV><DIV>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? </DIV><DIV>ie are bytea fields of significant size replicated?</DIV><DIV><BR></DIV><DIV>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") </DIV><DIV><BR></DIV><DIV>thanks</DIV><SPAN class="sg"><BR><DIV> <SPAN style="border-collapse: separate; border-spacing: 0px; color: rgb(0, 0, 0); font-family: Helvetica; font-size: 12px; font-style: normal; font-variant: normal; font-weight: normal; letter-spacing: normal; line-height: normal; text-indent: 0px; text-transform: none; white-space: normal; word-spacing: 0px;"> <DIV>Warren Little</DIV><DIV>Chief Technology Officer</DIV><DIV>Meridias Capital Inc</DIV><DIV>ph 866.369.7763</DIV><DIV><BR></DIV><BR></SPAN> </DIV><BR></SPAN></DIV><BR>_______________________________________________<BR> Slony1-general mailing list<BR><A onclick="return top.js.OpenExtLink(window,event,this)" href="mailto:Slony1-general@lists.slony.info">Slony1-general@lists.slony.info</A><BR><A onclick="return top.js.OpenExtLink(window,event,this)" href="http://lists.slony.info/mailman/listinfo/slony1-general" target="_blank"> http://lists.slony.info/mailman/listinfo/slony1-general</A><BR><BR></BLOCKQUOTE></DIV><BR></BLOCKQUOTE></DIV><BR><DIV> <SPAN class="Apple-style-span" style="border-collapse: separate; border-spacing: 0px 0px; color: rgb(0, 0, 0); font-family: Helvetica; font-size: 12px; font-style: normal; font-variant: normal; font-weight: normal; letter-spacing: normal; line-height: normal; text-align: auto; -khtml-text-decorations-in-effect: none; text-indent: 0px; -apple-text-size-adjust: auto; text-transform: none; orphans: 2; white-space: normal; widows: 2; word-spacing: 0px; "><DIV>Warren Little</DIV><DIV>Chief Technology Officer</DIV><DIV>Meridias Capital Inc</DIV><DIV>ph 866.369.7763</DIV><DIV><BR class="khtml-block-placeholder"></DIV><BR class="Apple-interchange-newline"></SPAN> </DIV><BR></DIV></BODY></HTML>