From: | Chris Browne <cbbrowne(at)acm(dot)org> |
---|---|
To: | pgsql-sql(at)postgresql(dot)org |
Subject: | Re: replicating a table in several databases |
Date: | 2008-10-10 14:59:14 |
Message-ID: | 87fxn4ebst.fsf@dba2.int.libertyrms.com |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-sql |
gherzig(at)fmed(dot)uba(dot)ar (Gerardo Herzig) writes:
> 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?
Two answers tend to come up:
a) Slony-I (which I work on; URL below)
b) Londiste (originated by "Skype folks"; see also "Skype Tools")
Slony-I has more documentation; Londiste is reputed to be a bit easier
to configure (though being somewhat documentation-light may still
leave the bar set pretty high).
--
let name="cbbrowne" and tld="linuxdatabases.info" in name ^ "@" ^ tld;;
http://slony.info/
"My nostalgia for Icon makes me forget about any of the bad things. I
don't have much nostalgia for Perl, so its faults I remember."
-- Scott Gilbert comp.lang.python
From | Date | Subject | |
---|---|---|---|
Next Message | Christopher Maier | 2008-10-10 16:08:31 | Problem with delete trigger: how to allow only triggers to delete a row? |
Previous Message | Gerardo Herzig | 2008-10-10 11:58:53 | replicating a table in several databases |