From: Tom Lane <tgl@sss.pgh.pa.us>
To: "Martin Münstermann" <mmuenst@gmx.de>
Cc: pgsql-admin@postgresql.org
Subject: Re: Migration of PGDATA
Date: Mon, 29 Mar 2010 10:47:45 -0400
Message-ID: <12898.1269874065@sss.pgh.pa.us> (raw)
In-Reply-To: <20100329115004.222110@gmx.net>
References: <20100329093134.62810@gmx.net>
<4BB07BCE.9040908@lelarge.info>
<20100329115004.222110@gmx.net>
=?iso-8859-1?Q?=22Martin_M=FCnstermann=22?= <mmuenst@gmx.de> writes:
> In case it does not work great, what kind of problems would we experience?
In theory pg_control contains enough information to detect such
compatibility problems, so that you'd get a refusal to start.
In practice, maybe not, and the consequences could be arbitrarily
unpleasant. Better keep a pg_dump backup just in case.
One thing I'd particularly caution you to check is that the locale
settings on the new platform are equivalent to those on the old.
We have seen cases where the same locale name produces different
sort orderings on different platforms. That will result in corrupt
(malfunctioning) indexes on text columns.
regards, tom lane
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: tgl@sss.pgh.pa.us, mmuenst@gmx.de
Subject: Re: Migration of PGDATA
In-Reply-To: <12898.1269874065@sss.pgh.pa.us>
* 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