On Fri, Jan 10, 2014 at 11:53 AM, Adrian Klaver <adrian.klaver@xxxxxxxxx> 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.klaver@xxxxxxxxx
