Re: pg_upgrade & tablespaces

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