database synchronization tool for PostgreSQL

Question

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?

user747858 · Accepted Answer · 2011-07-26 11:05:44Z

2

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

answered Jul 26, 2011 at 11:05

user747858

Sign up to request clarification or add additional context in comments.

1 Comment

Chan Pye Over a year ago

Navicat Posgresql Lite is so cute, but it does'n support synchronization, so I use Navicat for PostgreSQL (commercial version). Anyway, thanks for your answer

Ferran · Accepted Answer · 2011-07-26 11:10:07Z

1

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.

answered Jul 26, 2011 at 11:10

Ferran

15.1k2 gold badges24 silver badges12 bronze badges

Collectives™ on Stack Overflow

database synchronization tool for PostgreSQL

2 Answers 2

1 Comment

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

2 Answers 2

1 Comment

Comments

Your Answer

Sign up or log in

Post as a guest

Related