Received: from malur.postgresql.org ([217.196.149.56]) by arkaria.postgresql.org with esmtp (Exim 4.80) (envelope-from ) id 1Uwzfi-0008OV-Bq for pgsql-admin@arkaria.postgresql.org; Wed, 10 Jul 2013 19:03:26 +0000 Received: from localhost ([127.0.0.1] helo=postgresql.org) by malur.postgresql.org with smtp (Exim 4.80) (envelope-from ) id 1Uwzfh-0005UJ-Ph for pgsql-admin@arkaria.postgresql.org; Wed, 10 Jul 2013 19:03:25 +0000 Received: from magus.postgresql.org ([2a02:c0:301:0:ffff::29]) by malur.postgresql.org with esmtp (Exim 4.80) (envelope-from ) id 1Uwzfg-0005Su-A8 for pgsql-admin@postgresql.org; Wed, 10 Jul 2013 19:03:24 +0000 Received: from proofpoint2.mail.rice.edu ([128.42.201.101] helo=pp2.rice.edu) by magus.postgresql.org with esmtp (Exim 4.80) (envelope-from ) id 1Uwzfb-00072K-SK for pgsql-admin@postgresql.org; Wed, 10 Jul 2013 19:03:24 +0000 Received: from pps.filterd (pp2.rice.edu [127.0.0.1]) by pp2.rice.edu (8.14.5/8.14.5) with SMTP id r6AAgB6H015657; Wed, 10 Jul 2013 14:03:17 -0500 Received: from mh2.mail.rice.edu (mh2.mail.rice.edu [128.42.201.21]) by pp2.rice.edu with ESMTP id 1ddpt1j6kp-1; Wed, 10 Jul 2013 14:03:17 -0500 X-Virus-Scanned: by amavis-2.7.0 at mh2.mail.rice.edu, auth channel X-SMTP-Auth: no X-SMTP-Auth: no Received: from aart.rice.edu (aart.rice.edu [168.7.56.48]) by mh2.mail.rice.edu (Postfix) with ESMTP id EB2145002C9; Wed, 10 Jul 2013 14:03:16 -0500 (CDT) Received: by aart.rice.edu (Postfix, from userid 18612) id 13EDE100720; Wed, 10 Jul 2013 14:03:21 -0500 (CDT) Date: Wed, 10 Jul 2013 14:03:21 -0500 From: "ktm@rice.edu" To: Wells Oliver Cc: pgsql-admin@postgresql.org Subject: Re: Upgrading from 9.1 to 9.2 in place, same machine Message-ID: <20130710190321.GI3001@aart.rice.edu> References: MIME-Version: 1.0 Content-Type: text/plain; charset=us-ascii Content-Disposition: inline In-Reply-To: User-Agent: Mutt/1.5.20 (2009-12-10) X-Pg-Spam-Score: -2.2 (--) List-Archive: List-Help: List-ID: List-Owner: List-Post: List-Subscribe: List-Unsubscribe: X-Mailing-List: pgsql-admin Precedence: bulk Sender: pgsql-admin-owner@postgresql.org On Wed, Jul 10, 2013 at 11:52:54AM -0700, Wells Oliver wrote: > Can anyone speak to the speed of pg_upgrade? Our database is 153GB. From > 9.1 to 9.2, I'm nervous it might take hours. If it were less than hour, > downtime would be more acceptable. > You can use the --link option and then you make hard links instead of requiring a copy of the data files. It should be pretty fast. Without --link a copy of 153GB could take a while. :) http://www.postgresql.org/docs/9.2/interactive/pgupgrade.html Ken -- Sent via pgsql-admin mailing list (pgsql-admin@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-admin