Re: 20160417105248.d20dcefed39b5d9031c6b28d@potentialtech.com - Mailing list pgsql-general

From Rob Sargent
Subject Re: 20160417105248.d20dcefed39b5d9031c6b28d@potentialtech.com
Date
Msg-id 2BB50FFC-1F26-4E46-B254-1864867D2421@gmail.com
Whole thread Raw
In response to 20160417105248.d20dcefed39b5d9031c6b28d@potentialtech.com  (Sergei Agalakov <Sergei.Agalakov@getmyle.com>)
List pgsql-general
> On Apr 17, 2016, at 12:41 PM, Sergei Agalakov <Sergei.Agalakov@getmyle.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
theyare supposed to differ if this is a migration point? 



pgsql-general by date:

Previous
From: Sergei Agalakov
Date:
Subject: 20160417105248.d20dcefed39b5d9031c6b28d@potentialtech.com
Next
From: Andrej Vanek
Date:
Subject: Re: pg_basebackup: return value 1: reason?