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