diff postgres dbs

ansh batra has asked for the wisdom of the Perl Monks concerning the following question:

hi monks

i want to diff two postgres databases and then sync them
can anyone suggest me any open source tool in perl for that

Comment on diff postgres dbs

Replies are listed 'Best First'.
Re: diff postgres dbs by Anonymous Monk on Nov 28, 2011 at 07:03 UTC
Isn't that a feature of postgres ? Simply use that feature :)	[reply]
Re: diff postgres dbs by TJPride (Pilgrim) on Nov 28, 2011 at 10:57 UTC
If one database is editable and the other read-only, there's a tool called slony: http://www.slony.info If both databases may be being edited, then things get far more complicated, and you'll need to write something custom to select records in one db that are missing from the other and add them. God only knows how you'd handle collisions.	[reply]