X-Original-To: pgsql-admin-postgresql.org@postgresql.org Received: from localhost (wm.hub.org [200.46.204.128]) by postgresql.org (Postfix) with ESMTP id A977A9FB1BF for ; Sun, 17 Sep 2006 15:15:26 -0300 (ADT) Received: from postgresql.org ([200.46.204.71]) by localhost (mx1.hub.org [200.46.204.128]) (amavisd-new, port 10024) with ESMTP id 45630-08 for ; Sun, 17 Sep 2006 18:15:18 +0000 (UTC) X-Greylist: from auto-whitelisted by SQLgrey- Received: from sss.pgh.pa.us (sss.pgh.pa.us [66.207.139.130]) by postgresql.org (Postfix) with ESMTP id C783F9FAE4E for ; Sun, 17 Sep 2006 15:15:17 -0300 (ADT) Received: from sss2.sss.pgh.pa.us (tgl@localhost [127.0.0.1]) by sss.pgh.pa.us (8.13.6/8.13.6) with ESMTP id k8HIFEi3023602; Sun, 17 Sep 2006 14:15:14 -0400 (EDT) To: Achilleas Mantzios cc: pgsql-admin@postgresql.org Subject: Re: Postgresql 7.4 migration to (partially) new disks In-reply-to: <200609171157.58083.achill@matrix.gatewaynet.com> References: <200609151344.34058.achill@matrix.gatewaynet.com> <200609151725.24976.achill@matrix.gatewaynet.com> <24624.1158331639@sss.pgh.pa.us> <200609171157.58083.achill@matrix.gatewaynet.com> Comments: In-reply-to Achilleas Mantzios message dated "Sun, 17 Sep 2006 11:57:57 +0300" Date: Sun, 17 Sep 2006 14:15:13 -0400 Message-ID: <23601.1158516913@sss.pgh.pa.us> From: Tom Lane X-Virus-Scanned: Maia Mailguard 1.0.1 X-Archive-Number: 200609/170 X-Sequence-Number: 23084 Achilleas Mantzios writes: >> If you copy the *entire* data tree (data, xlog, clog, any outside >> tablespaces), and use exactly the same Postgres executables at both >> ends, then it should pretty much Just Work. > Thats what i feared from the begining. (some connection between the data dir > and the executable, really, why does the executable need to be exactly the > same, > if we are talking about minor postgresql upgrade 7.4.12->7.4.13?) Well, a minor version update won't in itself break anything; what would break things is changing certain build options (such as integer-datetimes) or switching to a different architecture (such as x86 -> x86_64). regards, tom lane