[no subject]

On Thu, 2005-02-10 at 09:51, James P. Kinney III wrote:
> More brainstorming (after a mail crash yesterday!)
> 
> Postgresql 8 has a pretty good Write Ahead Logging. A seperate project I
> am looking at is to use the WAL as a way to syncronize two databases
> that are not in a mirror mode of any type.
> 
> The scenario: Main DB has the _real_ web transactions, user list,
> products, etc.  Second machine gats a clone of the main machine at a
> point in time. Second machine is hauled to a trade show where the net
> access is (or lack) prevents a direct line to the main db.
> 
> Second machine runs the transaction locally after a checkpoint in the
> WAL is set. After the show, the WAL is replayed back into the main
> machine to merge in the transactions from the satellite unit.
> 
> Other than the obvious issues of duplicated transactions (not likely
> except for possibly adding a new user) and the sequence id's for the
> transactions (I will have to double check that the sequencing id's are
> only used as record counters), are there any "gotcha's" that others have
> run across in anything similar?


</pre>
<!--X-Body-of-Message-End-->
<!--X-MsgBody-End-->
<!--X-Follow-Ups-->
<hr>
<ul><li><strong>Follow-Ups</strong>:
<ul>
<li><strong><a name="00345" href="msg00345.html">[ale] database conversion</a></strong>
<ul><li><em>From:</em> jkinney at localnetsolutions.com (James P. Kinney III)</li></ul></li>
</ul></li></ul>
<!--X-Follow-Ups-End-->
<!--X-References-->
<ul><li><strong>References</strong>:
<ul>
<li><strong><a name="00253" href="msg00253.html">[ale] database conversion</a></strong>
<ul><li><em>From:</em> jkinney at localnetsolutions.com (James P. Kinney III)</li></ul></li>
<li><strong><a name="00262" href="msg00262.html">[ale] database conversion</a></strong>
<ul><li><em>From:</em> kaboom at gatech.edu (Chris Ricker)</li></ul></li>
<li><strong><a name="00343" href="msg00343.html">[ale] database conversion</a></strong>
<ul><li><em>From:</em> jkinney at localnetsolutions.com (James P. Kinney III)</li></ul></li>
</ul></li></ul>
<!--X-References-End-->
<!--X-BotPNI-->
<ul>
<li>Prev by Date:
<strong><a href="msg00343.html">[ale] database conversion</a></strong>
</li>
<li>Next by Date:
<strong><a href="msg00345.html">[ale] database conversion</a></strong>
</li>
<li>Previous by thread:
<strong><a href="msg00343.html">[ale] database conversion</a></strong>
</li>
<li>Next by thread:
<strong><a href="msg00345.html">[ale] database conversion</a></strong>
</li>
<li>Index(es):
<ul>
<li><a href="maillist.html#00344"><strong>Date</strong></a></li>
<li><a href="threads.html#00344"><strong>Thread</strong></a></li>
</ul>
</li>
</ul>

<!--X-BotPNI-End-->
<!--X-User-Footer-->
<!--X-User-Footer-End-->
</body>
</html>