Table Level Replication in Postgres using slony

Question

Is there any native table level replication(Pratial replication) in postgres?
If no, I want to replicate only some tables from my primary to standby using slony
Could anyone help me in doing this?
I am referring this link:"http://www.slony.info/documentation/1.2/firstdb.html"
But they are saying there will be a pgbench tool in contrib module in postgres
server.I am unable to find any, and my current server version is postgres-9.5.

Postgres 10 added native table level logical replication. – Dec 11 '17 at 20:55 — , Dec 11 '17 at 20:55
Thankyou @a_horse_with_no_name – Pavan Teja Dec 19 '17 at 12:47 — Pavan Teja, Dec 19 '17 at 12:47

score 0 · Answer 1 · answered Dec 11 '17 at 20:42

pgbench is a command in postgres that is included in the bin folder. If the DB doesn't exist you have skipped steps in the documentation link you provided.

createdb -O $PGBENCHUSER -h $MASTERHOST $MASTERDBNAME
createdb -O $PGBENCHUSER -h $SLAVEHOST $SLAVEDBNAME
pgbench -i -s 1 -U $PGBENCHUSER -h $MASTERHOST $MASTERDBNAME

I could not get this tutorial to fully work myself, but the tables were connected and replicated initially.

Table Level Replication in Postgres using slony

1 Answers1