From: Robert Joosten <robert@ml.erje.net>
To: pgsql-admin@postgresql.org
Subject: Re: Migration of PGDATA
Date: Mon, 29 Mar 2010 12:18:58 +0200
Message-ID: <20100329101857.GC1188@ismet.erje.net> (raw)
In-Reply-To: <20100329093134.62810@gmx.net>
References: <20100329093134.62810@gmx.net>
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
Reply instructions:
You may reply publicly to this message via plain-text email
using any one of the following methods:
* Reply to all the recipients using the --to and --cc options:
reply via email
To: pgsql-admin@postgresql.org
Cc: robert@ml.erje.net
Subject: Re: Migration of PGDATA
In-Reply-To: <20100329101857.GC1188@ismet.erje.net>
* Save the following mbox file, import it into your mail client,
and reply-to-all from there: mbox
This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox