CODEWITHSUNDEEP
databasepostgresql
Chan Pye
Chan Pye

Reputation: 1391

database synchronization tool for PostgreSQL

I have two PostgreSQL databases, one is for development and the other is for deployment.

Now, I want to synchronize those databases, any tool should I use?

Upvotes: 1

Views: 2190

Answers (2)

Ferran
Ferran

Reputation: 15013

If you don't need to keep databases in sync, you can use pg_dump and psql to get a dump of the production database and load it to the development database.

Upvotes: 1

user747858
user747858

Reputation:

You can try this tool

Commercial:

http://www.sqlmanager.net/en/products/postgresql/dbcomparer

Freeware: http://www.top4download.com/-1-postgresql-tool-navicat-postgresql-lite-freeware-/spoyoiqt.html

Upvotes: 2

Related Questions