Re: Using RSYNC for replication?

Поиск
Список
Период
Сортировка
От Tom Lane
Тема Re: Using RSYNC for replication?
Дата
Msg-id 22704.1043779183@sss.pgh.pa.us
обсуждение исходный текст
Ответ на Re: Using RSYNC for replication?  (jhihn1 <jhihn1@umbc.edu>)
Ответы Re: Using RSYNC for replication?  ("Shridhar Daithankar<shridhar_daithankar@persistent.co.in>" <shridhar_daithankar@persistent.co.in>)
Re: Using RSYNC for replication?  ("Denis A. Doroshenko" <d.doroshenko@omnitel.net>)
Список pgsql-general
jhihn1 <jhihn1@umbc.edu> writes:
> I don't understand what is so hard about doing it this way.

If you want separate installations, make separate installations.  Don't
expect multiple databases in a single installation to be implemented
with the same amount of overhead as separate installations would be.
If we did it that way, we'd legitimately get complaints.

> It would make replication so simple and fast.

No it wouldn't; as I've been trying to explain to you, there are a lot
of reasons why rsync'ing a database won't work.  Fixing a few of them
doesn't produce a working solution.  Nor are we going to contort the
system design to make a fundamentally wrongheaded approach to
replication work.  rsync is just not the basis of a workable solution,
because it doesn't and can't know anything about the database state or
the semantics of the different files in the database.

            regards, tom lane

В списке pgsql-general по дате отправления:

Предыдущее
От: Arjen van der Meijden
Дата:
Сообщение: Re: Using RSYNC for replication?
Следующее
От: Will Lowe
Дата:
Сообщение: Re: How do I unsubscribe?