replicating a table in several databases

From: Gerardo Herzig <gherzig(at)fmed(dot)uba(dot)ar>
To: pgsql-sql(at)postgresql(dot)org
Subject: replicating a table in several databases
Date: 2008-10-10 11:58:53
Message-ID: 48EF437D.40600@fmed.uba.ar
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: 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 it
is 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

Responses

Browse pgsql-sql by date

  From Date Subject
Next Message Chris Browne 2008-10-10 14:59:14 Re: replicating a table in several databases
Previous Message Sabin Coanda 2008-10-10 11:25:55 Re: 100% CPU at concurent access