X-Original-To: pgsql-admin-postgresql.org@localhost.postgresql.org Received: from localhost (unknown [200.46.204.144]) by svr1.postgresql.org (Postfix) with ESMTP id 2AB83D1B170 for ; Fri, 18 Jun 2004 20:42:23 -0300 (ADT) Received: from svr1.postgresql.org ([200.46.204.71]) by localhost (av.hub.org [200.46.204.144]) (amavisd-new, port 10024) with ESMTP id 71273-02 for ; Fri, 18 Jun 2004 23:42:20 +0000 (GMT) Received: from localhost.localdomain (unknown [134.87.4.251]) by svr1.postgresql.org (Postfix) with ESMTP id 57E57D1B750 for ; Fri, 18 Jun 2004 20:42:16 -0300 (ADT) Received: from bcgsc.ca (localhost [127.0.0.1]) by localhost.localdomain (8.11.6/8.11.6) with ESMTP id i5INgI410809 for ; Fri, 18 Jun 2004 16:42:19 -0700 Message-ID: <40D37DDA.5010400@bcgsc.ca> Date: Fri, 18 Jun 2004 16:42:18 -0700 From: Chris Fjell User-Agent: Mozilla/5.0 (X11; U; Linux i686; en-US; rv:1.6) Gecko/20040113 X-Accept-Language: en-us, en MIME-Version: 1.0 To: pgsql-admin@postgresql.org Subject: restoring a database from a file copy Content-Type: text/plain; charset=us-ascii; format=flowed Content-Transfer-Encoding: 7bit X-Virus-Scanned: by amavisd-new at hub.org X-Spam-Status: No, hits=0.0 tagged_above=0.0 required=5.0 tests= X-Spam-Level: X-Archive-Number: 200406/243 X-Sequence-Number: 13903 Can a database system be restored just from the data under the installation directory? I backed-up my database using "rsync /var/lib/pgsql " Then I upgraded my rpms from 7.3.4 to 7.4. Then I tried to start the server as usual and it complained about version conflict (of course). I removed the 7.4 rpms and went back to 7.3.4 and restared server. My data are gone - only the template tables are listed. I copied back from my file backup and this, much to my horror, did not restore my database - it's as if the tables are all gone, but the file sizes indicate the data are there. Any way to recreate a catalog (or whatever) from the data? The server seemed to be down when I copied - can't see what I could have done to corrupt the files under /var/lib/pgsql/data/ I couldn't do a pg_dump due to bad OIDs - this was the motivation for the upgrade - so I seem to have lost everything. Any thoughts? -- Chris Fjell