Re: 20160417105248.d20dcefed39b5d9031c6b28d@potentialtech.com

From: Rob Sargent <robjsargent(at)gmail(dot)com>
To: Sergei Agalakov <Sergei(dot)Agalakov(at)getmyle(dot)com>
Cc: pgsql-general(at)postgresql(dot)org
Subject: Re: 20160417105248.d20dcefed39b5d9031c6b28d@potentialtech.com
Date: 2016-04-17 18:52:02
Message-ID: 2BB50FFC-1F26-4E46-B254-1864867D2421@gmail.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general


> On Apr 17, 2016, at 12:41 PM, Sergei Agalakov <Sergei(dot)Agalakov(at)getmyle(dot)com> wrote:
>
> I know about DBSteward. I don't like to bring PHP infrastructure only to be able to compare two dumps,
> and to deal with potential bugs in the third party tools. The pg_dump in other hand is always here, and is always trusted.
> SQLWorkbench/J also can compare two schemas, and requires only Java. Again, I trust pg_dump more.
> http://www.sql-workbench.net/
>
> May be pg_dump was never INTENDED to generate the dump files with the determined order of the statements,
> but it CAN do it with the minor changes, and be more useful to administrators. Why rely on the third party tools
> for the tasks that can be done with the native, trusted tools?
>
> Sergei
Does it matter if they differ if you cannot recreate the correct one exactly from source-controllled DDL? Or know how they are supposed to differ if this is a migration point?

In response to

Browse pgsql-general by date

  From Date Subject
Next Message Andrej Vanek 2016-04-17 19:13:08 Re: pg_basebackup: return value 1: reason?
Previous Message Sergei Agalakov 2016-04-17 18:41:15 20160417105248.d20dcefed39b5d9031c6b28d@potentialtech.com