Received: from localhost (maia-3.hub.org [200.46.204.184]) by postgresql.org (Postfix) with ESMTP id 349B99FB1C6 for ; Wed, 17 Jan 2007 17:28:20 -0400 (AST) Received: from postgresql.org ([200.46.204.71]) by localhost (mx1.hub.org [200.46.204.184]) (amavisd-new, port 10024) with ESMTP id 27499-10 for ; Wed, 17 Jan 2007 17:27:53 -0400 (AST) X-Greylist: from auto-whitelisted by SQLgrey-1.7.4 Received: from locust.cns.vt.edu (locust.cns.vt.edu [198.82.169.14]) by postgresql.org (Postfix) with ESMTP id 11AAA9FB2AD for ; Wed, 17 Jan 2007 17:27:52 -0400 (AST) Received: by locust.cns.vt.edu (Postfix, from userid 986) id 74AF6118A30; Wed, 17 Jan 2007 16:27:51 -0500 (EST) Date: Wed, 17 Jan 2007 16:27:51 -0500 From: Ray Stell To: Jeff Frost Cc: Andrew Edson , pgsql-admin@postgresql.org Subject: Re: Upgrade/Installation problem: Version 7.4.9 to version Message-ID: <20070117212751.GB16479@cns.vt.edu> References: <20070117204155.41670.qmail@web34210.mail.mud.yahoo.com> <20070117211225.GA16479@cns.vt.edu> Mime-Version: 1.0 Content-Type: text/plain; charset=us-ascii Content-Disposition: inline In-Reply-To: User-Agent: Mutt/1.5.11 X-Virus-Scanned: Maia Mailguard 1.0.1 X-Archive-Number: 200701/144 X-Sequence-Number: 24300 On Wed, Jan 17, 2007 at 01:18:06PM -0800, Jeff Frost wrote: > On Wed, 17 Jan 2007, Ray Stell wrote: > >Why is there pg_dumpall instead of a pg_dump with some flag? > > pg_dumpall does all DBs plus the globals, but I'll have to let one of the > developers answer why there isn't just a flag for pg_dump. Thanks. If I've done a pg_dumpall does some of the sql that gets included fail in the restore because the objects already exist via the documented initdb? That is how it works with oracle, you export, install a db, then import, but the import throws errors because of the installe objects already exist.