Is it possible to do writable slave in postgresql master-slave replication model?
Db contains just one unindexed table.
I managed to achieve it with BDR master-master replication, but it eventually tables become locked to writes, both master and slave, for some reason, so I was forced to remove it and try something else.
Im looking to Slony and burcado now, but not sure from docs that I can get writable slave.
since version 10 there is logical replication in postgresql, so I used it
added this answer just to stop SO bugging me of unaccepted answer. Adina's answer unfortunately can't be it at all.