Re: pg_upgrade & tablespaces

That is excellent news. I still have 3 more environments to upgrade, our
stage, pre-prod, and production environments in the next month or so. I
would be willing to test any fix you may have.

-Joseph

On Tue, Jan 21, 2014 at 7:02 PM, Bruce Momjian <bruce(at)momjian(dot)us> wrote:

> On Mon, Jan 13, 2014 at 09:23:09AM -0500, Joseph Kregloh wrote:
> >
> >
> >
> > Right. I know there were multiple issue with this upgrade, jails
> > probably being the biggest, but a new one I had never heard is that
> _if_
> > you are placing your tablespaces in the PGDATA directory, and you are
> > upgrading from pre-9.2, if you rename the old data directory, you
> also
> > need to start the old server and update pg_tablespace.spclocation.
> >
> >
> >
> > Just to have it on the record. I did the upgrade outside of the jail to
> make
> > sure. I also tested it within jails and it worked also.
>
> OK, good to know. I thought it was the jails because I had never heard
> of cross-jail upgrades, but the tablespace in PGDATA was the problem. I
> will work on a way to detect this in the coming weeks. It would affect
> all back branches, not just pre-9.2.
>
> --
> Bruce Momjian <bruce(at)momjian(dot)us> http://momjian.us
> EnterpriseDB http://enterprisedb.com
>
> + Everyone has their own god. +
>