<table cellspacing="0" cellpadding="0" border="0" ><tr><td valign="top" style="font: inherit;">--- On <b>Wed, 2/24/10, Dave Stevenson <i><dave.stevenson@pacbell.net></i></b> wrote:<br><br>From: Dave Stevenson <dave.stevenson@pacbell.net><br>Subject: [Slony1-general] Is Slony for me?<br>To: Slony1-general@lists.slony.info<br>Date: Wednesday, February 24, 2010, 11:28 AM<br><br><div id="yiv1019121337"><style type="text/css"><!--#yiv1019121337 DIV {margin:0px;}--></style><div style="font-family: arial,helvetica,sans-serif; font-size: 12pt;">
<div>I'm looking for a replication solution, but I'm no DBA. My use
case is probably similar to the following, listed in Slony's online doc
as a poor match for Slony:</div>
<div> Replicating a pricing database from a central server to sales staff who connect periodically to grab updates. </div>
<div> </div>
<div>I'm wondering what is it about Slony that makes that scenario a bad match, or what alternative might work better for me.</div>
<div> </div>
<div>I use Postgresql as a source code repository. However, the server
is remote, and access is typically very slow. I'd like to have a
read-only local copy for comparing, reconciling, loading, etc., and
access the remote server only for writes (publish). Typical usage is
lots of reads, few writes, very rare and limited updates, even more
rare and limited deletes (few times per year?), and maybe once every
2-4 years a schema change. </div>
<div> </div>
<div>If I have a local clone on my laptop, it will often be offline (at
night). Is Slony a bad match because the slave would miss updates while
offline?</div>
<div> </div>
<div>Anyone know of a better fit for my use case?</div>
<div> </div>
<div>Thanks,<br> </div>Dave Stevenson<br>dave.stevenson@pacbell.net
</div></div><br>-----Inline Attachment Follows-----<br><br>_______________________________________________<br>Slony1-general mailing list<br><a ymailto="mailto:Slony1-general@lists.slony.info" href="http://us.mc530.mail.yahoo.com/mc/compose?to=Slony1-general@lists.slony.info">Slony1-general@lists.slony.info</a><br><a href="http://lists.slony.info/mailman/listinfo/slony1-general" target="_blank">http://lists.slony.info/mailman/listinfo/slony1-general</a><br><font size="3"><br>>I'd like to have a read-only local copy for comparing, reconciling, loading, <br>>etc.<br><br>Good news. Slony is excellent for that situation.<br><br></font><div><font size="3">>If I have a local clone on my laptop, it will often be offline (at
night). Is Slony a <br>>bad match because the slave would miss updates while
offline?<br><br></font></div>
<font size="3">Bad news. Unless there is only a small amount of updates (DML) that will be occurring while your laptop is offline, it will take a long time for slony to synchronize and catch up with transactions that occurred. If your database is small enough, you might be better off just doing a pg_dump of the master, and then copy it to the laptop, drop the old database, make a new db and then pg_restore the new copy.<br></font><br><div id="RTEContent"><font size="4"><span style="font-weight: bold; font-family: arial; color: rgb(0, 0, 255);">Melvin Davidson </span></font><br> <font size="3"> </font><font size="3"><span style="font-weight: bold; font-family: courier;"><br></span></font></div><br><br><br></td></tr></table><br>