Received: from maia.hub.org (unknown [200.46.208.211]) by mail.postgresql.org (Postfix) with ESMTP id BF1B7632D83 for ; Mon, 29 Mar 2010 11:49:14 -0300 (ADT) Received: from mail.postgresql.org ([200.46.204.86]) by maia.hub.org (mx1.hub.org [200.46.208.211]) (amavisd-maia, port 10024) with ESMTP id 92059-02-2 for ; Mon, 29 Mar 2010 14:48:41 +0000 (UTC) X-Greylist: from auto-whitelisted by SQLgrey-1.7.6 Received: from sss.pgh.pa.us (sss.pgh.pa.us [66.207.139.130]) by mail.postgresql.org (Postfix) with ESMTP id 9C453633347 for ; Mon, 29 Mar 2010 11:47:48 -0300 (ADT) Received: from sss2.sss.pgh.pa.us (tgl@localhost [127.0.0.1]) by sss.pgh.pa.us (8.14.2/8.14.2) with ESMTP id o2TElj9s012899; Mon, 29 Mar 2010 10:47:45 -0400 (EDT) To: =?iso-8859-1?Q?=22Martin_M=FCnstermann=22?= cc: pgsql-admin@postgresql.org Subject: Re: Migration of PGDATA In-reply-to: <20100329115004.222110@gmx.net> References: <20100329093134.62810@gmx.net> <4BB07BCE.9040908@lelarge.info> <20100329115004.222110@gmx.net> Comments: In-reply-to =?iso-8859-1?Q?=22Martin_M=FCnstermann=22?= message dated "Mon, 29 Mar 2010 13:50:04 +0200" Date: Mon, 29 Mar 2010 10:47:45 -0400 Message-ID: <12898.1269874065@sss.pgh.pa.us> From: Tom Lane X-Virus-Scanned: Maia Mailguard 1.0.1 X-Spam-Status: No, hits=-2.463 tagged_above=-10 required=5 tests=AWL=0.136, BAYES_00=-2.599 X-Spam-Level: X-Archive-Number: 201003/227 X-Sequence-Number: 34026 =?iso-8859-1?Q?=22Martin_M=FCnstermann=22?= 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