Keeping 2 db updated each-other

Поиск
Список
Период
Сортировка
От Sandro Dentella
Тема Keeping 2 db updated each-other
Дата
Msg-id 200002281921.UAA09349@bluff.ermit.it
обсуждение исходный текст
Список pgsql-general
Hi,

  I need to keep updated to databases (little ~ 100.000 record splitted in 15
  tables). Is there any general tip?

  Since the database is handles via tcl-tk I'm logging all
  update/delete/insert so as to pass the whole bunch of 'not yet updated'
  statement to the database that needs updating. This requires having all
  statements referenced w/ primary key becouse OID are different on different
  hosts. This seems to work but is quite tricky.

  Is there a better solution?

  Thanks in advance
  sandro



--
Sandro Dentella  *:-)
e-mail: sandro.dentella@mi.infn.it sandro@ermit.it

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

Предыдущее
От: "Henrique Pantarotto"
Дата:
Сообщение: RE: RES: [GENERAL] Stored procedures returning multiple values... ?
Следующее
От: Peter Eisentraut
Дата:
Сообщение: Re: [GENERAL] psql 7.0.0 beta