Postgresql create pg_dump for schema upgrade

Question

i have two postgres databases on different servers. Both have a 'public schema' with the same tables inside. One of them is used for developing and I am creating new tables of new columns inside some tables. How can i pg_dump the developing DB structure in order to get a sql that i run on the second DB to create the missing columns / tables (and constraints if possible)

So you want a dump as a diff, so it would only change the columns and other items that have changed? For that you need a third party library, for which you might get suggestions at softwarerecs.stackexchange.com — Sami Kuhmonen
– Sami Kuhmonen, Commented May 15, 2015 at 15:10

Community · Accepted Answer · 2017-05-23 12:02:49Z

0

I doubt if it's possible with pg_dump.

However, you can use Liquibase. It's a database versioning tool which also allow to generate diff of given two databases.

Have a look at:

edited May 23, 2017 at 12:02

CommunityBot

11 silver badge

answered May 15, 2015 at 15:46

Radek Postołowicz

4,8742 gold badges32 silver badges52 bronze badges

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

Comments

erroia · Accepted Answer · 2017-05-22 22:41:21Z

0

For this case exist few tool with same functional

http://pgdiff.sourceforge.net/

https://github.com/fordfrog/apgdiff

this is utilities full cover you requirements

and you can use this for make you own tool

pg-diff - python tool to diff to schemas https://github.com/brendonh/schemup

answered May 22, 2017 at 22:41

erroia

3783 silver badges10 bronze badges

Collectives™ on Stack Overflow

Postgresql create pg_dump for schema upgrade

2 Answers 2

Comments

Comments

Your Answer

Linked

Hot Network Questions

Collectives™ on Stack Overflow

2 Answers 2

Comments

Comments

Your Answer

Sign up or log in

Post as a guest

Linked

Related