Import updated version of database in Postgres

Question

So I have this PostgreSQL database which I dumped and copied to another server. On that new server I updated rows and also added tables.

Now I would like to "sync" the new one over the old so that they both have the same state again - is that possible?

Thanks in advance

It's going to be difficult.

Peter Eisentraut
– Peter Eisentraut

11/19/2013 16:31:41
Commented Nov 19, 2013 at 16:31 — Peter Eisentraut
– Peter Eisentraut, Commented Nov 19, 2013 at 16:31

frlan · Accepted Answer · 2013-11-19 16:55:15Z

1

Most likely you will need to have a dump created on your machine2 and import it back into machine1. There is a tool pgdiff available, which maybe helps you to find differences, but to be fair I never tried it.

answered Nov 19, 2013 at 16:55

frlan

7,2953 gold badges35 silver badges72 bronze badges

Add a comment |

Collectives™ on Stack Overflow

Import updated version of database in Postgres

1 Answer 1

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

Your Answer

Sign up or log in

Post as a guest

Related