Changes between Initial Version and Version 1 of UsersWikiWinUpgrade


Ignore:
Timestamp:
12/20/11 08:20:38 (13 years ago)
Author:
robe
Comment:

--

Legend:

Unmodified
Added
Removed
Modified
  • UsersWikiWinUpgrade

    v1 v1  
     1== CLEAN HARD UPGRADE ON WINDOWS ==
     2General Hard upgrade instructions are documented in [http://www.postgis.org/documentation/manual-svn/postgis_installation.html#hard_upgrade PostGIS Hard Upgrade]
     3
     4You need to do a hard upgrade if you are using a pre-alpha release of a major release such as the case with PostGIS 2.0
     5or you are upgrading from one major version to another e.g 0.*, 1.* --> 2.*
     6
     7* If you don't have perl on your windows box, download [http://www.activestate.com/activeperl/downloads ActivePerl] and install.  You can use the 64-bit or 32-bit version even if you are using 32-bit PostgreSQL. [http://www.activestate.com/activeperl/downloads].
     8When prompted to do so, choose to add Perl to your environment path and map to .pl scripts.
     9
     10Note that ActivePerl also has packages for MacOS, Linux, but is generally not necessary for those platforms since they come prepackaged with perl.
     11
     12* Create an upgrade.bat file with contents something like this:
     13{{{
     14set PGPORT=5433
     15set PGHOST=localhost
     16set PGUSER=postgres
     17set PGPASSWORD=yourpasswordhere
     18set THEDB=dnddts20
     19set PGINSTALL=C:\Program Files (x86)\PostgreSQL\9.1
     20REM note the below example is if you are on 32-bit windows choose which install path makes most sense
     21REM set PGINSTALL=C:\Program Files\PostgreSQL\9.1\
     22set PGADMIN=%PGINSTALL%\pgAdmin III
     23set PGBIN=%PGINSTALL%\bin\
     24set PGLIB=%PGINSTALL%\lib\
     25set POSTGISVER=2.0
     26set PATH=%PATH%;"%PGINSTALL%\bin\"
     27perl utils/postgis_restore.pl "dnddts_daily.backup" | psql %THEDB% 2> errors.txt
     28pause
     29}}}
     30
     31* Right mouse click on the .bat file (you may have to choose -- Run as Administrator)