Received: from makus.postgresql.org (makus.postgresql.org [98.129.198.125]) by mail.postgresql.org (Postfix) with ESMTP id 2C02E2D0B10 for ; Fri, 10 Feb 2012 11:14:21 -0400 (AST) Received: from sd-17937.dedibox.fr ([88.191.100.74]) by makus.postgresql.org with esmtp (Exim 4.72) (envelope-from ) id 1RvsB2-00069e-Be for pgsql-admin@postgresql.org; Fri, 10 Feb 2012 15:14:21 +0000 Received: from [192.168.10.3] (AMontsouris-552-1-112-45.w92-140.abo.wanadoo.fr [92.140.119.45]) by sd-17937.dedibox.fr (Postfix) with ESMTPA id 864E63B92D; Fri, 10 Feb 2012 16:14:06 +0100 (CET) Message-ID: <1328886846.2155.39.camel@localhost.localdomain> Subject: Re: 32-bit to 64-bit migration options From: Guillaume Lelarge To: Greg Spiegelberg Cc: "[ADMIN]" Date: Fri, 10 Feb 2012 16:14:06 +0100 In-Reply-To: References: Content-Type: text/plain; charset="UTF-8" X-Mailer: Evolution 3.2.3 (3.2.3-1.fc16) Content-Transfer-Encoding: 7bit Mime-Version: 1.0 X-Pg-Spam-Score: -1.9 (-) X-Archive-Number: 201202/46 X-Sequence-Number: 39106 On Fri, 2012-02-10 at 07:45 -0700, Greg Spiegelberg wrote: > All, > > I'm planning a migration for a customer with a PostgreSQL 8.4 database > cluster running CentOS 4.8 32-bit. The target platform is CentOS 6.2 > 64-bit and will be running PostgreSQL 8.4 (our application delivers and > supports 8.4, don't bother bringing up 9.x). If this were a small database > cluster I wouldn't worry about it however the 8.4 database cluster is about > 900 GB right now. The documented and proper way to move this data is via a > dump-restore however I'm not sure my customer wants days or potentially > weeks of downtime so I'm searching for options. > > Option 1: dump-restore > I've performed a handful of these for other customers and even the 100 GB > database cluster using the network transfer method "pg_dumpall | ssh target > -c 'cat - | psql postgres'" can be slow as in 8+ hours. > Right. > Option 2: Slony-I > Is Slony-I an alternative when moving data from 32-bit to 64-bit? > Yes, absolutely. > Option 3: pg_upgrade > Is this an option? Remember, I'm going from 8.4 32-bit to 8.4 64-bit. > No because of the 32/64 bit change. > Option 4: PITR > I believe this is not a possibility because of the bit-ness change but I'm > listing anyways in case I'm mistaken. > No because of the 32/64 bit change. > Did I miss anything? > Well, you can also use Londiste, and probably Bucardo to do this. But I guess they are your only options with Slony. -- Guillaume http://blog.guillaume.lelarge.info http://www.dalibo.com