From: Guillaume Lelarge <guillaume@lelarge.info>
To: Martin Münstermann <mmuenst@gmx.de>
Cc: pgsql-admin@postgresql.org
Subject: Re: Migration of PGDATA
Date: Mon, 29 Mar 2010 12:07:10 +0200
Message-ID: <4BB07BCE.9040908@lelarge.info> (raw)
In-Reply-To: <20100329093134.62810@gmx.net>
References: <20100329093134.62810@gmx.net>
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.orghttp://dalibo.com
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: guillaume@lelarge.info, mmuenst@gmx.de
Subject: Re: Migration of PGDATA
In-Reply-To: <4BB07BCE.9040908@lelarge.info>
* 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