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

From: lxnf98mm(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 20:46:28
Message-ID: alpine.LRH.2.00.1307101543010.27106@rray.drdc.mstc.ms.gov
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-admin

On Wed, 10 Jul 2013, Vincent Lau wrote:

> On Wed, Jul 10, 2013 at 12:19 PM, Wells Oliver <wellsoliver(at)gmail(dot)com>wrote:
>
>> OK, cool. I did not want to be in a position where I stop the servers,
>> pg_upgrade --link 9.1 to 9.2, then (eventually) pg_dropcluster of 9.1 and,
>> woops, I killed all of my data files.
>>
>>
> And if you have enough storage, you can always stage a testing environment
> and test this out. It'd tell you how long the whole upgrade would take too.
> :)
>
>
>
>>
>> On Wed, Jul 10, 2013 at 12:13 PM, ktm(at)rice(dot)edu <ktm(at)rice(dot)edu> wrote:
>>
>>> On Wed, Jul 10, 2013 at 12:02:06PM -0700, Wells Oliver wrote:
>>>> 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.
>>>>
>>> I think it only hard links the files to the new 9.2 data directory so you
>>> can delete the old data directory and the files will still be in the new
>>> directory since the link count will be > 0.
>>>
>>> Ken
>>>
>>
>>
>>
>> --
>> 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.
>

how would pg_upgrade be used to upgrade to a new machine
use nfs?
would i run pg_upgrade on the new server?

In response to

Responses

Browse pgsql-admin by date

  From Date Subject
Next Message ktm@rice.edu 2013-07-10 21:02:03 Re: Upgrading from 9.1 to 9.2 in place, same machine
Previous Message Vincent Lau 2013-07-10 19:24:38 Re: Upgrading from 9.1 to 9.2 in place, same machine