Replicating new sequences
От | Todd Eddy |
---|---|
Тема | Replicating new sequences |
Дата | |
Msg-id | AFEEC67D-5CEE-4B29-B4EE-C035D490C237@technologyimaging.com обсуждение исходный текст |
Ответы |
Re: Replicating new sequences
|
Список | 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.
В списке pgsql-general по дате отправления: