X-Original-To: pgsql-general-postgresql.org@localhost.postgresql.org Received: from localhost (unknown [200.46.204.144]) by svr1.postgresql.org (Postfix) with ESMTP id 53DA1557F9 for ; Fri, 25 Feb 2005 17:20:15 +0000 (GMT) Received: from svr1.postgresql.org ([200.46.204.71]) by localhost (av.hub.org [200.46.204.144]) (amavisd-new, port 10024) with ESMTP id 97039-10 for ; Fri, 25 Feb 2005 17:20:05 +0000 (GMT) Received: from rproxy.gmail.com (rproxy.gmail.com [64.233.170.197]) by svr1.postgresql.org (Postfix) with ESMTP id 82B4552A85 for ; Fri, 25 Feb 2005 17:20:04 +0000 (GMT) Received: by rproxy.gmail.com with SMTP id a41so538872rng for ; Fri, 25 Feb 2005 09:20:24 -0800 (PST) DomainKey-Signature: a=rsa-sha1; q=dns; c=nofws; s=beta; d=gmail.com; h=received:message-id:date:from:reply-to:to:subject:cc:in-reply-to:mime-version:content-type:content-transfer-encoding:references; b=uUeBaj+DI3HvZhDOnRMfKkYL8+1efPV+Dwu0XBZksaHL/He7zZsv34eNRoma/gKfBguub8JT7YU1r6En6JBM2iDE2Mh26G1jYKaKb3sO019mgq58+Xo6Fe8C4m7kn7WaLsze6FLzkHmrX1kCz0/6PAjVJ2RyIyjB0OQe/KcU43w= Received: by 10.38.90.51 with SMTP id n51mr348108rnb; Fri, 25 Feb 2005 09:20:23 -0800 (PST) Received: by 10.38.149.54 with HTTP; Fri, 25 Feb 2005 09:20:23 -0800 (PST) Message-ID: <7c1574a905022509204c85ce21@mail.gmail.com> Date: Fri, 25 Feb 2005 09:20:23 -0800 From: Lonni J Friedman Reply-To: Lonni J Friedman To: schen@graciousstyle.com Subject: Re: postgresql 8.0 advantages Cc: pgsql-general@postgresql.org In-Reply-To: <421F5E5D.1010902@graciousstyle.com> Mime-Version: 1.0 Content-Type: text/plain; charset=US-ASCII Content-Transfer-Encoding: 7bit References: <421F3926.6090201@graciousstyle.com> <5708.1109348115@sss.pgh.pa.us> <421F5E5D.1010902@graciousstyle.com> X-Virus-Scanned: by amavisd-new at hub.org X-Spam-Status: No, hits=0.056 tagged_above=0 required=5 tests=AWL, RCVD_BY_IP X-Spam-Level: X-Archive-Number: 200502/1359 X-Sequence-Number: 74163 On Fri, 25 Feb 2005 09:20:29 -0800, Si Chen wrote: > Thanks! > > Is there any documentation on how to upgrade to 8.0? Dump your DB, install 8.0, reload your DB. Since you'e using RHEL3, you should use the RPMs and it will be fairly easy. > Is it possible to upgrade from 7.4 to 8.0 while keeping a production > database running "in place"? Or should I install 8.0 in another No, its not. > directory/machine and then restore the database into it? Are there any > incompatibilities/modifications to databases from the earlier veresion > required? Depends on what kind of data structures you have in the DB -- ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~ L. Friedman netllama@gmail.com LlamaLand http://netllama.linux-sxs.org