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

Поиск
Список
Период
Сортировка
От lxnf98mm@gmail.com
Тема Re: Upgrading from 9.1 to 9.2 in place, same machine
Дата
Msg-id alpine.LRH.2.00.1307101543010.27106@rray.drdc.mstc.ms.gov
обсуждение исходный текст
Ответ на Re: Upgrading from 9.1 to 9.2 in place, same machine  (Vincent Lau <vincent.lau@rentrakmail.com>)
Ответы Re: Upgrading from 9.1 to 9.2 in place, same machine  ("ktm@rice.edu" <ktm@rice.edu>)
Список pgsql-admin
On Wed, 10 Jul 2013, Vincent Lau wrote:

> On Wed, Jul 10, 2013 at 12:19 PM, Wells Oliver <wellsoliver@gmail.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@rice.edu <ktm@rice.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@gmail.com
>>
>
>
>
> --
> Vincent Lau | Database Administrator
> 503.284.7581 x394 | vincent.lau@rentrak.com <vincent.lau@rentrakmail.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?


В списке pgsql-admin по дате отправления:

Предыдущее
От: Vincent Lau
Дата:
Сообщение: Re: Upgrading from 9.1 to 9.2 in place, same machine
Следующее
От: "ktm@rice.edu"
Дата:
Сообщение: Re: Upgrading from 9.1 to 9.2 in place, same machine