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 2F1F252802 for ; Thu, 30 Jun 2005 02:35:21 -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 04441-01 for ; Thu, 30 Jun 2005 05:35:11 +0000 (GMT) Received: from smtp2.int-evry.fr (smtp2.int-evry.fr [157.159.10.45]) by svr1.postgresql.org (Postfix) with ESMTP id 2027652800 for ; Thu, 30 Jun 2005 02:35:10 -0300 (ADT) Received: from smyrne.int-evry.fr (smtp-ext.int-evry.fr [157.159.11.17]) by smtp2.int-evry.fr (Postfix) with ESMTP id 40AA78042; Thu, 30 Jun 2005 07:35:04 +0200 (CEST) Received: from [84.98.190.171] (171.190.98-84.rev.gaoland.net [84.98.190.171]) (using TLSv1 with cipher DHE-RSA-AES256-SHA (256/256 bits)) (No client certificate requested) by smyrne.int-evry.fr (Postfix) with ESMTP id 0C543FF024; Thu, 30 Jun 2005 07:23:40 +0200 (CEST) Message-ID: <42C3847E.4090600@free.fr> Date: Thu, 30 Jun 2005 07:34:54 +0200 From: jehan User-Agent: Mozilla Thunderbird 1.0.2 (Windows/20050317) X-Accept-Language: fr, en MIME-Version: 1.0 To: Dario Cc: pgsql-admin@postgresql.org Subject: Re: restore database from bare files References: In-Reply-To: Content-Type: text/plain; charset=ISO-8859-1; format=flowed Content-Transfer-Encoding: 8bit X-INT-MailScanner-Information: Please contact the ISP for more information X-INT-MailScanner: Found to be clean X-INT-MailScanner-SpamCheck: X-MailScanner-From: jehan.procaccia@free.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/279 X-Sequence-Number: 18034 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 Dario a écrit : >Hello. Sorry for mi inglish! :-) > >Postgres 7.4 will not access 7.3 PGDATA repository. You must downgrade your >binary files to any 7.3.X (latest is better) >Note: 7.3 won't access 7.4 files neither. Yo can only do sub-sub-version >updates without having to dump and restore (example 7.3.1. to 7.3.9 doesn't >need to dump and restore of databases) > >greeting. > >-----Mensaje original----- >De: pgsql-admin-owner@postgresql.org >[mailto:pgsql-admin-owner@postgresql.org]En nombre de Peter Eisentraut >Enviado el: miércoles, 29 de junio de 2005 15:48 >Para: jehan procaccia >CC: pgsql-admin@postgresql.org >Asunto: Re: [ADMIN] restore database from bare files > > >jehan procaccia wrote: > > >>However I do have a tar file of the filesystem , it was on a RHEL 3 >>with rh-postgresql-server-7.3.9-2 and I have a tar of /var/lib/pgslq >>will just restoring the whole directory /var/lib/pgsql will suffices >> >> > >Assuming that you made the tarball when the server was shut down, just >restore it and you should be all set. > >-- >Peter Eisentraut >http://developer.postgresql.org/~petere/ > >---------------------------(end of broadcast)--------------------------- >TIP 2: you can get off all lists at once with the unregister command > (send "unregister YourEmailAddressHere" to majordomo@postgresql.org) > > >---------------------------(end of broadcast)--------------------------- >TIP 5: Have you checked our extensive FAQ? > > http://www.postgresql.org/docs/faq > >