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
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 |
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 |