X-POP3-Server: Host ([mail.hitechroboticsystemz.com]) 	by hitechgears.com (PostMaster POP3 Login [hrs@hitechroboticsystemz.com] [192.168.0.25]); 	Sun, 27 Nov 2011 15:47:11 +0530
Return-Path: <pgsql-general-owner+m182629@postgresql.org>
Received: from mx2.hub.org [200.46.204.254] by dr178.cyberspaceindia.com with SMTP;
   Sun, 27 Nov 2011 15:35:13 +0530
Received: from postgresql.org (mail.postgresql.org [200.46.204.86])
	by mx2.hub.org (Postfix) with ESMTP id C8CFD114332;
	Sun, 27 Nov 2011 06:05:07 -0400 (AST)
Received: from magus.postgresql.org (magus.postgresql.org [87.238.57.229])
	by mail.postgresql.org (Postfix) with ESMTP id D00CB1C5E16A
	for <pgsql-general@postgresql.org>; Sun, 27 Nov 2011 05:59:35 -0400 (AST)
Received: from [2001:4d88:1ffc:463::1] (helo=uvena.de)
	by magus.postgresql.org with esmtp (Exim 4.72)
	(envelope-from <frank@frank.uvena.de>)
	id 1RUbWJ-0005VW-6R
	for pgsql-general@postgresql.org; Sun, 27 Nov 2011 09:59:35 +0000
Received: from [141.35.30.44] (vlan768-5.vpn.uni-jena.de [141.35.30.44])
	(using TLSv1 with cipher DHE-RSA-AES256-SHA (256/256 bits))
	(No client certificate requested)
	by uvena.de (Postfix) with ESMTPSA id B59562540E0
	for <pgsql-general@postgresql.org>; Sun, 27 Nov 2011 10:00:51 +0000 (UTC)
Message-ID: <4ED209F1.9090107@frank.uvena.de>
Date: Sun, 27 Nov 2011 10:59:13 +0100
From: Frank Lanitz <frank@frank.uvena.de>
User-Agent: Mozilla/5.0 (X11; Linux x86_64; rv:7.0.1) Gecko/20110929 Thunderbird/7.0.1
MIME-Version: 1.0
To: pgsql-general@postgresql.org
Subject: Re: [GENERAL] CPU move
References: <CAJnnue076FgFuh_dUR7v=pN=jXH2S0R6pSPTTWgm1w4JRtdSQw@mail.gmail.com>
In-Reply-To: <CAJnnue076FgFuh_dUR7v=pN=jXH2S0R6pSPTTWgm1w4JRtdSQw@mail.gmail.com>
X-Enigmail-Version: 1.3.3
Content-Type: multipart/signed; micalg=pgp-sha1;
 protocol="application/pgp-signature";
 boundary="------------enigF518B45BB791917387236BCA"
X-Host-Lookup-Failed: Reverse DNS lookup failed for 2001:4d88:1ffc:463::1 (failed)
X-Pg-Spam-Score: -1.1 (-)
X-Mailing-List: pgsql-general
List-Archive: <http://archives.postgresql.org/pgsql-general>
List-Help: <mailto:majordomo@postgresql.org?body=help>
List-ID: <pgsql-general.postgresql.org>
List-Owner: <mailto:pgsql-general-owner@postgresql.org>
List-Post: <mailto:pgsql-general@postgresql.org>
List-Subscribe: <mailto:majordomo@postgresql.org?body=sub%20pgsql-general>
List-Unsubscribe: <mailto:majordomo@postgresql.org?body=unsub%20pgsql-general>
Precedence: bulk
Sender: pgsql-general-owner@postgresql.org
X-Declude-Sender: pgsql-general-owner+m182629@postgresql.org [200.46.204.254]
X-Declude-Spoolname: -1481893469268.eml
X-Declude-RefID: str=0001.0A090207.4ED20B60.021E:SCFMA507887,ss=1,fgs=0
X-Declude-Note: Scanned by Declude 4.10.79 "http://www.declude.com/x-note.htm"
X-Declude-Scan: Incoming Score [-5] at 15:35:24 on 27 Nov 2011
X-Declude-Tests: NOABUSE [2], FROMNOMATCH [2], HAM-INDICATOR [-8], FILTER-SUBJECT [2]
X-Country-Chain: 'EU' [corrupt RIPE data]->NORWAY->PANAMA->destination
X-Declude-Code: f
X-HELO: mx2.hub.org
X-Identity: 200.46.204.254 | mx2.hub.org | postgresql.org
X-Rcpt-To: <anisha.kaul@hitechroboticsystemz.com>
X-SmarterMail-Spam: Declude: -5
X-SmarterMail-TotalSpamWeight: -5

