Re: Migration of PGDATA - Mailing list pgsql-admin

From Robert Joosten
Subject Re: Migration of PGDATA
Date
Msg-id 20100329101857.GC1188@ismet.erje.net
Whole thread Raw
In response to Migration of PGDATA  ("Martin Münstermann" <mmuenst@gmx.de>)
Responses Re: Migration of PGDATA  ("Martin Münstermann" <mmuenst@gmx.de>)
List pgsql-admin
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.

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.

Regards,
Robert

pgsql-admin by date:

Previous
From: Guillaume Lelarge
Date:
Subject: Re: Migration of PGDATA
Next
From: "Martin Münstermann"
Date:
Subject: Re: Migration of PGDATA