Re: Fine-grained replication?

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

In response to

Browse pgsql-general by date

  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