比较两个postgres转储文件 [英] Comparing two postgres dump files
问题描述
如何比较postgres转储文件?
我有两个转储文件,dump1和dump2。我想比较这两个转储文件。
How to compare postgres dump files? I have two dump files, dump1 and dump2 . And I want to compare these two dump files.
任何帮助将不胜感激。
谢谢
推荐答案
如果使用了Windows,则可以使用超越比较;如果使用了linux(fedora),则可以使用kompare;如果使用了linux,则可以使用kompare您可以使用 diff
,通讯-23 filedump1 fuledump2
, sort filedump1> filedump1.sorted
等是用于比较文件中文本的实用程序
fuledump2> fuledump2.sorted
差异filedump1.sorted fuledump2.sorted
You can use beyond compare if windows is been used and use kompare if linux(fedora) is been used also if linux is used than you can use different command like sdiff
example is provided in this link, other commands are diff
,comm -23 filedump1 fuledump2
,sort filedump1 > filedump1.sorted
sort fuledump2 > fuledump2.sorted
diff filedump1.sorted fuledump2.sorted
etc are utilities to compare text in files
这篇关于比较两个postgres转储文件的文章就介绍到这了,希望我们推荐的答案对大家有所帮助,也希望大家多多支持IT屋!