replicating a table in several databases

Поиск
Список
Период
Сортировка
От Gerardo Herzig
Тема replicating a table in several databases
Дата
Msg-id 48EF437D.40600@fmed.uba.ar
обсуждение исходный текст
Список pgsql-sql
Hi all. Im facing a situation where i have to replicate a table from
database A in databases B,C,F and so on.

The first (and only) thing i have in mind is using triggers with dblink
for comunications with the other DB's.

I dont even like the idea of replicating tables across databases, but itis kind of an order :(

Since dblink is not transactional, it seems error prone over time, so
the tables will be inconsistent sooner or later, right?

Do any have some less error-prone idea for this?

Thanks!

Gerardo


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

Предыдущее
От: "Sabin Coanda"
Дата:
Сообщение: Re: 100% CPU at concurent access
Следующее
От: Chris Browne
Дата:
Сообщение: Re: replicating a table in several databases