Re: Migration of PGDATA

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