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 86D06535AC for ; Sun, 27 Mar 2005 17:06:58 +0100 (BST) 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 48819-05 for ; Sun, 27 Mar 2005 16:06:52 +0000 (GMT) Received: from sunsite.dcc.uchile.cl (sunsite.dcc.uchile.cl [192.80.24.2]) by svr1.postgresql.org (Postfix) with ESMTP id 7DE50534E4 for ; Sun, 27 Mar 2005 17:06:51 +0100 (BST) Received: from anakena.dcc.uchile.cl (anakena [192.80.24.6]) by sunsite.dcc.uchile.cl (8.12.11/8.12.11) with ESMTP id j2RG6lvQ028617; Sun, 27 Mar 2005 12:06:47 -0400 (CLT) Received: by anakena.dcc.uchile.cl (Postfix, from userid 4151) id 4AA9A5301B; Sun, 27 Mar 2005 12:06:47 -0400 (CLT) Date: Sun, 27 Mar 2005 12:06:47 -0400 From: Alvaro Herrera To: root Cc: pgsql-admin@postgresql.org Subject: Re: Import Database Message-ID: <20050327160647.GA16169@dcc.uchile.cl> References: <200503230331.j2N3VjOt008146@weyland.caerdroia.org> Mime-Version: 1.0 Content-Type: text/plain; charset=us-ascii Content-Disposition: inline In-Reply-To: <200503230331.j2N3VjOt008146@weyland.caerdroia.org> User-Agent: Mutt/1.5.6i X-Virus-Scanned: by amavisd-new at hub.org X-Spam-Status: No, hits=0.348 tagged_above=0 required=5 tests=AWL, DNS_FROM_RFC_ABUSE X-Spam-Level: X-Archive-Number: 200503/446 X-Sequence-Number: 16944 On Tue, Mar 22, 2005 at 09:31:45PM -0600, root wrote: > I have a postgres 7.2.2 database, without the DB_VERSION file, so I'm assuming > this is an "alternate location" - as you can tell, I'm not a DBA. Anyway, > the machine it was on got hacked, and I backed off the things I thought were > important, reinstalled the OS and put the other things, including this DB, > back into place. Problem: I don't have the /var/lib/pgsql part of my old > installation, Exactly what did you back up? What are the contents of the directory you are trying to "attach" ? If you didn't backup a pg_clog directory, you are pretty much hosed, I think. -- Alvaro Herrera () "On the other flipper, one wrong move and we're Fatal Exceptions" (T.U.X.: Term Unit X - http://www.thelinuxreview.com/TUX/)