Received: from localhost (unknown [200.46.204.184]) by postgresql.org (Postfix) with ESMTP id D56412E00CE for ; Thu, 21 Feb 2008 15:52:41 -0400 (AST) Received: from postgresql.org ([200.46.204.71]) by localhost (mx1.hub.org [200.46.204.184]) (amavisd-maia, port 10024) with ESMTP id 29638-02 for ; Thu, 21 Feb 2008 15:52:32 -0400 (AST) Received: from sss.pgh.pa.us (sss.pgh.pa.us [66.207.139.130]) by postgresql.org (Postfix) with ESMTP id 019C62E00DD for ; Thu, 21 Feb 2008 15:50:08 -0400 (AST) Received: from sss2.sss.pgh.pa.us (tgl@localhost [127.0.0.1]) by sss.pgh.pa.us (8.14.2/8.14.2) with ESMTP id m1LJo7Gi014925; Thu, 21 Feb 2008 14:50:07 -0500 (EST) To: Ray Stell cc: pgsql-admin@postgresql.org Subject: Re: pg_dump --clean or dropdb? In-reply-to: <20080221183939.GA31300@cns.vt.edu> References: <20080221183939.GA31300@cns.vt.edu> Comments: In-reply-to Ray Stell message dated "Thu, 21 Feb 2008 13:39:39 -0500" Date: Thu, 21 Feb 2008 14:50:07 -0500 Message-ID: <14924.1203623407@sss.pgh.pa.us> From: Tom Lane X-Virus-Scanned: Maia Mailguard 1.0.1 X-Archive-Number: 200802/247 X-Sequence-Number: 28321 Ray Stell writes: > The doc for pg_dump --clean says it will drop db objects, not the db, > however it looks like it does, though the output order of events is > troubling. Is there a loop in the create/drop area?. "strings" is not the way to find out what will be emitted by pg_restore. (Hint: there are commands in the dump archive that may or may not be used by pg_restore.) Use a plain pg_dump command, or equivalently look at pg_restore's output script. regards, tom lane