Does Postgres Replication mechanimsm native support per-database level replication? I mean if we have db1, db2, db3 in one Postgresq Process, could I configure to control Postgres only replicate db1 data to standby Postgresq?
thanks, Emre
Built-in replication support only server to server replication. Third party replication systems can support replication on database level or table level - bucardo, slony, ..
With postgres 10 some of the features of pglogical will be available, see https://blog.2ndquadrant.com/logical-replication-postgresql-10/ for more info.
If you love us? You can donate to us via Paypal or buy me a coffee so we can maintain and grow! Thank you!
Donate Us With