Changes between Version 23 and Version 24 of UsersWikiWinUpgrade

Timestamp:

Jul 24, 2013, 5:07:54 PM (11 years ago)

Author:

Mike Taves

Comment:

update PGINSTALL to typical 9.2 installation, which can be a native 64-bit; add a BACKUPFILE variable, and properly use path to postgis_restore.pl

UsersWikiWinUpgrade

@@ -4 +4 @@
 You need to do a hard upgrade if either:
  * You are using a pre-alpha release of a major release, like pre-release PostGIS 2.0.
- * You are upgrading from one major version to another, such as 0.* or 1.* to 2.*.
+ * You are upgrading from one major version to another, such as 1.* to 2.*.
 
 1. Create a backup of your postgis database as usual.  You can do this with pg_dump as the instructions describe or !PgAdmin III by right-clicking on the database -> Backup.  Make sure to use "Custom" backup for format if you are using !PgAdmin III.
@@ -31 +31 @@
 set PGPASSWORD=yourpasswordhere
 set THEDB=mydb
-set PGINSTALL=C:\Program Files (x86)\PostgreSQL\9.1
-REM note the below example is if you are on 32-bit windows choose which install path makes most sense
-REM set PGINSTALL=C:\Program Files\PostgreSQL\9.1\
-set PATH=%PATH%;"%PGINSTALL%\bin\"
-perl utils/postgis_restore.pl "mydb.backup" | psql %THEDB% 2> errors.txt
+set BACKUPFILE=mydb.backup
+set PGINSTALL=C:\Program Files\PostgreSQL\9.2
+set PATH=%PATH%;"%PGINSTALL%\bin"
+perl "%PGINSTALL%\utils\postgis_restore.pl" "%BACKUPFILE%" | psql %THEDB% 2> errors.txt
 pause
 }}}