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