Re: Database schema diff

From: Michal Novotny <michal(dot)novotny(at)trustport(dot)com>
To: Иван Фролков <ifrol2001(at)mail(dot)ru>
Cc: <pgsql-hackers(at)postgresql(dot)org>
Subject: Re: Database schema diff
Date: 2015-10-14 13:12:44
Message-ID: 561E54CC.3000606@trustport.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-hackers

Hi,

thanks a lot for your reply, unfortunately it's not working at all, I
run it as:

# java -jar apgdiff-2.4.jar <old-dump-from-pg_dump> <new-dump-from-pg_dump>

But it's stuck on the futex wait so unfortunately it didn't work at all.

Thanks for the reply anyway,
Michal

On 10/14/2015 01:53 PM, Иван Фролков wrote:
>> I would like to ask you whether is there any tool to be able to compare
>> database schemas ideally no matter what the column order is or to dump
>> database table with ascending order of all database columns.
>
> Take a look a tool called apgdiff http://apgdiff.com/
> Its development seems suspended, but it is still useful tool, except cases with new features etc.
> Anyway, you could find bunch of forks at the github - I did support for instead of triggers, other people did another options and so on
>
>

In response to

Browse pgsql-hackers by date

  From Date Subject
Next Message Amir Rohan 2015-10-14 13:17:55 Re: Proposal: pg_confcheck - syntactic & semantic validation of postgresql configuration files
Previous Message Shulgin, Oleksandr 2015-10-14 12:47:46 Re: Patch: Implement failover on libpq connect level.