replicating a table in several databases - Mailing list pgsql-sql

From Gerardo Herzig
Subject replicating a table in several databases
Date
Msg-id 48EF437D.40600@fmed.uba.ar
Whole thread Raw
List 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 by date:

Previous
From: "Sabin Coanda"
Date:
Subject: Re: 100% CPU at concurent access
Next
From: Chris Browne
Date:
Subject: Re: replicating a table in several databases