Changes between Version 23 and Version 24 of UsersWikiWinUpgrade


Ignore:
Timestamp:
07/24/13 17:07:54 (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

Legend:

Unmodified
Added
Removed
Modified

  • UsersWikiWinUpgrade

    v23 v24  
    44You need to do a hard upgrade if either:
    55 * You are using a pre-alpha release of a major release, like pre-release PostGIS 2.0.
    6  * You are upgrading from one major version to another, such as 0.* or 1.* to 2.*.
     6 * You are upgrading from one major version to another, such as 1.* to 2.*.
    77
    881. 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.
    … …  
    3131set PGPASSWORD=yourpasswordhere
    3232set THEDB=mydb
    33 set PGINSTALL=C:\Program Files (x86)\PostgreSQL\9.1
    34 REM note the below example is if you are on 32-bit windows choose which install path makes most sense
    35 REM set PGINSTALL=C:\Program Files\PostgreSQL\9.1\
    36 set PATH=%PATH%;"%PGINSTALL%\bin\"
    37 perl utils/postgis_restore.pl "mydb.backup" | psql %THEDB% 2> errors.txt
     33set BACKUPFILE=mydb.backup
     34set PGINSTALL=C:\Program Files\PostgreSQL\9.2
     35set PATH=%PATH%;"%PGINSTALL%\bin"
     36perl "%PGINSTALL%\utils\postgis_restore.pl" "%BACKUPFILE%" | psql %THEDB% 2> errors.txt
    3837pause
    3938}}}