--------------enigF518B45BB791917387236BCA
Content-Type: text/plain; charset=ISO-8859-1
Content-Transfer-Encoding: quoted-printable

Am 26.11.2011 19:18, schrieb Carlos Henrique Reimer:
> Hi,
>=20
> We're planning to move our postgreSQL database from one CPU box to
> another box.
>=20
> I'm considering an alternative procedure for the move as the standard
> one (pg_dump from the old, copy dump to the new box, psql to restore in=

> the new) will take about 10 hours to complete. The ideia is installing
> the same Linux and PostgreSQL versions in the new box and copy the
> entire database cluster directory from the old to the new one using the=

> scp Linux command.

If you are using the same architecture you could use the warm-standby
procedure for doing the sync and then switching the system. There is
pg_standby available for.

Cheers,
Frank


--------------enigF518B45BB791917387236BCA
Content-Type: application/pgp-signature; name="signature.asc"
Content-Description: OpenPGP digital signature
Content-Disposition: attachment; filename="signature.asc"

-----BEGIN PGP SIGNATURE-----
Version: GnuPG v1.4.11 (GNU/Linux)
Comment: Using GnuPG with Mozilla - http://enigmail.mozdev.org/

iQIcBAEBAgAGBQJO0gn3AAoJEMTGKa65g3T9UREP/1ruDkUsSt/KO5FgzGi9cQDr
fLjr2VN27KiF6VmWSan0CwExF/l5QyMZiBmGJDxqa1eTNBEBNe1mZ5os28BWWudd
jsELopcTMN2/NtQA6PfwS38+xTC64xqO3/cnsaP5xfw7bKC5qsce83eRYOVjZSap
KQ/hoH7N6lfoS5rlhD8oTDgNbfJiyPXSejb+1EQtyAR21P+gVeeFVvQPwrelNt0i
/YEvpRfl/lg9kO8vVviATXpU1m8kzA6xDbMAPR6fLG4bBSIA+TVCRvFJUlrOlr7w
81ipkYg7yXB41Y8F0xlpbx/VMDMqSly+hYKxiKLg/8es7/C6KCcGfJJ3T2eElH5u
4pxqiPJGtzE2TVagRKIqTkIeZ07ZrPa/ui5Ok85G66h85ZhmPTCAWpnvYGYRSwFi
GNT2MlF0qhpins5roDVTxK6g+5nFC74HNrq56gQA0dVlFTvuZZ6LlstPWCArvOr3
J+TKgoliqnQZKjOVUpgh6NX8oWYDSw54dxbth2HexWV13IIoGRMYTpTUm85tQsHH
9WJVkY7vqun/5NEBgdQTXyWxPb7NDzqDvi3TOMMsse25VSwPsDvSnx4ssgrwB1zA
9IEYr1WMTk7HhjYL+mCVHoRGqMmHXzs877r96YZI/g2TaZXJsByPrxwjcd+8zykB
2npsRGCqbhBc7r67Uo1Q
=IqZZ
-----END PGP SIGNATURE-----

--------------enigF518B45BB791917387236BCA--
