Installing & Setting Up PostgreSQL With PostGIS
Author: Dan Blomberg | Last updated February 13th, 2010 at 01:06pm
This tutorial will guide you through the steps involved with installing PostgreSQL and PostGIS on your Windows based PC. PostGIS is a requirement for the way GPSFileDepot creates Garmin compatible maps.
This tutorial last updated for version 8.4.3.
- Go the the PostgreSQL windows downloads.
- Download the "one click installer".
- Click windows on the EnterpriseDB page.
- Run the .exe that has been downloaded to install PostgreSQL.
- The default install directories should be good. When prompted enter a password that you can remember.
- The normal settings should be good.
- Make sure the "Launch Stack Builder at exist?" box is unchecked and click finish.
- Now we will make it so you can connect without a password (this is optional but makes life easier)
- Stop the service from running: (start>all programs> postgresql X.X>Stop Service)
- Open pg_hba.conf (start>all programs>postgresql X.X>Configurations Files>Edit pg_hba.conf
Note: In v 8.4+ you have to access the pg_hba.conf by browsing to the PostgreSQL folder, then version number, then data and then open pg_hba.conf
- Change the line reading:
host all all 127.0.0.1/32 md5
host all all 127.0.0.1/32 trust
If you use IPv6 change the next line below it as well.
- Reload the configuration files (start>all programs>postgresql X.X>Reload configuration)
- Restart the server (start>all programs>postgresql X.X>Restart Server)
- Start the Application Stack Builder (in PostgreSQL's start menu)
- Select your local server:
- Under "Spatial Extensions" check the most recent version of PostGIS:
- Pick a server near you and click "Next"
- Leave the download location alone and click "Next"
- After the download finishes click next to start installing.
Note: In windows 7 I ran into an "elevation" problem. Due to this I had to go to the location where the file was download (in my case the Temp directory) and right click on the PostGIS_1_4_gp84.exe and select run as administrator.
- Make sure create spatial database is checked.
- Leave the default options. Make sure you enter your password if needed.
Now you should have a fully operational postgis database.
Creating More Databases
You may, at some point, need to create more postGIS databases. In this case you need to create them with a template file.
- Open pgAdmin III
- Connect to your local server
- Right click on databases and click "New Database..."
- Enter a name for your new database
- Select the username you've been using as the owner (default is "postgres")
- For the template select "template_postgis"
- Click okay.
A new database has now been created. You have to use a template in order to have it be a spatial database.