The preferred method is to off-load the replication to an appliance (storage) that allows for snapshots and delta replication. That way if you corrupt data at your primary site you will have the ability to recover to a known good point in time at your DR site and be up and running in a few minutes rather than hours/days. This method also relieves your pSQL server from any of the replication burden.
<br><br><div class="gmail_quote">On Dec 12, 2007 3:04 PM, Augie Schwer <<a href="mailto:augie.schwer@gmail.com">augie.schwer@gmail.com</a>> wrote:<br><blockquote class="gmail_quote" style="border-left: 1px solid rgb(204, 204, 204); margin: 0pt 0pt 0pt 0.8ex; padding-left: 1ex;">
How are people doing PostgreSQL replication?<br><br>Looking around on the web it seems that there is no built in way to do<br>PostgreSQL replication and that there are several third party tools,<br>so my question is: what way is the best way?
<br><br>The point of this would be to do live backups and have a stand by<br>server in case I needed it.<br><br>Any suggestions?<br><br><br>--<br>Augie Schwer - <a href="mailto:Augie@Schwer.us">Augie@Schwer.us</a> -
<a href="http://schwer.us" target="_blank">http://schwer.us</a><br>Key fingerprint = 9815 AE19 AFD1 1FE7 5DEE 2AC3 CB99 2784 27B0 C072<br><br>_______________________________________________<br>SoCoSA discuss mailing list<br>
<a href="mailto:discuss@socosa.org">discuss@socosa.org</a><br>Your address: <a href="mailto:robintclark@gmail.com">robintclark@gmail.com</a><br><a href="http://socosa.org/mailman/listinfo/discuss" target="_blank">http://socosa.org/mailman/listinfo/discuss
</a><br><a href="http://socosa.org/mailman/options/discuss/robintclark%40gmail.com" target="_blank">http://socosa.org/mailman/options/discuss/robintclark%40gmail.com</a><br></blockquote></div><br><br clear="all"><br>-- <br>
Rob Clark<br><a href="mailto:robintclark@gmail.com">robintclark@gmail.com</a>