Re: Fine-grained replication? - Mailing list pgsql-general

From Guillaume Lelarge
Subject Re: Fine-grained replication?
Date
Msg-id f616dc98b6f8d86fa1eb16d0e56ce515@localhost
Whole thread Raw
In response to Fine-grained replication?  (Paul Jones <pbj@cmicdo.com>)
Responses Re: Fine-grained replication?
List pgsql-general
On Mon, 18 Jun 2012 14:49:32 -0700 (PDT), Paul Jones <pbj@cmicdo.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.


--
Guillaume
 http://www.postgresql.fr
 http://dalibo.com

pgsql-general by date:

Previous
From: Evan Martin
Date:
Subject: Please make it easy to drop a database that is in use
Next
From: pandorino
Date:
Subject: Re: pgstat wait timeout : permission denied