Re: Installing/Upgrading PostgreSQL 9.1.6 to 9.3 knownbugs? - Mailing list pgsql-bugs

From
Subject Re: Installing/Upgrading PostgreSQL 9.1.6 to 9.3 knownbugs?
Date
Msg-id 20131008091226.5a830134ae84016b0174832fdc1a3173.defaaf6bd0.wbe@email11.secureserver.net
Whole thread Raw
List pgsql-bugs
We shouldn't have a problem with using pg_upgrade with the hard link option to upgrade from postgreSQL 9.1.6 after I get the spatial component upgraded to postgis 2.1, then straight to postgreSQL 9.3, Right?

thanks

-------- Original Message --------
Subject: Re: [BUGS] Installing/Upgrading PostgreSQL 9.1.6 to 9.3 known
bugs?
From: Bruce Momjian <bruce@momjian.us>
Date: Tue, October 08, 2013 6:17 am
To: fburgess@radiantblue.com
Cc: pgsql-bugs@postgresql.org

On Mon, Oct 7, 2013 at 08:07:42AM -0700, fburgess@radiantblue.com wrote:
> Bruce, Proposed Steps. Do they look feasible?
>
> 1.) pg_dump -h localhost -p 5432 -U postgres -Fc -b -v -f "/somepath/
> testdb.backup" testdb
> 2.) CREATE DATABASE newdb TEMPLATE=template_postgis;
> 3.) perl ../postgis-postgres/postgis-2.1.1/utils/postgis_restore.pl "/somepath/
> testdb.backup" | psql -h localhost -p 5432 -U postgres newdb 2> errors.txt <-
> this step may run 5-6 days, since our backup runs that long, right?
> 4.) At this point we will have two 6.1TB databases, so it looks like a
> prerequisite is to have available double the db size in disk space, right?
> 5.) then if no critical errors, there will be errors since we have our testdb
> schema in the public folder
> 5a.) ALTER DATABASE testdb RENAME TO olddb;
> 5b.) ALTER DATABASE newdb RENAME TO testdb;
> 6.) At this point hopefully we should be upgraded from postgis 1.5.3 to postgis
> 2.1.1, with PostgreSQL 9.1.6
> 7.) then can we just use pg_upgrade with the hard links option, instead of
> copying files to the new cluster option to upgrade to PostgreSQL 9.3?

Sorry, I have no idea how to upgrade PostGIS.

--
Bruce Momjian <bruce@momjian.us> http://momjian.us
EnterpriseDB http://enterprisedb.com

+ It's impossible for everything to be true. +


--
Sent via pgsql-bugs mailing list (pgsql-bugs@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-bugs

pgsql-bugs by date:

Previous
From: Bruce Momjian
Date:
Subject: Re: Installing/Upgrading PostgreSQL 9.1.6 to 9.3 known bugs?
Next
From: Bruce Momjian
Date:
Subject: Re: BUG #8467: Slightly confusing pgcrypto example in docs