Re: pg_upgrade & tablespaces

On Fri, Jan 10, 2014 at 11:53 AM, Adrian Klaver <adrian(dot)klaver(at)gmail(dot)com>wrote:

> On 01/10/2014 08:40 AM, Joseph Kregloh wrote:
>
>> Just as a followup to this. The process that I am using to do the
>> upgrade is as follows:
>>
>> 1. Install Postgres 9.3 in /opt dir.
>> 2. In 9.0 instance update spclocation in pg_tablespace.
>> 3. Update the symlinks in the pg_tblspace folder.
>> 4. Move the tablespace folders to new location.
>> 5. Run pg_upgrade.
>> 6. Test upgrade results on 9.3 cluster.
>> 7. Run the sh files created by pg_upgrade.
>> 8. Uninstall Postgres 9.3 in /opt dir.
>> 9. Install Postgres 9.3 in default location.
>> 10. Enjoy Postgres 9.3.
>>
>
> For completeness, the new location you are moving the tablespaces to, is
> that in or out of $PGDATA?
>
>
The new location is /usr/local/pgsql/tablespaces/

> FYI, from comments over on --hackers, I believe Bruce Momjian may offer
> some insight on what is going on.
>
>
>> I could actually move the 9.0 cluster after moving the table spaces and
>> install 9.3 in the default location as the documentation shows. But I
>> haven't experimented with that scenario yet.
>>
>> -Joseph
>>
>>
>>
>
> --
> Adrian Klaver
> adrian(dot)klaver(at)gmail(dot)com
>