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 B36FA52806 for ; Thu, 30 Jun 2005 03:34:39 -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 15165-07 for ; Thu, 30 Jun 2005 06:34:30 +0000 (GMT) Received: from titan.ecommit.de (titan.ecommit.de [195.145.58.245]) by svr1.postgresql.org (Postfix) with ESMTP id 2619552801 for ; Thu, 30 Jun 2005 03:34:28 -0300 (ADT) Received: from titan.ecommit.de (localhost [127.0.0.1]) by titan.ecommit.de (8.12.6/8.12.6/SuSE Linux 0.6) with ESMTP id j5U6YQ0F032139; Thu, 30 Jun 2005 08:34:28 +0200 Received: from titan.ecommit.de (root@localhost) by titan.ecommit.de (8.12.6/8.12.6/Submit) with ESMTP id j5U6YQvm032138; Thu, 30 Jun 2005 08:34:26 +0200 Received: from fandelm.ecommit.de (fandelm.tc.de 192.168.252.51) by titan.ecommit.de (Scalix SMTP Relay 9.0.0.26) via ESMTP; Thu, 30 Jun 2005 08:34:25 +0200 (CEST) Date: Thu, 30 Jun 2005 08:32:52 +0200 From: "Martin Fandel" To: jehan Cc: pgsql-admin@postgresql.org Message-ID: <1120113173.18693.39.camel@fandelm.ecommit.de> In-Reply-To: <42C3847E.4090600@free.fr> References: References: <42C3847E.4090600@free.fr> Subject: Re: restore database from bare files x-scalix-Hops: 1 X-Mailer: Evolution 2.0.1 Mime-Version: 1.0 Content-Type: text/plain Content-Disposition: inline X-Virus-Scanned: by amavisd-new at hub.org X-Spam-Status: No, hits=0.036 tagged_above=0 required=5 tests=AWL X-Spam-Level: X-Archive-Number: 200506/280 X-Sequence-Number: 18035 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