Re: Fast Table Replication / Mirroring

Поиск
Список
Период
Сортировка
От Marc G. Fournier
Тема Re: Fast Table Replication / Mirroring
Дата
Msg-id 20030829005853.M30178@ganymede.hub.org
обсуждение исходный текст
Ответ на Fast Table Replication / Mirroring  (Alex <alex@meerkatsoft.com>)
Список pgsql-general

On Fri, 29 Aug 2003, Alex wrote:

> Hi,
> I saw some replication projects but think this might be an overkill for
> my intentions.
>
> I have two databases, Primary / Secondary where the Secondary is
> readyonly for
> users. I need to mirror tables when changes occur on that table. That
> may happen a few times a day.
> Tables are in the area of  few 100k records.
>
> A) Is there an easy way to copy the data from Primary to Secondary
>      Can this be triggered by updates on the primary table ?

We're actually using eRServer inhouse for this, to keep "local copies" of
on specific table in sync between several servers ...


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

Предыдущее
От: Sander Smeenk
Дата:
Сообщение: Re: PostgreSQL upgrade -> fails to start server
Следующее
От: david_shadovitz@xontech.com (David Shadovitz)
Дата:
Сообщение: Re: CHAR vs TEXT args