<html xmlns:v="urn:schemas-microsoft-com:vml" xmlns:o="urn:schemas-microsoft-com:office:office" xmlns:w="urn:schemas-microsoft-com:office:word" xmlns:m="http://schemas.microsoft.com/office/2004/12/omml" xmlns="http://www.w3.org/TR/REC-html40">
<head>
<meta http-equiv=Content-Type content="text/html; charset=us-ascii">
<meta name=Generator content="Microsoft Word 12 (filtered medium)">
<style>
<!--
/* Font Definitions */
@font-face
{font-family:Calibri;
panose-1:2 15 5 2 2 2 4 3 2 4;}
@font-face
{font-family:Tahoma;
panose-1:2 11 6 4 3 5 4 4 2 4;}
/* Style Definitions */
p.MsoNormal, li.MsoNormal, div.MsoNormal
{margin:0in;
margin-bottom:.0001pt;
font-size:12.0pt;
font-family:"Times New Roman","serif";}
a:link, span.MsoHyperlink
{mso-style-priority:99;
color:blue;
text-decoration:underline;}
a:visited, span.MsoHyperlinkFollowed
{mso-style-priority:99;
color:purple;
text-decoration:underline;}
span.EmailStyle17
{mso-style-type:personal-reply;
font-family:"Calibri","sans-serif";
color:#1F497D;}
.MsoChpDefault
{mso-style-type:export-only;}
@page Section1
{size:8.5in 11.0in;
margin:1.0in 1.0in 1.0in 1.0in;}
div.Section1
{page:Section1;}
-->
</style>
<!--[if gte mso 9]><xml>
<o:shapedefaults v:ext="edit" spidmax="1026" />
</xml><![endif]--><!--[if gte mso 9]><xml>
<o:shapelayout v:ext="edit">
<o:idmap v:ext="edit" data="1" />
</o:shapelayout></xml><![endif]-->
</head>
<body lang=EN-US link=blue vlink=purple>
<div class=Section1>
<p class=MsoNormal><span style='font-size:11.0pt;font-family:"Calibri","sans-serif";
color:#1F497D'>Dave’s points are valid, but I’d suggest a tweak
that I’ve found useful: use one of pg_dump’s ascii modes, keep the
pg_dump output and use rsync to do the copy to the laptop. If the updates
are rare and small, rsync (or a similar tool) will be much more efficient at
doing the copy, at the cost of keeping an extra copy of the database on the laptop.<o:p></o:p></span></p>
<p class=MsoNormal><span style='font-size:11.0pt;font-family:"Calibri","sans-serif";
color:#1F497D'><o:p> </o:p></span></p>
<p class=MsoNormal><span style='font-size:11.0pt;font-family:"Calibri","sans-serif";
color:#1F497D'>I found that, for my installation, this arrangement was easier
to set up and maintain than Slony or any of the other replication schemes for Postgres.<o:p></o:p></span></p>
<p class=MsoNormal><span style='font-size:11.0pt;font-family:"Calibri","sans-serif";
color:#1F497D'>Walter<o:p></o:p></span></p>
<p class=MsoNormal><span style='font-size:11.0pt;font-family:"Calibri","sans-serif";
color:#1F497D'><o:p> </o:p></span></p>
<div style='border:none;border-top:solid #B5C4DF 1.0pt;padding:3.0pt 0in 0in 0in'>
<p class=MsoNormal><b><span style='font-size:10.0pt;font-family:"Tahoma","sans-serif"'>From:</span></b><span
style='font-size:10.0pt;font-family:"Tahoma","sans-serif"'> slony1-general-bounces@lists.slony.info
[mailto:slony1-general-bounces@lists.slony.info] <b>On Behalf Of </b>Melvin
Davidson<br>
<b>Sent:</b> Wednesday, February 24, 2010 9:44 AM<br>
<b>To:</b> Slony1-general@lists.slony.info; Dave Stevenson<br>
<b>Subject:</b> Re: [Slony1-general] Is Slony for me?<o:p></o:p></span></p>
</div>
<p class=MsoNormal><o:p> </o:p></p>
<table class=MsoNormalTable border=0 cellspacing=0 cellpadding=0>
<tr>
<td valign=top style='padding:0in 0in 0in 0in'>
<p class=MsoNormal style='margin-bottom:12.0pt'>--- 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<o:p></o:p></p>
<div id=yiv1019121337>
<div>
<div>
<p class=MsoNormal><span style='font-family:"Arial","sans-serif"'>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:<o:p></o:p></span></p>
</div>
<div>
<p class=MsoNormal><span style='font-family:"Arial","sans-serif"'>
Replicating a pricing database from a central server to sales staff who
connect periodically to grab updates. <o:p></o:p></span></p>
</div>
<div>
<p class=MsoNormal><span style='font-family:"Arial","sans-serif"'> <o:p></o:p></span></p>
</div>
<div>
<p class=MsoNormal><span style='font-family:"Arial","sans-serif"'>I'm
wondering what is it about Slony that makes that scenario a bad match, or
what alternative might work better for me.<o:p></o:p></span></p>
</div>
<div>
<p class=MsoNormal><span style='font-family:"Arial","sans-serif"'> <o:p></o:p></span></p>
</div>
<div>
<p class=MsoNormal><span style='font-family:"Arial","sans-serif"'>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. <o:p></o:p></span></p>
</div>
<div>
<p class=MsoNormal><span style='font-family:"Arial","sans-serif"'> <o:p></o:p></span></p>
</div>
<div>
<p class=MsoNormal><span style='font-family:"Arial","sans-serif"'>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?<o:p></o:p></span></p>
</div>
<div>
<p class=MsoNormal><span style='font-family:"Arial","sans-serif"'> <o:p></o:p></span></p>
</div>
<div>
<p class=MsoNormal><span style='font-family:"Arial","sans-serif"'>Anyone know
of a better fit for my use case?<o:p></o:p></span></p>
</div>
<div>
<p class=MsoNormal><span style='font-family:"Arial","sans-serif"'> <o:p></o:p></span></p>
</div>
<div>
<p class=MsoNormal><span style='font-family:"Arial","sans-serif"'>Thanks,<br>
<o:p></o:p></span></p>
</div>
<p class=MsoNormal><span style='font-family:"Arial","sans-serif"'>Dave
Stevenson<br>
dave.stevenson@pacbell.net <o:p></o:p></span></p>
</div>
</div>
<p class=MsoNormal style='margin-bottom:12.0pt'><br>
-----Inline Attachment Follows-----<br>
<br>
_______________________________________________<br>
Slony1-general mailing list<br>
<a
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>
<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.<o:p></o:p></p>
<div>
<p class=MsoNormal style='margin-bottom:12.0pt'>>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?<o:p></o:p></p>
</div>
<p class=MsoNormal style='margin-bottom:12.0pt'>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.<o:p></o:p></p>
<div id=RTEContent>
<p class=MsoNormal style='margin-bottom:12.0pt'><b><span style='font-size:
13.5pt;font-family:"Arial","sans-serif";color:blue'>Melvin Davidson </span></b><o:p></o:p></p>
</div>
<p class=MsoNormal style='margin-bottom:12.0pt'><br>
<br>
<o:p></o:p></p>
</td>
</tr>
</table>
<p class=MsoNormal><span style='font-size:10.0pt;font-family:"Calibri","sans-serif"'><o:p> </o:p></span></p>
</div>
</body>
</html>