pg.ddx.io  pgsql-admin@postgresql.org mailing list archive  
help / color / mirror / Atom feed
From: lxnf98mm@gmail.com
To: pgsql-admin@postgresql.org
Subject: Re: Upgrading from 9.1 to 9.2 in place, same machine
Date: Wed, 10 Jul 2013 15:46:28 -0500 (CDT)
Message-ID: <alpine.LRH.2.00.1307101543010.27106@rray.drdc.mstc.ms.gov> (raw)
In-Reply-To: <CAF_O_rmv5h-Po=X4CE8LHCUYg8gJyE9XZ1DZZmkhXtah6+W88Q@mail.gmail.com>
References: <CAOC+FBUZL60+OzFXoQZFRL42Zn2DDkyhmmOUx3SKE4Xv1y=eYQ@mail.gmail.com>
	<CAEiqQGbcHAqYvoGh2XnMD+n2UG57Dk7b0861te5go+ye7mHgPA@mail.gmail.com>
	<CAOC+FBXwnwoE076-o2Xnph9qOi_monAeK9f3-RQjUx4TyOsLWQ@mail.gmail.com>
	<CAF_O_rk911-_3wVTtvyhndHR+80XDyS-h0v4LPaT6OXe8VC3CA@mail.gmail.com>
	<CAOC+FBXx6_HjU_2WN8t=2g1YNoeQHHXF3b6he3AHAGgQ3W88Cw@mail.gmail.com>
	<20130710191323.GJ3001@aart.rice.edu>
	<CAOC+FBXBoAvjTwCbANK-jmUm-3nACyZn_ccmncC91RutwiP2QQ@mail.gmail.com>
	<CAF_O_rmv5h-Po=X4CE8LHCUYg8gJyE9XZ1DZZmkhXtah6+W88Q@mail.gmail.com>
List-Unsubscribe: <mailto:majordomo@postgresql.org?body=unsub%20pgsql-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?


-- 
Sent via pgsql-admin mailing list (pgsql-admin@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-admin



view thread (15+ messages)  latest in thread

Message-ID: <alpine.LRH.2.00.1307101543010.27106@rray.drdc.mstc.ms.gov>
Permalink:  ../alpine.LRH.2.00.1307101543010.27106@rray.drdc.mstc.ms.gov/
Also on:    postgresql.org/message-id/alpine.LRH.2.00.1307101543010.27106@rray.drdc.mstc.ms.gov

 · 

reply

Reply instructions:

You may reply publicly to this message via plain-text email
using any one of the following methods:

* Reply to all the recipients from your mail client; the link fills in
  the headers below: reply via email
  Some clients, webmail especially, drop In-Reply-To and References from
  a link, and the reply then starts a new thread: use the mbox below.

  To: pgsql-admin@postgresql.org
  Cc: lxnf98mm@gmail.com
  Subject: Re: Upgrading from 9.1 to 9.2 in place, same machine
  In-Reply-To: <alpine.LRH.2.00.1307101543010.27106@rray.drdc.mstc.ms.gov>
  References: <CAOC+FBUZL60+OzFXoQZFRL42Zn2DDkyhmmOUx3SKE4Xv1y=eYQ@mail.gmail.com> <CAEiqQGbcHAqYvoGh2XnMD+n2UG57Dk7b0861te5go+ye7mHgPA@mail.gmail.com> <CAOC+FBXwnwoE076-o2Xnph9qOi_monAeK9f3-RQjUx4TyOsLWQ@mail.gmail.com> <CAF_O_rk911-_3wVTtvyhndHR+80XDyS-h0v4LPaT6OXe8VC3CA@mail.gmail.com> <CAOC+FBXx6_HjU_2WN8t=2g1YNoeQHHXF3b6he3AHAGgQ3W88Cw@mail.gmail.com> <20130710191323.GJ3001@aart.rice.edu> <CAOC+FBXBoAvjTwCbANK-jmUm-3nACyZn_ccmncC91RutwiP2QQ@mail.gmail.com> <CAF_O_rmv5h-Po=X4CE8LHCUYg8gJyE9XZ1DZZmkhXtah6+W88Q@mail.gmail.com> <alpine.LRH.2.00.1307101543010.27106@rray.drdc.mstc.ms.gov>

* Save the following mbox file, import it into your mail client,
  and reply-to-all from there: mbox

This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox