<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.0 Transitional//EN">
<HTML><HEAD>
<META http-equiv=Content-Type content="text/html; charset=us-ascii">
<META content="MSHTML 6.00.6000.16414" name=GENERATOR></HEAD>
<BODY>
<DIV dir=ltr align=left><SPAN class=781031417-21032007><FONT face=Arial
color=#0000ff size=2>Good to know that such tool is available now. Hopefully
it'll be integrated to the core distribution of postgres. </FONT></SPAN></DIV>
<DIV dir=ltr align=left><SPAN class=781031417-21032007><FONT face=Arial
color=#0000ff size=2>Is the tool capable of migrating earlier version such as
7.4.5 and 8.0 to the latest ?</FONT></SPAN></DIV>
<DIV dir=ltr align=left><SPAN class=781031417-21032007><FONT face=Arial
color=#0000ff size=2></FONT></SPAN> </DIV>
<DIV dir=ltr align=left><SPAN class=781031417-21032007><FONT face=Arial
color=#0000ff size=2>Thanks,</FONT></SPAN></DIV>
<DIV dir=ltr align=left><SPAN class=781031417-21032007><FONT face=Arial
color=#0000ff size=2></FONT></SPAN> </DIV>
<DIV dir=ltr align=left><SPAN class=781031417-21032007><FONT face=Arial
color=#0000ff size=2>--</FONT></SPAN></DIV>
<DIV dir=ltr align=left><SPAN class=781031417-21032007><FONT face=Arial
color=#0000ff size=2> Husam</FONT></SPAN></DIV><BR>
<DIV class=OutlookMessageHeader lang=en-us dir=ltr align=left>
<HR tabIndex=-1>
<FONT face=Tahoma size=2><B>From:</B> slony1-general-bounces@lists.slony.info
[mailto:slony1-general-bounces@lists.slony.info] <B>On Behalf Of </B>Shoaib
Mir<BR><B>Sent:</B> Wednesday, March 21, 2007 8:25 AM<BR><B>To:</B> Warren
Little<BR><B>Cc:</B> slony1-general@lists.slony.info<BR><B>Subject:</B> Re:
[Slony1-general] using slony to migrate large database from pg8.1 to
pg8.2<BR></FONT><BR></DIV>
<DIV></DIV>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="PADDING-LEFT: 1ex; MARGIN: 0pt 0pt 0pt 0.8ex; BORDER-LEFT: rgb(204,204,204) 1px solid">
<DIV>
<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="WORD-SPACING: 0px; FONT: 12px Helvetica; TEXT-TRANSFORM: none; COLOR: rgb(0,0,0); TEXT-INDENT: 0px; WHITE-SPACE: normal; LETTER-SPACING: normal; BORDER-COLLAPSE: separate; border-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>
<P>**********************************************************************<BR>This
message contains confidential information intended only for the use of the
addressee(s) named above and may contain information that is legally
privileged. If you are not the addressee, or the person responsible for
delivering it to the addressee, you are hereby notified that reading,
disseminating, distributing or copying this message is strictly
prohibited. If you have received this message by mistake, please
immediately notify us by replying to the message and delete the original message
immediately thereafter.</P>
<P>Thank you.</P>
<P><FONT
size=1>
FADLD
Tag</FONT><BR>**********************************************************************</P>
</BODY></HTML>