1. Download PostgreSQL (open source database, recommended by GIS Industry) here (https://www.bigsql.org/postgresql/installers.jsp/);
2. Download the PostGIS (PostgreSQL database GIS spatial database plugin) corresponding to PostgreSQL version (http://winnie.postgis.net/download/windows/pg94/) here.
3. The pgrounting (Spatial database path analysis plug-in) can be found under the second step path.
Diagram of installation steps:
1. Click the PostgreSQL installation file:
2. Select the installation path:
3. Select the storage data path:
4. Set the Super Administrator password:
5. Select the port:
6. Using the scene, select C:
7. Default Next:
8. Installation process:
9. Complete the installation and uncheck the check box:
10. Open the PostGIS cocoa installation file:
11. Create a new spatial database with the new spatial database once as a template:
12. Default and PostgreSQL same directory (default installation pgrouting2.0):
13. Login to PostgreSQL:
14. Create a spatial database:
15. The following three prompts appear, by default, "Yes" is selected:
16. Complete the installation:
17. Login Pgadmin III:
18. Create New spatial data:
19. To install is to create the database as a template:
20. Use the PostGIS tool to upload shp to the database:
21. Connect to PostgreSQL:
22.ADD file Add shp files (modify Srid to 4326 or corresponding spatial reference):
23. Modify the character encoding in order to support Chinese:
24. Import:
25. View the Import data:
26.pgrouting default following PostGIS installation, if you need to install pgrouting, just download the corresponding zip package, bin,lib,shared three folders to overwrite the PostgreSQL installation path.
Postgresql+postgis+pgrouting Installation Step diagram