Re: replication?

Поиск
Список
Период
Сортировка
От TomDB
Тема Re: replication?
Дата
Msg-id 1807736772.20061114221053@uk2.net
обсуждение исходный текст
Ответ на Re: replication?  ("Jim C. Nasby" <jim@nasby.net>)
Ответы Re: replication?  (Naz Gassiep <naz@mira.net>)
Список pgsql-admin
would there be any default available field (like the OID of the
records) that would be unique in the two versions of the datbase?
there isn't "by accident" something like a unique UID like an MD5 or
something... ?

cause if there is no replication available, I'd consider this
(together with PHP)

a) replacing the serial fields by generated UID's (md5 of ID + a
string that depends on the install)
or
b) start the autoincrement field at a high number in the second
install (since I can estimate that there will never by > 10 000
records)

+ store all queries that were performed & run them in the
network-master afterwards.




>>
>> I'd like to create a setup where there are exactly 2 masters which
>> need to be synchronized against each other. The two masters should
>> have read+write access, but don't have a permanent connection to each
>> other. One will be on a LAN-server, the other instance will be
>> installed on a Windows-client-laptop which can be taken along the
>> road. When coming back to the office, we need to sync the changed
>> data.
>>
>> is there any tool that will allow me to do so ?

> If you got *really* clever you could maybe pull it off with Slony, but
> in general, no, this isn't possible.



--
Best regards,
 TomDB                            mailto:tomdb@uk2.net


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

Предыдущее
От: TomDB
Дата:
Сообщение: Re: replication?
Следующее
От: "Simon Riggs"
Дата:
Сообщение: Re: Move indexes