Replicating new sequences

From: Todd Eddy <teddy(at)technologyimaging(dot)com>
To: pgsql-general(at)postgresql(dot)org
Subject: Replicating new sequences
Date: 2005-09-22 19:54:45
Message-ID: AFEEC67D-5CEE-4B29-B4EE-C035D490C237@technologyimaging.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

I know this gets asked all the time, but I'm having issues with
replication. I got Slony setup between two computers and that does
replication of transactions. But we have a table that because of how
it works new sequences are added on a somewhat regular basis, maybe a
couple times a day. Also replication needs to be "almost" instant
because we distribute the load so updates go to one database and
selects happen on another database. So having these sequences
replicate on a fairly quick basis is important.

I think what we need is a log based replication solution instead of
the trigger based solution of Slony or other replication systems out
there. Only one I've seen that does log based replications is
Mammoth. Which aside from the large price tag and closed source, it
also doesn't run on Debian, which is the current distribution we're
using on the database servers. Not a big problem at this point since
we're in a big transition so using something like suse. Are there
any other log based replication systems out there that would still
work? Thanks for any help.

--
Todd Eddy
Developer

The information contained in this email is CONFIDENTIAL AND
PRIVILEGED and is intended only for the individual to whom it is
addressed.

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Emi Lu 2005-09-22 19:59:22 Re: Questions about Rollback - after insert, update,
Previous Message Scott Marlowe 2005-09-22 19:43:19 Re: Questions about Rollback - after insert, update,