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@xxxxxxxxxxxxxx) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-general
