Received: from localhost (unknown [200.46.204.183]) by postgresql.org (Postfix) with ESMTP id 248DE2E0061 for ; Tue, 19 Feb 2008 15:49:00 -0400 (AST) Received: from postgresql.org ([200.46.204.71]) by localhost (mx1.hub.org [200.46.204.183]) (amavisd-maia, port 10024) with ESMTP id 62941-01-2 for ; Tue, 19 Feb 2008 15:48:57 -0400 (AST) Received: from main2.mycybernet.net (main2.mycybernet.net [209.222.63.140]) by postgresql.org (Postfix) with ESMTP id BDA872E004D for ; Tue, 19 Feb 2008 15:47:45 -0400 (AST) Received: from 227-54-222-209.mycybernet.net ([209.222.54.227] helo=crankycanuck.ca) by main2.mycybernet.net with esmtp (Exim 4.62) (envelope-from ) id 1JRYRN-0002Rr-20 for pgsql-admin@postgresql.org; Tue, 19 Feb 2008 14:47:45 -0500 Received: by crankycanuck.ca (Postfix, from userid 1000) id A282F50023; Tue, 19 Feb 2008 14:47:40 -0500 (EST) Date: Tue, 19 Feb 2008 14:47:40 -0500 From: Andrew Sullivan To: pgsql-admin@postgresql.org Subject: Re: why use -Ft or -Fc instead of the other on pg_dump? Message-ID: <20080219194740.GC6148@crankycanuck.ca> Mail-Followup-To: Andrew Sullivan , pgsql-admin@postgresql.org References: <200802191259.55682.doug@hunley.homeip.net> MIME-Version: 1.0 Content-Type: text/plain; charset=us-ascii Content-Disposition: inline In-Reply-To: <200802191259.55682.doug@hunley.homeip.net> User-Agent: Mutt/1.5.13 (2006-08-11) X-Virus-Scanned: Maia Mailguard 1.0.1 X-Archive-Number: 200802/214 X-Sequence-Number: 28288 On Tue, Feb 19, 2008 at 12:59:55PM -0500, Douglas J Hunley wrote: > I seemed to have walked into a "spirited" debate at work today, so I'm turning > to the authorities to get it resolved. Why would one choose -Ft over -Fc (or > vice-versa) when doing pg_dump? Is there truly any difference of note > (outside the formats themselves)? My rule is "never use -Ft". I've tripped over various bugs over the years. Indeed, I just had another example of one (from 7.4, mind) the other day. A