Received: from postgresql.org.org (webmail.postgresql.org [216.126.85.28]) by postgresql.org (8.11.3/8.11.1) with SMTP id f55JNUE58201 for ; Tue, 5 Jun 2001 15:23:30 -0400 (EDT) (envelope-from pgsql-sql-owner@postgresql.org) Received: from tangent.ics.olemiss.edu (tangent.ics.olemiss.edu [130.74.31.3]) by postgresql.org (8.11.3/8.11.1) with ESMTP id f4TMfOE26787 for ; Tue, 29 May 2001 18:41:24 -0400 (EDT) (envelope-from tswan-lst@ics.olemiss.edu) Received: from ics.olemiss.edu (d2interactive.sairinc.com [12.6.178.90]) by tangent.ics.olemiss.edu (8.9.3/8.8.7) with ESMTP id RAA04062; Tue, 29 May 2001 17:41:29 -0500 Message-ID: <3B14258F.60906@ics.olemiss.edu> Date: Tue, 29 May 2001 17:41:19 -0500 From: Thomas Swan User-Agent: Mozilla/5.0 (Windows; U; Win 9x 4.90; en-US; rv:0.9+) Gecko/20010529 X-Accept-Language: en-us MIME-Version: 1.0 To: "Diehl, Jeffrey" CC: pgsql-sql@postgresql.org Subject: Re: Upgd from 7.0 to 7.1 References: Content-Type: text/plain; charset=us-ascii; format=flowed Content-Transfer-Encoding: 7bit X-Archive-Number: 200106/43 X-Sequence-Number: 3250 Jeffrey: dump_all the old DB (with the current version of postgres running) stop the old postmaster copy that DB directory (ie /var/lib/pgsql) to an alternate location create a new directory for the location you want postgresql to run, (i.e. the old location) check the permissions on it... start the new version of postgresql... do the import (as postgres) ... I think that would be the best way to go about it. It's a lot easier than sorting out multiple postmasters, ports, etc... If everything goes well, you should be up and running. If not, you can restore the old directory and run the old backend... Hope this helps... Thomas Diehl, Jeffrey wrote: >I assume, then, that if I RTFM, I'll be able to figure out how to run two >db's at the same time... I guess I have to run them in different >directories? Or, do I do a dumpall, start the new server and do the >restore? Which is the best method? > >Thanx, >Mike Diehl, >Network Monitoring Tool Devl. >Sandia National Laboratories. >(505) 284-3137 >jdiehl@sandia.gov >