X-Original-To: pgsql-admin-postgresql.org@localhost.postgresql.org Received: from localhost (mx1.hub.org [200.46.208.251]) by postgresql.org (Postfix) with ESMTP id 7E05E9FA2FD for ; Mon, 5 Jun 2006 13:00:31 -0300 (ADT) Received: from postgresql.org ([200.46.204.71]) by localhost (mx1.hub.org [200.46.208.251]) (amavisd-new, port 10024) with ESMTP id 34326-08 for ; Mon, 5 Jun 2006 13:00:22 -0300 (ADT) X-Greylist: from auto-whitelisted by SQLgrey- Received: from wolff.to (wolff.to [66.93.197.194]) by postgresql.org (Postfix) with SMTP id B60299F9316 for ; Mon, 5 Jun 2006 13:00:21 -0300 (ADT) Received: (qmail 13572 invoked by uid 500); 5 Jun 2006 16:03:09 -0000 Date: Mon, 5 Jun 2006 11:03:09 -0500 From: Bruno Wolff III To: Jeroen Kransen Cc: pgsql-admin@postgresql.org Subject: Re: restoring data tree from old 7.3 database Message-ID: <20060605160309.GA13332@wolff.to> Mail-Followup-To: Bruno Wolff III , Jeroen Kransen , pgsql-admin@postgresql.org References: <20060604113152.31068.qmail@web31010.mail.mud.yahoo.com> Mime-Version: 1.0 Content-Type: text/plain; charset=us-ascii Content-Disposition: inline In-Reply-To: <20060604113152.31068.qmail@web31010.mail.mud.yahoo.com> User-Agent: Mutt/1.4.2.1i X-Virus-Scanned: Maia Mailguard 1.0.1 X-Archive-Number: 200606/16 X-Sequence-Number: 21978 On Sun, Jun 04, 2006 at 04:31:52 -0700, Jeroen Kransen wrote: > Is there a way to restore an old Postgresql 7.3 database using an 8.0 server? When I use the 7.3 data directory on 8.0, it gives an error that it's not compatible, not to my surprise. I could install an old PostgreSQL 7.3 somewhere, read the databases there and make a real pg_dump, but I was wondering if there's an easier way. If only because I don't know where to find a 7.3 installation :) Not from the data directory. The source and various binaries for 7.3 are still available on the PostgreSQL web site.