From pginfo@ionsol.com.au Tue Mar 27 13:03:51 2001 Received: from localhost.localdomain (191.cur0102.cur.iprimus.net.au [203.134.96.191]) by mail.postgresql.org (8.11.3/8.11.1) with ESMTP id f2RD3ow88113 for ; Tue, 27 Mar 2001 08:03:51 -0500 (EST) (envelope-from pginfo@ionsol.com.au) Received: from Win98 ([192.168.0.2]) by localhost.localdomain (8.9.3/8.9.3) with SMTP id XAA19690 for ; Tue, 27 Mar 2001 23:11:19 +1000 Message-ID: <00e501c0b6bf$7494ee20$0200a8c0@Win98> From: "Sean Weissensee" To: Subject: Upgrading from 6.2 to 7 Date: Tue, 27 Mar 2001 23:10:42 +1000 MIME-Version: 1.0 Content-Type: multipart/alternative; boundary="----=_NextPart_000_00DA_01C0B713.257BB5E0" X-Priority: 3 X-MSMail-Priority: Normal X-Mailer: Microsoft Outlook Express 5.50.4522.1200 X-MimeOLE: Produced By Microsoft MimeOLE V5.50.4522.1200 X-Archive-Number: 200103/549 X-Sequence-Number: 2219 This is a multi-part message in MIME format. ------=_NextPart_000_00DA_01C0B713.257BB5E0 Content-Type: text/plain; charset="iso-8859-1" Content-Transfer-Encoding: quoted-printable We are planing to upgrade to version 7 of Postgres, I understand that you cannot use version 6 databases with 7. Where can I find information on how to convert these Databases ? Sean Ion Solutions ------=_NextPart_000_00DA_01C0B713.257BB5E0 Content-Type: text/html; charset="iso-8859-1" Content-Transfer-Encoding: quoted-printable
We are planing to upgrade to version 7 of=20 Postgres,
I understand that you cannot use version 6 databases wi= th=20 7.
 Where can I find information on how to convert th= ese=20 Databases ?
 
Sean
 
Ion Solutions
------=_NextPart_000_00DA_01C0B713.257BB5E0-- From tgl@sss.pgh.pa.us Tue Mar 27 15:24:25 2001 Received: from sss.pgh.pa.us (sss.pgh.pa.us [209.114.132.154]) by mail.postgresql.org (8.11.3/8.11.1) with ESMTP id f2RFOPw15872 for ; Tue, 27 Mar 2001 10:24:25 -0500 (EST) (envelope-from tgl@sss.pgh.pa.us) Received: from sss2.sss.pgh.pa.us (tgl@localhost [127.0.0.1]) by sss.pgh.pa.us (8.11.3/8.11.3) with ESMTP id f2RFOHw05305; Tue, 27 Mar 2001 10:24:17 -0500 (EST) To: "Sean Weissensee" cc: pgsql-sql@postgresql.org Subject: Re: Upgrading from 6.2 to 7 In-reply-to: <00e501c0b6bf$7494ee20$0200a8c0@Win98> References: <00e501c0b6bf$7494ee20$0200a8c0@Win98> Comments: In-reply-to "Sean Weissensee" message dated "Tue, 27 Mar 2001 23:10:42 +1000" Date: Tue, 27 Mar 2001 10:24:16 -0500 Message-ID: <5302.985706656@sss.pgh.pa.us> From: Tom Lane X-Archive-Number: 200103/551 X-Sequence-Number: 2221 "Sean Weissensee" writes: > We are planing to upgrade to version 7 of Postgres, > I understand that you cannot use version 6 databases with 7. > Where can I find information on how to convert these Databases ? Short version: pg_dumpall (with old version), initdb, reload. Long version: Great Bridge's docs explain upgrading in excruciating detail ;-). You can download PDFs for free from http://www.greatbridge.com/docs/ regards, tom lane