Received: from localhost (maia-5.hub.org [200.46.204.182]) by postgresql.org (Postfix) with ESMTP id 12F429FB259 for ; Sun, 24 Jun 2007 17:32:26 -0300 (ADT) Received: from postgresql.org ([200.46.204.71]) by localhost (mx1.hub.org [200.46.204.182]) (amavisd-maia, port 10024) with ESMTP id 13572-08 for ; Sun, 24 Jun 2007 17:32:11 -0300 (ADT) X-Greylist: delayed 00:25:07.220463 by SQLgrey-1.7.5 Received: from svr4.postgresql.org (svr4.postgresql.org [66.98.251.159]) by postgresql.org (Postfix) with ESMTP id B20F59FB3A6 for ; Sun, 24 Jun 2007 17:32:19 -0300 (ADT) X-Greylist: domain auto-whitelisted by SQLgrey-1.7.3 Received: from twobarks.com (ns104.twobarks.com [91.189.120.202]) by svr4.postgresql.org (Postfix) with ESMTP id 8DA015AF883 for ; Sun, 24 Jun 2007 20:07:11 +0000 (GMT) Received: from localhost (localhost.localdomain [127.0.0.1]) by twobarks.com (Postfix) with ESMTP id 43C7F564165; Sun, 24 Jun 2007 22:07:03 +0200 (CEST) X-Virus-Scanned: Virus gateway at Twobarks Received: from twobarks.com ([127.0.0.1]) by localhost (ns104.twobarks.com [127.0.0.1]) (amavisd-new, port 10024) with ESMTP id H0yA3FGo5Ibr; Sun, 24 Jun 2007 22:07:03 +0200 (CEST) Received: from [10.0.0.12] (cC2A55AC1.dhcp.bluecom.no [193.90.165.194]) by twobarks.com (Postfix) with ESMTP id 96651564152; Sun, 24 Jun 2007 22:07:02 +0200 (CEST) Message-ID: <467ECEE2.9070701@usit.uio.no> Date: Sun, 24 Jun 2007 22:06:58 +0200 From: Tommy Gildseth User-Agent: Thunderbird 1.5.0.10 (Windows/20070221) MIME-Version: 1.0 To: "Campbell, Lance" Cc: pgsql-admin@postgresql.org Subject: Re: Load DB - Conversion from 8.1.4 to 8.2.4 References: In-Reply-To: Content-Type: text/plain; charset=windows-1252; format=flowed Content-Transfer-Encoding: 8bit X-Virus-Scanned: Maia Mailguard 1.0.1 X-Spam-Status: No, hits=0.001 tagged_above=0 required=5 tests=BAYES_50=0.001 X-Spam-Level: X-Archive-Number: 200706/254 X-Sequence-Number: 25922 Campbell, Lance wrote: > > I will be converting from PostgreSQL 8.1.4 to 8.2.4. Is it OK to do > the following command in order to load the new database after install? > > pg_dump -h /host1/ –p 1234 /dbname/ | psql -h /host1 –p 56789/ /dbname/// > > Remember that port 1234 is PostgreSQL 8.1.4 and port 5678 is > PostgreSQL 8.2.4. > Should be fine, as long as you ensure that the pg_dump you use, is the one from your 8.2.4 installation, and not the 8.1.4 version. -- Tommy Gildseth DBA, Gruppe for databasedrift Universitetet i Oslo, USIT m: +47 45 86 38 50 t: +47 22 85 29 39