Re: restore database from bare files - Mailing list pgsql-admin

From jehan
Subject Re: restore database from bare files
Date
Msg-id 42C3847E.4090600@free.fr
Whole thread Raw
In response to Re: restore database from bare files  ("Dario" <dario_d_s@unitech.com.ar>)
Responses Re: restore database from bare files  ("Martin Fandel" <martin.fandel@alphyra-evs.de>)
List pgsql-admin
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
>
>


pgsql-admin by date:

Previous
From: "Dario"
Date:
Subject: Re: restore database from bare files
Next
From: "Martin Fandel"
Date:
Subject: Re: restore database from bare files