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 1CCA1D1B26D for ; Fri, 2 Jul 2004 01:06:07 -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 70221-04 for ; Fri, 2 Jul 2004 04:06:04 +0000 (GMT) Received: from sccrmhc12.comcast.net (sccrmhc12.comcast.net [204.127.202.56]) by svr1.postgresql.org (Postfix) with ESMTP id B5917D1B25F for ; Fri, 2 Jul 2004 01:06:02 -0300 (ADT) Received: from localhost.localdomain (c-67-162-89-61.client.comcast.net[67.162.89.61]) by comcast.net (sccrmhc12) with ESMTP id <20040702040558012004ba2ne>; Fri, 2 Jul 2004 04:06:02 +0000 Received: from localhost.localdomain (localhost.localdomain [127.0.0.1]) by localhost.localdomain (8.12.11/8.12.11) with ESMTP id i6244XUX023644; Thu, 1 Jul 2004 23:04:33 -0500 Received: (from spike@localhost) by localhost.localdomain (8.12.11/8.12.11/Submit) id i6244XRq023641; Thu, 1 Jul 2004 23:04:33 -0500 X-Authentication-Warning: localhost.localdomain: spike set sender to mike@thegodshalls.com using -f Subject: Re: recovery from server crash From: mike g Reply-To: mike@thegodshalls.com To: Debs Cc: pgsql-admin@postgresql.org In-Reply-To: <8fecbe9e.0406300142.6961a1c8@posting.google.com> References: <8fecbe9e.0406300142.6961a1c8@posting.google.com> Content-Type: text/plain Content-Transfer-Encoding: 7bit Message-Id: <1088741072.23457.23.camel@localhost.localdomain> Mime-Version: 1.0 X-Mailer: Ximian Evolution 1.4.5 (1.4.5-7) Date: Thu, 01 Jul 2004 23:04:32 -0500 X-Virus-Scanned: by amavisd-new at hub.org X-Spam-Status: No, hits=0.1 tagged_above=0.0 required=5.0 tests=RCVD_IN_SORBS X-Spam-Level: X-Archive-Number: 200407/32 X-Sequence-Number: 14100 Are you sure you have the raw database files? The /home directory is not where they are normally installed by default... If those really are the database files I believe you can try to reinstall postgres following the normal installation instructions but do not do the initdb step. Skip to starting the postmaster but reference the location of the data directory under /home instead. If there were transactions in process when it crashed it might not start. It will take the more experienced postgres folks on the list to help you recover from that. Might try searching the hackers and general list as well. HTH. Mike On Wed, 2004-06-30 at 04:42, Debs wrote: > I have a set of database files from PostgreSQL where the > root partition crashed but the /home was saved. How do I remount > these databases with a new installation of the O/S and database > executables? N.B. I _don't_ have SQL dumps, just the actual raw > database files themselves > > > thanks in advance > Debs > > ---------------------------(end of broadcast)--------------------------- > TIP 2: you can get off all lists at once with the unregister command > (send "unregister YourEmailAddressHere" to majordomo@postgresql.org)