[no subject]

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?
-- 
James P. Kinney III          \Changing the mobile computing world/
CEO & Director of Engineering \          one Linux user         /
Local Net Solutions,LLC        \           at a time.          /
770-493-8244                    \.___________________________./
<a  rel="nofollow" href="http://www.localnetsolutions.com";>http://www.localnetsolutions.com</a>

GPG ID: 829C6CA7 James P. Kinney III (M.S. Physics)
&lt;jkinney at localnetsolutions.com&gt;
Fingerprint = 3C9E 6366 54FC A3FE BA4D 0659 6190 ADC3 829C 6CA7
-------------- next part --------------
A non-text attachment was scrubbed...
Name: not available
Type: application/pgp-signature
Size: 189 bytes
Desc: This is a digitally signed message part



</pre>
<!--X-Body-of-Message-End-->
<!--X-MsgBody-End-->
<!--X-Follow-Ups-->
<hr>
<ul><li><strong>Follow-Ups</strong>:
<ul>
<li><strong><a name="00344" href="msg00344.html">[ale] database conversion</a></strong>
<ul><li><em>From:</em> cfowler at outpostsentinel.com (Christopher Fowler)</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>
</ul></li></ul>
<!--X-References-End-->
<!--X-BotPNI-->
<ul>
<li>Prev by Date:
<strong><a href="msg00342.html">[ale] anybody know how to setup network printing under Suse 9.0 ?</a></strong>
</li>
<li>Next by Date:
<strong><a href="msg00344.html">[ale] database conversion</a></strong>
</li>
<li>Previous by thread:
<strong><a href="msg00300.html">[ale] database conversion</a></strong>
</li>
<li>Next by thread:
<strong><a href="msg00344.html">[ale] database conversion</a></strong>
</li>
<li>Index(es):
<ul>
<li><a href="maillist.html#00343"><strong>Date</strong></a></li>
<li><a href="threads.html#00343"><strong>Thread</strong></a></li>
</ul>
</li>
</ul>

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