Received: from maia.hub.org (unknown [200.46.204.183]) by mail.postgresql.org (Postfix) with ESMTP id 4F8C4633571 for ; Mon, 29 Mar 2010 07:07:52 -0300 (ADT) Received: from mail.postgresql.org ([200.46.204.86]) by maia.hub.org (mx1.hub.org [200.46.204.183]) (amavisd-maia, port 10024) with ESMTP id 14973-01 for ; Mon, 29 Mar 2010 10:07:41 +0000 (UTC) X-Greylist: from auto-whitelisted by SQLgrey-1.7.6 Received: from sd-17937.dedibox.fr (sd-17937.dedibox.fr [88.191.100.74]) by mail.postgresql.org (Postfix) with ESMTP id 2F6186337DF for ; Mon, 29 Mar 2010 07:07:12 -0300 (ADT) Received: from [192.168.0.7] (uni14-1-82-233-223-216.fbx.proxad.net [82.233.223.216]) by sd-17937.dedibox.fr (Postfix) with ESMTPA id C4CAD3B8F5; Mon, 29 Mar 2010 12:07:10 +0200 (CEST) Message-ID: <4BB07BCE.9040908@lelarge.info> Date: Mon, 29 Mar 2010 12:07:10 +0200 From: Guillaume Lelarge User-Agent: Mozilla/5.0 (X11; U; Linux i686; fr; rv:1.9.1.8) Gecko/20100227 Thunderbird/3.0.3 MIME-Version: 1.0 To: =?ISO-8859-1?Q?Martin_M=FCnstermann?= CC: pgsql-admin@postgresql.org Subject: Re: Migration of PGDATA References: <20100329093134.62810@gmx.net> In-Reply-To: <20100329093134.62810@gmx.net> Content-Type: text/plain; charset=ISO-8859-1 Content-Transfer-Encoding: 8bit X-Virus-Scanned: Maia Mailguard 1.0.1 X-Spam-Status: No, hits=-2.599 tagged_above=-10 required=5 tests=BAYES_00=-2.599 X-Spam-Level: X-Archive-Number: 201003/221 X-Sequence-Number: 34020 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.org http://dalibo.com