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 C5A499FA43C for ; Sun, 4 Jun 2006 08:32:01 -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 03035-03 for ; Sun, 4 Jun 2006 08:31:53 -0300 (ADT) X-Greylist: domain auto-whitelisted by SQLgrey- Received: from web31010.mail.mud.yahoo.com (web31010.mail.mud.yahoo.com [68.142.200.173]) by postgresql.org (Postfix) with SMTP id D2F529F9DB0 for ; Sun, 4 Jun 2006 08:31:53 -0300 (ADT) Received: (qmail 31070 invoked by uid 60001); 4 Jun 2006 11:31:52 -0000 DomainKey-Signature: a=rsa-sha1; q=dns; c=nofws; s=s1024; d=yahoo.com; h=Message-ID:Received:Date:From:Subject:To:MIME-Version:Content-Type:Content-Transfer-Encoding; b=EA9vLyCAiLwkskyqrsKNehoTYFLygtWRe+zl9VTESt2HNo8wxCKhQ+R/ooNne+M3SCFItQVHhPwZfCrmg/eoAkE0/XP+248K0ifjmVBNN60sjNcrDhrP2QBCsT0r8qDa79qUkQSvuDyuzoF2o35Nh5/PL22wy6ziGFV5EqNauZc= ; Message-ID: <20060604113152.31068.qmail@web31010.mail.mud.yahoo.com> Received: from [83.161.14.24] by web31010.mail.mud.yahoo.com via HTTP; Sun, 04 Jun 2006 04:31:52 PDT Date: Sun, 4 Jun 2006 04:31:52 -0700 (PDT) From: Jeroen Kransen Subject: restoring data tree from old 7.3 database To: pgsql-admin@postgresql.org MIME-Version: 1.0 Content-Type: multipart/alternative; boundary="0-918428887-1149420712=:29573" Content-Transfer-Encoding: 8bit X-Virus-Scanned: Maia Mailguard 1.0.1 X-Archive-Number: 200606/13 X-Sequence-Number: 21975 --0-918428887-1149420712=:29573 Content-Type: text/plain; charset=iso-8859-1 Content-Transfer-Encoding: 8bit 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 :) Thanks! Jeroen __________________________________________________ Do You Yahoo!? Tired of spam? Yahoo! Mail has the best spam protection around http://mail.yahoo.com --0-918428887-1149420712=:29573 Content-Type: text/html; charset=iso-8859-1 Content-Transfer-Encoding: 8bit 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 :)

Thanks!

Jeroen

__________________________________________________
Do You Yahoo!?
Tired of spam? Yahoo! Mail has the best spam protection around
http://mail.yahoo.com --0-918428887-1149420712=:29573--