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 stho...@optionshouse.com ______________________________________________ See http://www.peak6.com/email_disclaimer/ for terms and conditions related to this email -- Sent via pgsql-general mailing list (pgsql-general@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-general