Received: from maia.hub.org (unknown [200.46.208.211]) by mail.postgresql.org (Postfix) with ESMTP id BF1AC6323DF for ; Mon, 29 Mar 2010 08:50:20 -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 65606-10 for ; Mon, 29 Mar 2010 11:50:01 +0000 (UTC) X-Greylist: domain auto-whitelisted by SQLgrey-1.7.6 Received: from mail.gmx.net (mail.gmx.net [213.165.64.20]) by mail.postgresql.org (Postfix) with SMTP id 9F943633166 for ; Mon, 29 Mar 2010 08:50:07 -0300 (ADT) Received: (qmail 20199 invoked by uid 0); 29 Mar 2010 11:50:05 -0000 Received: from 193.194.157.126 by www127.gmx.net with HTTP; Mon, 29 Mar 2010 13:50:03 +0200 (CEST) Content-Type: text/plain; charset="us-ascii" Date: Mon, 29 Mar 2010 13:50:04 +0200 From: =?iso-8859-1?Q?=22Martin_M=FCnstermann=22?= In-Reply-To: <4BB07BCE.9040908@lelarge.info> Message-ID: <20100329115004.222110@gmx.net> MIME-Version: 1.0 References: <20100329093134.62810@gmx.net> <4BB07BCE.9040908@lelarge.info> Subject: Re: Migration of PGDATA To: pgsql-admin@postgresql.org X-Authenticated: #740997 X-Flags: 0001 X-Mailer: WWW-Mail 6100 (Global Message Exchange) X-Priority: 3 X-Provags-ID: V01U2FsdGVkX1886SMgBlE8kXp6CCFaC7x/YxPKDa4fThk8Ed1fHd OStVHWG8LFk/+dxwfcdDXIWGN1sQmRuDi0Ow== Content-Transfer-Encoding: 7bit X-GMX-UID: 3aGWY+rxLi50AK1qYWtpN95rZml1ZBgV X-FuHaFi: 0.64000000000000001 X-Virus-Scanned: Maia Mailguard 1.0.1 X-Spam-Status: No, hits=0.001 tagged_above=-10 required=5 tests=BAYES_50=0.001 X-Spam-Level: X-Archive-Number: 201003/225 X-Sequence-Number: 34024 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