From: | Achilleas Mantzios <achill(at)smadev(dot)internal(dot)net> |
---|---|
To: | pgsql-general(at)postgresql(dot)org |
Subject: | Re: Fine-grained replication? |
Date: | 2012-06-19 10:13:36 |
Message-ID: | 201206191313.36866.achill@smadev.internal.net |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-general |
On Τρι 19 Ιουν 2012 13:09:28 Guillaume Lelarge wrote:
> On Mon, 18 Jun 2012 14:49:32 -0700 (PDT), Paul Jones <pbj(at)cmicdo(dot)com>
>
> wrote:
> > Is anyone aware of other non-trigger-based, fine-grained replication
>
> tools
>
> > for PostgreSQL along the lines of the XReader
> > <http://wiki.postgresql.org/wiki/XReader> or pgreplay
> > <http://pgreplay.projects.postgresql.org/>?
>
> If you want fine grained replication, it means you won't be able to use
> log shipping and streaming replication. If you don't want trigger based
> replication, you won't have many options still available. pgPool comes to
> mind but, AFAIK, it isn't fine grained (and, to be honest, I would say it
> isn't really replication).
>
> So, nope, sorry.
>
> BTW, what's the issue with trigger-based replication? it really helps a
> lot in many cases.
Totally agree, for us, a heavily modified version of (what initially was) DBmirror
has made the job more than well.
Also, our replication is the most "fine-grained" situation i can think of.
(even rows being lazily replicated based on the FK dependency graph, and many other nice tricks)
-
Achilleas Mantzios
IT DEPT
From | Date | Subject | |
---|---|---|---|
Next Message | Albe Laurenz | 2012-06-19 10:34:02 | Re: Fine-grained replication? |
Previous Message | pandorino | 2012-06-19 10:11:04 | Re: pgstat wait timeout : permission denied |