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: [EMAIL PROTECTED]
[mailto:[EMAIL PROTECTED] 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 [EMAIL PROTECTED])
---------------------------(end of broadcast)---------------------------
TIP 5: Have you checked our extensive FAQ?
http://www.postgresql.org/docs/faq
---------------------------(end of broadcast)---------------------------
TIP 7: don't forget to increase your free space map settings
