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

From Rob Sargent
Subject Re: Order of operations in ascii vs archive format (moderately urgent)
Date
Msg-id 4A65F2D7.8000901@gmail.com
Whole thread Raw
In response to Re: Order of operations in ascii vs archive format (moderately urgent)  (Tom Lane <tgl@sss.pgh.pa.us>)
List pgsql-sql
Wonderful news.

I just ran dump and restore against same production server.  Constraints 
and the absence of drop <object> calls appears to have saved my butt. 


Tom Lane wrote:
> 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 is
>     pg_dump >textfile
>     pg_dump -Fc >dumpfile
>     pg_restore dumpfile >textfile2
>     diff textfile textfile2
> If these don't produce the same results something is broken.
>
>             regards, tom lane
>   


pgsql-sql by date:

Previous
From: Tom Lane
Date:
Subject: Re: 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)