Postgres Pro
Downloads
Home   >   mailing lists

Re: Order of operations in ascii vs archive format (moderately urgent) - Mailing list pgsql-sql

From Tom Lane
Subject Re: Order of operations in ascii vs archive format (moderately urgent)
Date
Msg-id 15027.1248194992@sss.pgh.pa.us
Whole thread Raw
In response to Order of operations in ascii vs archive format (moderately urgent)  (Rob Sargent <robjsargent@gmail.com>)
Responses Re: Order of operations in ascii vs archive format (moderately urgent)
Re: Order of operations in ascii vs archive format (moderately urgent)
List pgsql-sql
Tree view 
Rob Sargent <robjsargent@gmail.com> writes:
> Is there a difference in the order of execution between an ascii dump 
> and one using the "custom" format?  Or any difference in the general 
> operation? 

There's not supposed to be.  One standard test on the pg_dump code ispg_dump >textfilepg_dump -Fc >dumpfilepg_restore
dumpfile>textfile2diff textfile textfile2
 
If these don't produce the same results something is broken.
        regards, tom lane

pgsql-sql by date:

Previous
From: Rob Sargent
Date:
Subject: Order of operations in ascii vs archive format (moderately urgent)
Next
From: Rob Sargent
Date:
Subject: Re: Order of operations in ascii vs archive format (moderately urgent)