Re: mirroring databases

Поиск
Список
Период
Сортировка
От D. Duccini
Тема Re: mirroring databases
Дата
Msg-id Pine.GSO.4.03.10207181500470.2150-100000@ra.bpsi.net
обсуждение исходный текст
Ответ на Re: mirroring databases  (April L <april@i-netco.com>)
Список pgsql-novice
> What is the general method for replacing changed records and adding new
> records, between remote locations? Assume a one-way sync, ie a mirror.
> Records will only be added or changed at one location.

make a 'diff' kind of file based on the changed information -- you can
either send out the changes to a file to be processed remotely by a piece
of software, or you can create a dump kind of file for direct import

of course you could also look at doing a file-level replication using
something like rsync

-----------------------------------------------------------------------------
david@backpack.com            BackPack Software, Inc.        www.backpack.com
+1 651.645.7550 voice       "Life is an Adventure.
+1 651.645.9798 fax            Don't forget your BackPack!"
-----------------------------------------------------------------------------


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

Предыдущее
От: Josh Berkus
Дата:
Сообщение: Re: special accents in text columns
Следующее
От: AarniRuuhimäki / Megative Tmi / KYMI.com
Дата:
Сообщение: Re: Newbie Stupid Question