Re: plpgsql: trigger insert new into other table (archive)

On 10/09/2012 09:55 AM, Matthijs Möhlmann wrote:

> Now we need to implement that all insert and update queries should be
> replicated to the some_archive database. Well, the question is how to
> do that?

Whatever you do, please don't roll your own. This is a solved problem.
If you plan on doing this kind of replication, please look into Slony,
Bucardo, or Londiste. They're all trigger-based replication systems that
have been in production use by several companies for years now. You're
much better off using them than cobbling something together yourself.

--
Shaun Thomas
OptionsHouse | 141 W. Jackson Blvd. | Suite 500 | Chicago IL, 60604
312-444-8534
sthomas@optionshouse.com

______________________________________________

See http://www.peak6.com/email_disclaimer/ for terms and conditions related to this email