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

From Dario
Subject Re: restore database from bare files
Date
Msg-id MHEDJHCKDNOEHJKHIOCJIECKCEAA.dario_d_s@unitech.com.ar
Whole thread Raw
In response to Re: restore database from bare files  (Peter Eisentraut <peter_e@gmx.net>)
Responses Re: restore database from bare files  (jehan <jehan.procaccia@free.fr>)
List pgsql-admin
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)


pgsql-admin by date:

Previous
From: Peter Eisentraut
Date:
Subject: Re: restore database from bare files
Next
From: jehan
Date:
Subject: Re: restore database from bare files