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 D581E52A47 for ; Thu, 30 Jun 2005 07:28:10 -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 81435-07 for ; Thu, 30 Jun 2005 10:28:01 +0000 (GMT) Received: from smtp.inapg.inra.fr (tamise.inapg.inra.fr [193.54.111.32]) by svr1.postgresql.org (Postfix) with ESMTP id 1B17852A37 for ; Thu, 30 Jun 2005 07:28:00 -0300 (ADT) Received: from localhost (localhost [127.0.0.1]) by smtp.inapg.inra.fr (Postfix) with ESMTP id 42BCD4C0A6; Thu, 30 Jun 2005 12:28:03 +0200 (CEST) Received: from smtp.inapg.inra.fr ([127.0.0.1]) by localhost (smtp [127.0.0.1]) (amavisd-new, port 10024) with ESMTP id 04288-03; Thu, 30 Jun 2005 12:28:02 +0200 (CEST) Received: from [193.54.111.41] (metarisk2.inapg.fr [193.54.111.41]) by smtp.inapg.inra.fr (Postfix) with ESMTP id 1F8CD4C098; Thu, 30 Jun 2005 12:28:02 +0200 (CEST) Message-ID: <42C3D00E.1010106@free.fr> Date: Thu, 30 Jun 2005 12:57:18 +0200 From: jehan-free User-Agent: Mozilla/5.0 (X11; U; Linux i686; en-US; rv:1.7.8) Gecko/20050512 Red Hat/1.7.8-1.4.1 X-Accept-Language: en-us, en MIME-Version: 1.0 To: Martin Fandel Cc: pgsql-admin@postgresql.org Subject: Re: restore database from bare files References: <1120113173.18693.39.camel@fandelm.ecommit.de> In-Reply-To: <1120113173.18693.39.camel@fandelm.ecommit.de> Content-Type: text/plain; charset=ISO-8859-1; format=flowed Content-Transfer-Encoding: 7bit X-Virus-Scanned: by amavisd-new-20030616-p10 (Debian) at inapg.fr X-Virus-Scanned: by amavisd-new at hub.org X-Spam-Status: No, hits=0 tagged_above=0 required=5 tests= X-Spam-Level: X-Archive-Number: 200506/285 X-Sequence-Number: 18040 OK, I'am not yet at restarting postgres .. but if at get pb then I check that , thanks ! For now , How can I tell from the bare file the mapping between a database name and the number appearing in /var/lib/pgsql/base directory I have : pgsql/data/base/1/ pgsql/data/base/16975/ pgsql/data/base/16980/ so I made the assumption that 1 is a database (probably the test initial database ?), 16975 is an other one and 16980 a tird one ! How can I find the map from these numbers to database name ? thanks Martin Fandel wrote: >Hi > >Maybe you must reset the WAL's >( http://www.postgresql.org/docs/7.3/interactive/app-pgresetxlog.html ) >after restoring from tarball if postgres doesn't start. > >Am Donnerstag, den 30.06.2005, 07:34 +0200 schrieb jehan: > > >>So I must one way or another run a 7.3, restore the file from the >>tarball as is (just put them back to /var/lib/pgsql), the databases >>should be running correctly then (?), then pg_dump it , upgrade to 7.4 >>and restore from the pg_dump . >>before running in all this (and I still don't know how I will be able to >>get a 7.3 on RHEL4 ... ?) is that the correct procedure ? >>thanks >> >> > >yes, this is the correct way :). > >Martin > > >---------------------------(end of broadcast)--------------------------- >TIP 9: In versions below 8.0, the planner will ignore your desire to > choose an index scan if your joining column's datatypes do not > match > >