Re: pg_upgrade & tablespaces

From: Joseph Kregloh <jkregloh(at)sproutloud(dot)com>
To: Adrian Klaver <adrian(dot)klaver(at)gmail(dot)com>
Cc: John R Pierce <pierce(at)hogranch(dot)com>, pgsql-general <pgsql-general(at)postgresql(dot)org>
Subject: Re: pg_upgrade & tablespaces
Date: 2013-12-23 14:45:28
Message-ID: CAAW2xfeyx3hC-Fz_b7AjKZGbhf29_iSz5b3_PbrcUT_zdAWnjA@mail.gmail.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general pgsql-hackers

>
> And /usr/local/pgsql was re-initdbed with a 9.0 cluster, because
> previously it was the 9.3 cluster?
>
> And you are sure /usr/local/bin has the 9.3 binaries?
>
> Personally I would say at this point the relationships between versions
> are so confused it would seem best to start from scratch.
>
> My suggestions:
>
> 1) Create a new jail with a copy of the test 9.0 cluster located in
> /usr/local/pgsql.
>
> 2) In that jail install a new 9.3 cluster using the --prefix= switch to
> configure to have it install in a different location in the jail.
>
> 3) Use pg_upgrade.
>
>
>
Before every test I do a ZFS rollback which resets all data on the disk
back to the last snapshot. So essentially every time it's dealing with a
new install. However I will give a try your suggestions that you had in
your next email (I can see into the future) and report back.

-Thanks

In response to

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Joseph Kregloh 2013-12-23 14:50:31 Re: pg_upgrade & tablespaces
Previous Message Dinesh Kumar 2013-12-23 09:14:35 Re: [pgadmin-support] Database has been killed after increasing memory

Browse pgsql-hackers by date

  From Date Subject
Next Message Joseph Kregloh 2013-12-23 14:50:31 Re: pg_upgrade & tablespaces
Previous Message Andres Freund 2013-12-23 12:56:32 Re: preserving forensic information when we freeze