From: | Wells Oliver <wellsoliver(at)gmail(dot)com> |
---|---|
To: | pgsql-admin(at)postgresql(dot)org |
Subject: | Re: Upgrading from 9.1 to 9.2 in place, same machine |
Date: | 2013-07-10 19:02:06 |
Message-ID: | CAOC+FBXx6_HjU_2WN8t=2g1YNoeQHHXF3b6he3AHAGgQ3W88Cw@mail.gmail.com |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-admin |
Hard linking means that you must maintain 8.2's data directory though, even
after upgrade, correct? Since it's a link and not a copied file.
On Wed, Jul 10, 2013 at 11:59 AM, Vincent Lau
<vincent(dot)lau(at)rentrakmail(dot)com>wrote:
> We did an in-place upgrade(with the -k option) against a 6Tb DB from 8.4
> to 9.2. It took all of 10 minutes to complete, which didn't count for
> running the analyze afterward. However, if you are going to run the analyze
> DB afterward, your mileage may vary.
>
>
> On Wed, Jul 10, 2013 at 11:52 AM, Wells Oliver <wellsoliver(at)gmail(dot)com>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.
>>
>>
>> On Wed, Jul 10, 2013 at 11:08 AM, Jonathan Nalley <jnalley(at)jnalley(dot)com>wrote:
>>
>>> On Wed, Jul 10, 2013 at 1:53 PM, Wells Oliver <wellsoliver(at)gmail(dot)com>
>>> wrote:
>>> > I have 9.1 running on 5432, and 9.2 running on 5433. The 9.1 database
>>> size
>>> > is 153g. 9.1 is actively used by systems, 9.2 is just sitting there
>>> empty.
>>> >
>>> > I'd like to move the 9.1 database to 9.2 without any down time, and
>>> ensuring
>>> > that no data is lost.
>>> >
>>> > My original idea was to make 9.2 a slave of 9.1, then switch it over.
>>> >
>>> > Is there a better idea? Thanks for any tips.
>>>
>>> have you looked at simply using pg_upgrade ?
>>>
>>> http://www.postgresql.org/docs/9.2/static/pgupgrade.html
>>>
>>>
>>> >
>>> > --
>>> > Wells Oliver
>>> > wellsoliver(at)gmail(dot)com
>>>
>>>
>>> --
>>> Sent via pgsql-admin mailing list (pgsql-admin(at)postgresql(dot)org)
>>> To make changes to your subscription:
>>> http://www.postgresql.org/mailpref/pgsql-admin
>>>
>>
>>
>>
>> --
>> Wells Oliver
>> wellsoliver(at)gmail(dot)com
>>
>
>
>
> --
> Vincent Lau | Database Administrator
> 503.284.7581 x394 | vincent(dot)lau(at)rentrak(dot)com <vincent(dot)lau(at)rentrakmail(dot)com>
> RENTRAK | www.rentrak.com | NASDAQ: RENT
>
> Notice: This message is confidential and is intended only for the
> recipient(s) named above. If you have received this message in error,
> or are not the named recipient(s), please immediately notify the
> sender and delete this message.
>
--
Wells Oliver
wellsoliver(at)gmail(dot)com
From | Date | Subject | |
---|---|---|---|
Next Message | ktm@rice.edu | 2013-07-10 19:03:21 | Re: Upgrading from 9.1 to 9.2 in place, same machine |
Previous Message | Vincent Lau | 2013-07-10 18:59:14 | Re: Upgrading from 9.1 to 9.2 in place, same machine |