Postgresql+postgis+pgrouting Installation Step diagram

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