Received: from localhost (unknown [200.46.204.184]) by postgresql.org (Postfix) with ESMTP id 6E9D09F9AD8 for ; Fri, 21 Sep 2007 09:30:17 -0300 (ADT) Received: from postgresql.org ([200.46.204.71]) by localhost (mx1.hub.org [200.46.204.184]) (amavisd-maia, port 10024) with ESMTP id 11128-01 for ; Fri, 21 Sep 2007 09:29:52 -0300 (ADT) X-Greylist: from auto-whitelisted by SQLgrey-1.7.5 Received: from achille.dalibo.net (achille.dalibo.net [212.85.153.230]) by postgresql.org (Postfix) with ESMTP id 7DA009F9B09 for ; Fri, 21 Sep 2007 09:29:59 -0300 (ADT) Received: from localhost (localhost.localdomain [127.0.0.1]) by achille.dalibo.net (Postfix) with ESMTP id D5DCE62CFB; Fri, 21 Sep 2007 14:29:53 +0200 (CEST) Received: from achille.dalibo.net ([127.0.0.1]) by localhost (achille [127.0.0.1]) (amavisd-new, port 10024) with ESMTP id 32263-05; Fri, 21 Sep 2007 14:29:52 +0200 (CEST) Received: from asterix.local (lan31-6-82-238-146-117.fbx.proxad.net [82.238.146.117]) by achille.dalibo.net (Postfix) with ESMTP id 984D762CF5; Fri, 21 Sep 2007 14:29:52 +0200 (CEST) From: =?iso-8859-1?q?C=E9dric_Villemain?= Organization: dalibo.com To: pgsql-admin@postgresql.org Subject: Re: Moving database install to new SAN Date: Fri, 21 Sep 2007 14:29:42 +0200 User-Agent: KMail/1.9.7 Cc: "Joshua D. Drake" , Chris Hoover , Andrzej Zawadzki References: <507905.14268.qm@web57114.mail.re3.yahoo.com> <1d219a6f0709201110r603e1d4dg8cc4f514201a65ab@mail.gmail.com> <46F2B8E6.4010108@commandprompt.com> In-Reply-To: <46F2B8E6.4010108@commandprompt.com> MIME-Version: 1.0 Content-Type: multipart/signed; boundary="nextPart2280952.xEcczYEdGj"; protocol="application/pgp-signature"; micalg=pgp-sha1 Content-Transfer-Encoding: 7bit Message-Id: <200709211429.47837.cedric.villemain@dalibo.com> X-Virus-Scanned: by amavisd-new-20030616-p10 (Debian) at dalibo.com X-Virus-Scanned: Maia Mailguard 1.0.1 X-Archive-Number: 200709/131 X-Sequence-Number: 26892 --nextPart2280952.xEcczYEdGj Content-Type: text/plain; charset="iso-8859-1" Content-Transfer-Encoding: quoted-printable Content-Disposition: inline Le jeudi 20 septembre 2007, Joshua D. Drake a =E9crit=A0: > Chris Hoover wrote: > >>> 2. copy whole data directory over to new SAN > >> > >> If database is big, then I think that is much faster to copy running > >> database > >> to new SAN. > >> Then stop postgres and rsync what was changed - but this will be > >> probably only a few files. > > > > I believe if you do this, you will not get a function database in the > > end. There is a lot of data that is held in memory/buffers that may not > > be flushed to the disks. You have no guarantee you will get this data > > with this method. > > The method would work if they are willing to have an outage. Basically > you do an initial rsync of the large db... Perhaps using some tablespace to move the bigest data, then rsync ... > > Then you shut down the db. > > And rsync again, which will be faster than doing a complete move with > shutdown. > > The key here is, if you use this method... there is *zero* way around > shutting down the database before the second rsync. > > > Sincerely, > > Joshua D. Drake =2D-=20 C=E9dric Villemain Administrateur de Base de Donn=E9es Cel: +33 (0)6 74 15 56 53 http://dalibo.com - http://dalibo.org --nextPart2280952.xEcczYEdGj Content-Type: application/pgp-signature; name=signature.asc Content-Description: This is a digitally signed message part. -----BEGIN PGP SIGNATURE----- Version: GnuPG v1.4.6 (GNU/Linux) iD8DBQBG87k7o/dppWjpEvwRArbUAJ9l9vWjwbfrNOX0NTLU0GoNLpp7WgCgqdqI 2l/EPI0ZtWmbo6AydDDSxdU= =ewoC -----END PGP SIGNATURE----- --nextPart2280952.xEcczYEdGj--