From: "Martin Münstermann" <mmuenst@gmx.de>
To: pgsql-admin@postgresql.org
Subject: Re: Migration of PGDATA
Date: Mon, 29 Mar 2010 13:50:04 +0200
Message-ID: <20100329115004.222110@gmx.net> (raw)
In-Reply-To: <4BB07BCE.9040908@lelarge.info>
References: <20100329093134.62810@gmx.net>
<4BB07BCE.9040908@lelarge.info>
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?
> >
>
> 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.
There is no difference in the platform or the compiler options.
In case it does not work great, what kind of problems would we experience?
Would PG not startup at all? Or would we experience SQL errors later on or even casual crashes?
Thanks,
Martin
--
Sicherer, schneller und einfacher. Die aktuellen Internet-Browser -
jetzt kostenlos herunterladen! http://portal.gmx.net/de/go/chbrowser
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: mmuenst@gmx.de
Subject: Re: Migration of PGDATA
In-Reply-To: <20100329115004.222110@gmx.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