> You need to look at a replication solution like Slony, which is a trigger
> based replication solution. If you are using PostgreSQL version 9.4 or
> higher, then, you can explore "pglogical" which is WAL based and uses
> logical decoding capability.
I'm using 9.4, and I'm looking at pglogical as
On Thu, Nov 3, 2016 at 8:17 PM, Dmitry Karasik
wrote:
> Dear all,
>
> I'd like to ask for help or advice with choosing the best replication
> setup for
> my task.
>
> I need to listen to continuous inserts/deletes/updates over a set of
> tables,
> and serve them over http, so I would like to off-
Dear all,
I'd like to ask for help or advice with choosing the best replication setup for
my task.
I need to listen to continuous inserts/deletes/updates over a set of tables,
and serve them over http, so I would like to off-load this procedure to a
separate slave machine. I thought that logical
I have a custom inventory system built on JBoss AS, Seam, EJB3, JSF, and
Richfaces with a PostgreSQL back end that runs on Centos.
Being a single developer my time is short and I need to set up remote
replication and fail over without delaying what I am currently working on.
I have been readin