On Mon, Jan 13, 2014 at 09:17:41AM -0500, Joseph Kregloh wrote: > > > > 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? This will be fixed in the next 9.3 minor release by throwing ane error for non-existent tablespace directores. -- Bruce Momjian <bruce@xxxxxxxxxx> http://momjian.us EnterpriseDB http://enterprisedb.com + Everyone has their own god. + -- Sent via pgsql-general mailing list (pgsql-general@xxxxxxxxxxxxxx) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-general