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 CE34E52B31 for ; Thu, 11 Aug 2005 11:07:37 -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 52494-07 for ; Thu, 11 Aug 2005 14:07:35 +0000 (GMT) Received: from sss.pgh.pa.us (sss.pgh.pa.us [66.207.139.130]) by svr1.postgresql.org (Postfix) with ESMTP id DEE5852A76 for ; Thu, 11 Aug 2005 11:07:32 -0300 (ADT) Received: from sss2.sss.pgh.pa.us (tgl@localhost [127.0.0.1]) by sss.pgh.pa.us (8.13.1/8.13.1) with ESMTP id j7BE7XGj021936; Thu, 11 Aug 2005 10:07:33 -0400 (EDT) To: "Gregory S. Williamson" Cc: pgsql-admin@postgresql.org Subject: Re: restoring an old database to a new instance -- possible ? In-reply-to: <71E37EF6B7DCC1499CEA0316A2568328024BB760@loki.wc.globexplorer.net> References: <71E37EF6B7DCC1499CEA0316A2568328024BB760@loki.wc.globexplorer.net> Comments: In-reply-to "Gregory S. Williamson" message dated "Thu, 11 Aug 2005 02:09:29 -0700" Date: Thu, 11 Aug 2005 10:07:33 -0400 Message-ID: <21935.1123769253@sss.pgh.pa.us> From: Tom Lane X-Virus-Scanned: by amavisd-new at hub.org X-Spam-Status: No, hits=0.006 tagged_above=0 required=5 tests=[AWL=0.006] X-Spam-Level: X-Archive-Number: 200508/143 X-Sequence-Number: 18462 "Gregory S. Williamson" writes: > Using PostSQL 7.4 on a linux server, we have one postgres instance with two databases, "gex_runtime" and "mq_geoloc." We had a mishap in which we ran out of disk space. The failure occured in writing to the gex_runtime database. > Then an unfortunate slip of an admin's keyboard led to the deletion of the gex_runtime data itself under the $PGDATA directory. As far as I can tell the mq_geoloc database files (about 3 gigs worth) were undamaged. > We moved the mq_geoloc files to a safe location, and now have taken a copy of the runtime database from another server and recreated our server as far as the runtime database goes. > My question is whether there is anyway of retrieving the old geoloc database ? Or is my reading of these files total out-of-line with reality ? If you saved the *whole* $PGDATA directory tree including pg_clog and so on, then there's nothing at all wrong with the mq_geoloc database. Just don't try to connect to gex_runtime. I'd fire up a postmaster and pg_dump mq_geoloc, then reload that data into your new installation. regards, tom lane