Re: HA PostgreSQL

On Fri, Nov 01, 2002 at 01:31:24PM -0500, Charles H. Woloszynski wrote:
>
> I have seen a proposed solution that uses *rsync* on the database files
> between machines and linux-ha to roll over the network access to the
> available machine. My question is pretty simple; can something as
> *simple* as rsync make a full copy of the database consistently between
> the machines? That seems just too easy.

It is too easy. This has come up more than once recently, and I've
never seen an argument that using rsync this way is no better than
using tar on a live data area. If you want high availability, don't
do it.

A

--
----
Andrew Sullivan 204-4141 Yonge Street
Liberty RMS Toronto, Ontario Canada
<andrew(at)libertyrms(dot)info> M2P 2A8
+1 416 646 3304 x110