Skip site navigation (1) Skip section navigation (2)

Re: restore database from bare files

From: "Dario" <dario_d_s(at)unitech(dot)com(dot)ar>
To: <pgsql-admin(at)postgresql(dot)org>
Subject: Re: restore database from bare files
Date: 2005-06-29 20:10:35
Message-ID: (view raw, whole thread or download thread mbox)
Lists: 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)


-----Mensaje original-----
De: pgsql-admin-owner(at)postgresql(dot)org
[mailto:pgsql-admin-owner(at)postgresql(dot)org]En nombre de Peter Eisentraut
Enviado el: miƩrcoles, 29 de junio de 2005 15:48
Para: jehan procaccia
CC: pgsql-admin(at)postgresql(dot)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

---------------------------(end of broadcast)---------------------------
TIP 2: you can get off all lists at once with the unregister command
    (send "unregister YourEmailAddressHere" to majordomo(at)postgresql(dot)org)

In response to


pgsql-admin by date

Next:From: jehanDate: 2005-06-30 05:34:54
Subject: Re: restore database from bare files
Previous:From: Peter EisentrautDate: 2005-06-29 18:48:22
Subject: Re: restore database from bare files

Privacy Policy | About PostgreSQL
Copyright © 1996-2017 The PostgreSQL Global Development Group