Re: Upgrading from 9.1 to 9.2 in place, same machine - Mailing list pgsql-admin

From Vincent Lau
Subject Re: Upgrading from 9.1 to 9.2 in place, same machine
Date
Msg-id CAF_O_rmv5h-Po=X4CE8LHCUYg8gJyE9XZ1DZZmkhXtah6+W88Q@mail.gmail.com
Whole thread Raw
In response to Re: Upgrading from 9.1 to 9.2 in place, same machine  (Wells Oliver <wellsoliver@gmail.com>)
Responses Re: Upgrading from 9.1 to 9.2 in place, same machine  (lxnf98mm@gmail.com)
List pgsql-admin
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
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.

pgsql-admin by date:

Previous
From: Wells Oliver
Date:
Subject: Re: Upgrading from 9.1 to 9.2 in place, same machine
Next
From: lxnf98mm@gmail.com
Date:
Subject: Re: Upgrading from 9.1 to 9.2 in place, same machine