Le 29/03/2010 11:31, "Martin Münstermann" a écrit : > [...] > is it safe to move the PGDATA directory from one system to another when migrating from one operating system to another? > For example: migrating from Debian to RHEL, or from RHEL4 to RHEL5? > The database is of course shutdown properly, and the PG major versions match. > > Or is a dump/restore necessary in these cases? > As long as you have the same hardware platform (for example no 32bit/64bit changes) and no difference in compiling options (for example --disable-integer-datetimes), it should work great. -- Guillaume. http://www.postgresqlfr.org http://dalibo.com -- Sent via pgsql-admin mailing list (pgsql-admin@xxxxxxxxxxxxxx) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-admin