Received: from localhost (maia-3.hub.org [200.46.204.184]) by postgresql.org (Postfix) with ESMTP id C1D089FB2E9 for ; Thu, 18 Jan 2007 10:17:44 -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 94338-09 for ; Thu, 18 Jan 2007 10:17:21 -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 D05099FB2E8 for ; Thu, 18 Jan 2007 10:17:32 -0400 (AST) Received: by locust.cns.vt.edu (Postfix, from userid 986) id 6D355118A37; Thu, 18 Jan 2007 09:17:31 -0500 (EST) Date: Thu, 18 Jan 2007 09:17:31 -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: <20070118141731.GA3382@cns.vt.edu> References: <20070117204155.41670.qmail@web34210.mail.mud.yahoo.com> <20070117211225.GA16479@cns.vt.edu> <20070117212751.GB16479@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/153 X-Sequence-Number: 24309 On Wed, Jan 17, 2007 at 01:31:50PM -0800, Jeff Frost wrote: Please, a couple of more questions about this upgrade process (never been through it, obviously). 1. I am backing up some of the config files that I know that I have touched: postgresql.conf, pg_hba.conf Are there other files down in there that I will need later that you tend to want to keep? 2. When you prepare to pg_dumpall using the new version, do you need to change all the path vars to point to the new install such as LD_LIBRARY_PATH and PATH, or does just an explicit call of the new pg_dumpall ok? Thanks.