Re: pg_upgrade & tablespaces - Mailing list pgsql-general

From Joseph Kregloh
Subject Re: pg_upgrade & tablespaces
Date
Msg-id CAAW2xff5CurUD6AuR+5jU21JqrEYeLxvxbPAE1GoTZPLKxrpZw@mail.gmail.com
Whole thread Raw
In response to Re: pg_upgrade & tablespaces  (Bruce Momjian <bruce@momjian.us>)
Responses Re: pg_upgrade & tablespaces  (Bruce Momjian <bruce@momjian.us>)
List pgsql-general



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. 

pgsql-general by date:

Previous
From: Joseph Kregloh
Date:
Subject: Re: pg_upgrade & tablespaces
Next
From: sramay
Date:
Subject: Re: pg_largeobject related issue with 9.2