Received: from localhost (maia-3.hub.org [200.46.204.184]) by postgresql.org (Postfix) with ESMTP id 893F49FB22A for ; Wed, 17 Jan 2007 17:12:48 -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 26004-07 for ; Wed, 17 Jan 2007 17:12:23 -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 1C57B9FB223 for ; Wed, 17 Jan 2007 17:12:26 -0400 (AST) Received: by locust.cns.vt.edu (Postfix, from userid 986) id 150AD118A2E; Wed, 17 Jan 2007 16:12:25 -0500 (EST) Date: Wed, 17 Jan 2007 16:12:25 -0500 From: Ray Stell To: Andrew Edson Cc: Jeff Frost , pgsql-admin@postgresql.org Subject: Re: Upgrade/Installation problem: Version 7.4.9 to version Message-ID: <20070117211225.GA16479@cns.vt.edu> References: <20070117204155.41670.qmail@web34210.mail.mud.yahoo.com> Mime-Version: 1.0 Content-Type: text/plain; charset=us-ascii Content-Disposition: inline In-Reply-To: <20070117204155.41670.qmail@web34210.mail.mud.yahoo.com> User-Agent: Mutt/1.5.11 X-Virus-Scanned: Maia Mailguard 1.0.1 X-Archive-Number: 200701/141 X-Sequence-Number: 24297 1. Curious about the difference in step 6 of this list, uses pg_restore, and what is listed in the doc: http://www.postgresql.org/docs/8.2/interactive/install-upgrading.html which says to restore via: psql -d postgres -f outputfile Is this use of psql related to the fact that a pg_dumpall was the starting place instead of pg_dump as is used in this list of steps? Can you use psql -f to restore a backup via pg_dump? 2. Also, I found myself wondering: pg_dump -> pg_restore pg_dumpall -> ? I would have expected a pg_restoreall. Also, I would expect such a pg_restoreall to do the initdb step in the process of restoring "all." Why is there pg_dumpall instead of a pg_dump with some flag? On Wed, Jan 17, 2007 at 12:41:55PM -0800, Andrew Edson wrote: > Please clear something up for me. The database I'm trying to upgrade was/is empty; only the original installation was present, no tables. Exactly what is it I'm supposed to be dumping? If you mean making a copy of the original 8.1.3, that I've done before, but I'm unclear as to the meaning of what you're saying at the moment. Please enlighten me. > > Jeff Frost wrote: Andrew, > > If you're moving between major versions, a dump/restore is necessary. The > proper procedure is: > > 1) pg_dump the old database by using the new version of pg_dump (8.1.x) > against the old db server (7.4.9 in your case) > 2) stop the old database server (and possibly move/rename the old data dir) > 3) initdb the new database server > 4) edit postgresql.conf, etc > 5) start the new database server > 6) pg_restore the old database into the newly initialized data directory > > So, it sounds like you'll need to reinstall 7.4 and bring it back up, then use > the 8.1.3 pg_dump to create a dump, then restore that into the new 8.1 server. > > > --------------------------------- > It's here! Your new message! > Get new email alerts with the free Yahoo! Toolbar. -- You have no chance to survive make your time.