| From: | Joseph Kregloh <jkregloh(at)sproutloud(dot)com> |
|---|---|
| To: | Bruce Momjian <bruce(at)momjian(dot)us> |
| Cc: | Adrian Klaver <adrian(dot)klaver(at)gmail(dot)com>, Jeff Janes <jeff(dot)janes(at)gmail(dot)com>, John R Pierce <pierce(at)hogranch(dot)com>, pgsql-general <pgsql-general(at)postgresql(dot)org> |
| Subject: | Re: pg_upgrade & tablespaces |
| Date: | 2014-01-13 14:23:09 |
| Message-ID: | CAAW2xff5CurUD6AuR+5jU21JqrEYeLxvxbPAE1GoTZPLKxrpZw@mail.gmail.com |
| Views: | Whole Thread | Raw Message | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-general pgsql-hackers |
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.
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Tom Lane | 2014-01-13 15:21:10 | Re: How to specify/mock the statistic data of tables in PostgreSQL |
| Previous Message | Joseph Kregloh | 2014-01-13 14:17:41 | Re: pg_upgrade & tablespaces |
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Oleg Bartunov | 2014-01-13 14:30:27 | Re: nested hstore patch |
| Previous Message | Joseph Kregloh | 2014-01-13 14:17:41 | Re: pg_upgrade & tablespaces |