Re: Upgrading from 9.1 to 9.2 in place, same machine

From: "ktm(at)rice(dot)edu" <ktm(at)rice(dot)edu>
To: Wells Oliver <wellsoliver(at)gmail(dot)com>
Cc: pgsql-admin(at)postgresql(dot)org
Subject: Re: Upgrading from 9.1 to 9.2 in place, same machine
Date: 2013-07-10 19:03:21
Message-ID: 20130710190321.GI3001@aart.rice.edu
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-admin

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

In response to

Browse pgsql-admin by date

  From Date Subject
Next Message Vincent Lau 2013-07-10 19:12:29 Re: Upgrading from 9.1 to 9.2 in place, same machine
Previous Message Wells Oliver 2013-07-10 19:02:06 Re: Upgrading from 9.1 to 9.2 in place, same machine