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@xxxxxxxxxxxxxx
[mailto:pgsql-admin-owner@xxxxxxxxxxxxxx]En nombre de Peter Eisentraut
Enviado el: miércoles, 29 de junio de 2005 15:48
Para: jehan procaccia
CC: pgsql-admin@xxxxxxxxxxxxxx
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@xxxxxxxxxxxxxx)
---------------------------(end of broadcast)---------------------------
TIP 5: Have you checked our extensive FAQ?
http://www.postgresql.org/docs/faq
