Logo Questions Linux Laravel Mysql Ubuntu Git Menu
 

Does Postgres Replication (native) support per-database level replication?

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

like image 342
Emre He Avatar asked Oct 12 '13 07:10

Emre He


2 Answers

Built-in replication support only server to server replication. Third party replication systems can support replication on database level or table level - bucardo, slony, ..

like image 162
Pavel Stehule Avatar answered Nov 09 '22 08:11

Pavel Stehule


With postgres 10 some of the features of pglogical will be available, see https://blog.2ndquadrant.com/logical-replication-postgresql-10/ for more info.

like image 41
hugoShaka Avatar answered Nov 09 '22 08:11

hugoShaka