Re: pg_upgrade & tablespaces - Mailing list pgsql-general

From John R Pierce
Subject Re: pg_upgrade & tablespaces
Date
Msg-id 52B35E4D.9020400@hogranch.com
Whole thread Raw
In response to Re: pg_upgrade & tablespaces  (Bruce Momjian <bruce@momjian.us>)
List pgsql-general
On 12/19/2013 12:53 PM, Bruce Momjian wrote:
>> Currently I am testing on the development database which is only 100GB with a
>> >same number of tablespaces. I am working on FreeBSD with jails. So one jail
>> >contains 9.0 and the other 9.3. In the 93 jail I mount the data and binary
>> >directories for the 9.0 jail.
> Why don't you do run pg_upgrade in the same jail then just move the
> files over to the new jail?  That should work better.  I am unclear how
> a cross-jail upgrade would work at all.

or just leave the 9.3 in the 'postgres' jail, which to me makes as much
sense as anything.

80 tablespaces is a mess no matter how you slice it.



--
john r pierce                                      37N 122W
somewhere on the middle of the left coast



pgsql-general by date:

Previous
From: Bruce Momjian
Date:
Subject: Re: pg_upgrade & tablespaces
Next
From: Joseph Kregloh
Date:
Subject: Re: pg_upgrade & tablespaces