Received: from localhost (unknown [200.46.204.183]) by postgresql.org (Postfix) with ESMTP id E35E02E3298 for ; Wed, 2 Jan 2008 05:46:11 -0400 (AST) Received: from postgresql.org ([200.46.204.71]) by localhost (mx1.hub.org [200.46.204.183]) (amavisd-maia, port 10024) with ESMTP id 11713-04 for ; Wed, 2 Jan 2008 05:46:03 -0400 (AST) Received: from collab.sm-wg.net (collab.sm-wg.net [86.43.106.231]) by postgresql.org (Postfix) with ESMTP id 6F7D02E32B3 for ; Wed, 2 Jan 2008 05:46:03 -0400 (AST) Received: from collab.sm-wg.net (localhost [127.0.0.1]) by collab.sm-wg.net (Postfix) with ESMTP id 1B8442D1705; Wed, 2 Jan 2008 09:46:01 +0000 (GMT) DKIM-Signature: v=1; a=rsa-sha1; c=relaxed; d=sm-wg.net; h=message-id: date:from:mime-version:to:cc:subject:references:in-reply-to: content-type:content-transfer-encoding; q=dns/txt; s=m1; bh=pRmo R0HRl4Nw1KbJB7Px1atR4iw=; b=oioZTN3UzeWFYNQ12ZFHEZTsc7uGwgJJBBjx lPbyFqa0Ys2QKdM+KYsXhZHg722Wk8f1tG/BFHTtfbUNvHPHYOiAkvjsGsNruNbx Qg9dzjNdposOvs9JCXYDQTdgMx16j2A0wDUoyhRwYQOUKtY11RPZOIjTTVkTwBV5 XzESy2A= Received: from [192.168.1.8] (unknown [192.168.1.8]) by collab.sm-wg.net (Postfix) with ESMTP id 014812D1703; Wed, 2 Jan 2008 09:46:00 +0000 (GMT) Message-ID: <477B5D58.2010409@sm-wg.net> Date: Wed, 02 Jan 2008 09:46:00 +0000 From: Bernhard D Rohrer User-Agent: Thunderbird 2.0.0.6 (X11/20071022) MIME-Version: 1.0 To: Tom Lane CC: pgsql-admin@postgresql.org Subject: Re: pg recovery References: <4778D3AC.7080108@sm-wg.net> <6006.1199115273@sss.pgh.pa.us> In-Reply-To: <6006.1199115273@sss.pgh.pa.us> Content-Type: text/plain; charset=ISO-8859-1; format=flowed Content-Transfer-Encoding: 7bit X-Virus-Scanned: Maia Mailguard 1.0.1 X-Archive-Number: 200801/7 X-Sequence-Number: 27781 Tom Lane wrote: > Bernhard D Rohrer writes: >> I have a broken database and not much clue about postgres, sorry for the >> n00b questions :( > > I think you've got a cross-version problem, as in the database is really > PG 8.0 or earlier but you're trying to run 8.1 against it. What is in > the PG_VERSION file? Have you done "pg_resetxlog -f", and if so do you > have the original pg_control file to put back? > > regards, tom lane Hi Tom I have not run "pg_resetxlog -f" on the pg_control file for which I posted the output of pg_resetxlog -n as for the versions see for yourself: root@collab:/home/adminlion# cat /var/lib/postgresql/8.1/main/PG_VERSION 8.1 root@collab:/home/adminlion# cat /olddrive/var/lib/postgresql/8.1/main/PG_VERSION 8.1 /olddrive is the former raid drive that holds the database I am trying to restore. thanks :) Bernhard -- Graylion's Fetish & Fashion Store Goth and Kinky Boots, Clothing and Jewellery http://www.graylion.net