135 | | Download and run the PostgreSQL installer from [http://www.postgresql.org/ftp/binary/v8.2.4/win32/ here]. Do '''not''' install the PostGIS version bundled with this installer. The latest version of PostgreSQL is 8.2.4. |
| 135 | Download and run the PostgreSQL installer from [http://www.postgresql.org/ftp/binary/v8.2.4/win32/ here]. Do '''not''' install the PostGIS version bundled with this installer. The latest version of PostgreSQL is 8.2.5. |
| 136 | |
| 137 | If you want to invoke PostgreSQL commands from the shell, append "{{{;C:\Program Files\PostgreSQL\8.2\bin}}}" to the Windows {{{Path}}}. |
| 138 | |
| 139 | === PostGIS === |
| 140 | |
| 141 | PostGIS maintains a [http://postgis.refractions.net/download/windows/ distribution for Windows], and includes pre-built libraries for PROJ 4.5.0 and GEOS 3.0.0rc4 (both are the latest versions). You may download the latest [http://postgis.refractions.net/download/windows/pg82/postgis-pg82-setup-1.3.1-1.exe PostGIS (1.3.1) here]. Run this ''after'' the PostgreSQL installer. |
| 142 | |
| 143 | If you added the directory to PostgreSQL to your {{{Path}}} (see above), the following command may be used to easily create spatial databases: |
| 144 | {{{ |
| 145 | C:\> createdb -T template_postgis <database name> |
| 146 | }}} |