pg.ddx.io  pgsql-admin@postgresql.org mailing list archive  
help / color / mirror / Atom feed
From: jehan <jehan.procaccia@free.fr>
To: Dario <dario_d_s@unitech.com.ar>
Cc: pgsql-admin@postgresql.org
Subject: Re: restore database from bare files
Date: Thu, 30 Jun 2005 07:34:54 +0200
Message-ID: <42C3847E.4090600@free.fr> (raw)
In-Reply-To: <MHEDJHCKDNOEHJKHIOCJIECKCEAA.dario_d_s@unitech.com.ar>
References: <MHEDJHCKDNOEHJKHIOCJIECKCEAA.dario_d_s@unitech.com.ar>

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
>  
>




view thread (12+ messages)  latest in thread

Message-ID: <42C3847E.4090600@free.fr>
Permalink:  ../42C3847E.4090600@free.fr/
Also on:    postgresql.org/message-id/42C3847E.4090600@free.fr

 · 

reply

Reply instructions:

You may reply publicly to this message via plain-text email
using any one of the following methods:

* Reply to all the recipients from your mail client; the link fills in
  the headers below: reply via email
  Some clients, webmail especially, drop In-Reply-To and References from
  a link, and the reply then starts a new thread: use the mbox below.

  To: pgsql-admin@postgresql.org
  Cc: jehan.procaccia@free.fr, dario_d_s@unitech.com.ar
  Subject: Re: restore database from bare files
  In-Reply-To: <42C3847E.4090600@free.fr>
  References: <MHEDJHCKDNOEHJKHIOCJIECKCEAA.dario_d_s@unitech.com.ar> <42C3847E.4090600@free.fr>

* Save the following mbox file, import it into your mail client,
  and reply-to-all from there: mbox

This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox