Hi, > > 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? > > Besides the other reply, take into account little- versus bigendian > changes if you switch hardware. Good point. But as we stick to Linux on Intel, we expect no problems there. > But just out of curiosity: why propose against a dump/restore ? I mean: > when I upgrade between major releases I dump as well, as it is > recommended. I never ran into trouble, you know. It's a question of migration duration aka downtime. Our PGDATA resides on a SAN, so moving/migrating the directory takes a couple of seconds. A dump/restore cycle would take much longer. Thanks, Martin -- GMX.at - Österreichs FreeMail-Dienst mit über 2 Mio Mitgliedern E-Mail, SMS & mehr! Kostenlos: http://portal.gmx.net/de/go/atfreemail -- Sent via pgsql-admin mailing list (pgsql-admin@xxxxxxxxxxxxxx) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-admin
