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 61D8F9FA4C5 for ; Sun, 17 Sep 2006 05:58:12 -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 08343-04-2 for ; Sun, 17 Sep 2006 08:58:04 +0000 (UTC) X-Greylist: from auto-whitelisted by SQLgrey- Received: from smadev.internal.net (host3.dynacom.ondsl.gr [62.103.35.211]) by postgresql.org (Postfix) with ESMTP id 38D3B9FB203 for ; Sun, 17 Sep 2006 05:58:04 -0300 (ADT) Received: from smadev.internal.net (localhost [127.0.0.1]) by smadev.internal.net (8.13.6/8.13.6) with ESMTP id k8H8vxG6035013; Sun, 17 Sep 2006 11:57:59 +0300 (EEST) (envelope-from achill@matrix.gatewaynet.com) Received: from localhost (localhost [[UNIX: localhost]]) by smadev.internal.net (8.13.6/8.13.6/Submit) id k8H8vwwk035012; Sun, 17 Sep 2006 11:57:58 +0300 (EEST) (envelope-from achill@matrix.gatewaynet.com) From: Achilleas Mantzios Organization: Dynacom Tankers Mgmt To: pgsql-admin@postgresql.org Subject: Re: Postgresql 7.4 migration to (partially) new disks Date: Sun, 17 Sep 2006 11:57:57 +0300 User-Agent: KMail/1.9.3 Cc: Tom Lane References: <200609151344.34058.achill@matrix.gatewaynet.com> <200609151725.24976.achill@matrix.gatewaynet.com> <24624.1158331639@sss.pgh.pa.us> In-Reply-To: <24624.1158331639@sss.pgh.pa.us> MIME-Version: 1.0 Content-Type: text/plain; charset="utf-8" Content-Transfer-Encoding: quoted-printable Content-Disposition: inline Message-Id: <200609171157.58083.achill@matrix.gatewaynet.com> X-Virus-Scanned: Maia Mailguard 1.0.1 X-Spam-Status: No, hits=0.135 tagged_above=0 required=5 tests=FORGED_RCVD_HELO X-Spam-Level: X-Archive-Number: 200609/169 X-Sequence-Number: 23083 =CE=A3=CF=84=CE=B9=CF=82 =CE=A0=CE=B1=CF=81=CE=B1=CF=83=CE=BA=CE=B5=CF=85= =CE=AE 15 =CE=A3=CE=B5=CF=80=CF=84=CE=AD=CE=BC=CE=B2=CF=81=CE=B9=CE=BF=CF= =82 2006 17:47, =CE=BF/=CE=B7 Tom Lane =CE=AD=CE=B3=CF=81=CE=B1=CF=88=CE=B5: > Achilleas Mantzios writes: > > What considerations should someone take if he is about to just > > cp -r /data . > > .i.e. creating the PGDATA dir *not* following the standard initdb > > procedure > > 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 di= r=20 and the executable, really, why does the executable need to be exactly the= =20 same, if we are talking about minor postgresql upgrade 7.4.12->7.4.13?) The old system is kind of old, and there would be libraries incompatibilities if a was to retain the old executable. So i'll do it the formal way, and pray lotus notes will behave :) Thanx. > > chown -R postgres:postgres ./data > > (new postgres user on the new SUSE might have a different uid/gid than > > the original Debian), > > This is OK. > > > I'd suppose this might work on a test system, but should someone > > rely on it for a critical production system? > > As long as the DBA has practiced beforehand ;-), sure. > > regards, tom lane > > ---------------------------(end of broadcast)--------------------------- > TIP 2: Don't 'kill -9' the postmaster =2D-=20 Achilleas Mantzios