Received: from maia.hub.org (unknown [200.46.204.183]) by mail.postgresql.org (Postfix) with ESMTP id 0C2C2633130 for ; Mon, 29 Mar 2010 06:32:09 -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 07929-08 for ; Mon, 29 Mar 2010 09:31:58 +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 EB487633AAC for ; Mon, 29 Mar 2010 06:31:37 -0300 (ADT) Received: (qmail 1610 invoked by uid 0); 29 Mar 2010 09:31:36 -0000 Received: from 193.194.157.126 by www157.gmx.net with HTTP; Mon, 29 Mar 2010 11:31:34 +0200 (CEST) Content-Type: text/plain; charset="iso-8859-1" Date: Mon, 29 Mar 2010 11:31:34 +0200 From: =?iso-8859-1?Q?=22Martin_M=FCnstermann=22?= Message-ID: <20100329093134.62810@gmx.net> MIME-Version: 1.0 Subject: 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: V01U2FsdGVkX18ucDUJTXIuIN4yKit55ewSKtmBOQ+UWD02wpY9L7 pDFojb0zIknR7M+I8DsY4JUmbpDXPXXbkw0A== Content-Transfer-Encoding: 8bit X-GMX-UID: QkGCeLgvPTR+cLJ9OjIwcgU5c2tpZMv8 X-FuHaFi: 0.72999999999999998 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/220 X-Sequence-Number: 34019 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? Thanks, Martin -- GMX DSL: Internet, Telefon und Entertainment für nur 19,99 EUR/mtl.! http://portal.gmx.net/de/go/dsl02