CODEWITHSUNDEEP
postgresqlduplication
Vitaly Isaev
Vitaly Isaev

Reputation: 5815

PostgreSQL: on-the-fly duplication of the database on the same server

We are using the same PostgreSQL 9.3 Server both for production and development.

So we would like to get the copy of the existing production database for the development purposes. To be precise, all the INSERT/UPDATE/DELETE events that come to production should be also placed into its copy. Reverse replication is not needed. How can we do that?

PS: Please take into account that full master-slave replication is not suitable. We have no opportunity to deploy one more PostgreSQL server at the moment.

UPD: pg_dump/pg_restore is not the case too, because this will crash all the updates done by developers in their database.

Upvotes: 1

Views: 665

Answers (1)

Wolph
Wolph

Reputation: 80061

Sounds like you are looking for a replication system like Slony or Bucardo

Slony uses triggers to replicate the data so that should work without much hassle here. And Bucardo uses NOTIFY to do pretty much the same.

For just a local setup I would recommend Slony but if you would like to offer the developers a local database (i.e. local machine) I would recommend Bucardo instead as it offers asynchronous replication.

Upvotes: 1

Related Questions