Re: [GENERAL] replication setup: advice needed

2016-11-04 Thread Dmitry Karasik
> 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

Re: [GENERAL] replication setup: advice needed

2016-11-04 Thread Venkata B Nagothi
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-

[GENERAL] replication setup: advice needed

2016-11-03 Thread Dmitry Karasik
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

[GENERAL] Replication setup

2008-09-02 Thread Jason Long
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