Time for action – installing PostgreSQL and PostGIS
We are going to transform the census data from shapefile to a PostGIS table. Unless you already have a PostGIS installation, we will first need to build it up. You can install PostGIS in several ways, and official and user documentation on customized installation is widely available. In order to get you started, we will use nice packages freely distributed from EnterpriseDB™. Apart from choosing the proper binary package, installation runs the same way on Linux or Windows.
The entry point for download is located at http://enterprisedb.com/downloads/postgres-postgresql-downloads. The PostgreSQL column contains links to the binary packages for Windows and Linux; choose one and download it.
Run the installer.
You can go with the default Installation Directory:
Go with the default Data Directory too:
You can keep things simple on your development box; set postgres as your Password:
Don't change the default listening port unless you know it is already...