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 master-slave replication could
be the best match here, but I couldn't find enough details in the documentation
which implementation would match my needs best.

Basically, I need to:

a) replicate selected tables to a hot standby slave
b) on the slave, listen for the insert/update/delete events (either through 
triggers or logical decoder plugin)

While I see that a) should be feasible, I can't see if it's possible to do b) 
at all.
Also, with so many replication solutions, I don't want to test them all one by 
one, but
rather would like to ask for help choosing the one goes best here -- and if 
there's none,
an alternative setup then.

-- 
Sincerely,
        Dmitry Karasik



-- 
Sent via pgsql-general mailing list (pgsql-general@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-general

Reply via email to