Re: Migration of PGDATA

From: Robert Joosten <robert(at)ml(dot)erje(dot)net>
To: pgsql-admin(at)postgresql(dot)org
Subject: Re: Migration of PGDATA
Date: 2010-03-29 10:18:58
Message-ID: 20100329101857.GC1188@ismet.erje.net
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: 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

In response to

Responses

Browse pgsql-admin by date

  From Date Subject
Next Message Martin Münstermann 2010-03-29 10:49:55 Re: Migration of PGDATA
Previous Message Guillaume Lelarge 2010-03-29 10:07:10 Re: Migration of PGDATA