Received: from localhost (unknown [200.46.208.211])
	by mail.postgresql.org (Postfix) with ESMTP id A26846348B4
	for <pgsql-sql-postgresql.org@mail.postgresql.org>;
	Tue, 21 Jul 2009 13:55:46 -0300 (ADT)
Received: from mail.postgresql.org ([200.46.204.86])
	by localhost (mx1.hub.org [200.46.208.211]) (amavisd-maia, port 10024)
	with ESMTP id 29288-04-5 for
	<pgsql-sql-postgresql.org@mail.postgresql.org>;
	Tue, 21 Jul 2009 13:55:34 -0300 (ADT)
X-Greylist: from auto-whitelisted by SQLgrey-1.7.6
Received: from out01.mta.xmission.com (out01.mta.xmission.com [166.70.13.231])
	by mail.postgresql.org (Postfix) with ESMTP id 9054D63394C
	for <pgsql-sql@postgresql.org>; Tue, 21 Jul 2009 13:54:43 -0300 (ADT)
Received: from in01.mta.xmission.com ([166.70.13.51])
	by out01.mta.xmission.com with esmtp (Exim 4.62)
	(envelope-from <robjsargent@gmail.com>)
	id 1MTIcF-0008RP-6y; Tue, 21 Jul 2009 10:54:59 -0600
Received: from [208.187.158.94] (helo=[172.16.1.221])
	by in01.mta.xmission.com with esmtpsa (TLSv1:AES256-SHA:256)
	(Exim 4.69) (envelope-from <robjsargent@gmail.com>)
	id 1MTIbx-0003x7-QL; Tue, 21 Jul 2009 10:54:42 -0600
Message-ID: <4A65F2D7.8000901@gmail.com>
Date: Tue, 21 Jul 2009 10:54:47 -0600
From: Rob Sargent <robjsargent@gmail.com>
User-Agent: Thunderbird 2.0.0.22 (X11/20090608)
MIME-Version: 1.0
To: pgsql-sql@postgresql.org
References: <4A65EC7A.8010003@gmail.com> <15027.1248194992@sss.pgh.pa.us>
In-Reply-To: <15027.1248194992@sss.pgh.pa.us>
Content-Type: text/plain; charset=ISO-8859-1; format=flowed
Content-Transfer-Encoding: 7bit
X-XM-SPF: eid=; ; ; mid=; ; ; hst=in01.mta.xmission.com; ; ;
 ip=208.187.158.94;
	; ; frm=robjsargent@gmail.com; ; ; spf=neutral
X-SA-Exim-Connect-IP: 208.187.158.94
X-SA-Exim-Rcpt-To: pgsql-sql@postgresql.org, robjsargent@gmail.com
X-SA-Exim-Mail-From: robjsargent@gmail.com
X-Spam-DCC: XMission; sa03 1397; Body=1 Fuz1=1 Fuz2=1 
X-Spam-Combo: ;pgsql-sql@postgresql.org
X-Spam-Relay-Country: 
Subject: Re: Order of operations in ascii vs archive format (moderately
 urgent)
X-SA-Exim-Version: 4.2.1 (built Thu, 25 Oct 2007 00:26:12 +0000)
X-SA-Exim-Scanned: Yes (on in01.mta.xmission.com)
X-Virus-Scanned: Maia Mailguard 1.0.1
X-Spam-Status: No, hits=0.216 tagged_above=0 required=5 tests=AWL=0.216
X-Spam-Level: 
X-Archive-Number: 200907/93
X-Sequence-Number: 32834

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
>