Re: HA PostgreSQL - Mailing list pgsql-general

From Andrew Sullivan
Subject Re: HA PostgreSQL
Date
Msg-id 20021108100756.C32733@mail.libertyrms.com
Whole thread Raw
In response to HA PostgreSQL  ("Charles H. Woloszynski" <chw@clearmetrix.com>)
List pgsql-general
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@libertyrms.info>                              M2P 2A8
                                         +1 416 646 3304 x110


pgsql-general by date:

Previous
From: Tom Lane
Date:
Subject: Re: Restoring a db dump with tsearch fields fails
Next
From: Tom Lane
Date:
Subject: Re: column names from temporary tables