Re: HA PostgreSQL

Поиск
Список
Период
Сортировка
От Andrew Sullivan
Тема Re: HA PostgreSQL
Дата
Msg-id 20021108100756.C32733@mail.libertyrms.com
обсуждение исходный текст
Ответ на HA PostgreSQL  ("Charles H. Woloszynski" <chw@clearmetrix.com>)
Список 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 по дате отправления:

Предыдущее
От: Tom Lane
Дата:
Сообщение: Re: Restoring a db dump with tsearch fields fails
Следующее
От: Tom Lane
Дата:
Сообщение: Re: column names from temporary tables