Road Works GIS stack setup
The Road Works plugin requires GIS stack. Before running the plugin, follow the steps below to set up GIS.
PostgreSQL installation
1. Download and install the latest stable PostgreSQL version from here.
2. Open the installer.
3. Select the destination directory for the installation.
4. Select the following components.
5. Select the directory where you store the data.
- It's highly recommended that you use a dedicated disk only for PostgreSQL Database.
- In a production environment, it's recommended that you store the PostgreSQL data files on its own drive. Don't share the same drive for MySQL and Postgres data.
6. Select the password for the database. We recommend having "postgres" by default.
7. Leave the default port.
8. Select the default locale.
9. Click on Next.
10. Click on Next.
11. Select the option Stack Builder and click on Finish.
12. Select the version of PostgreSQL.
13. Select Spatial Extensions > PostGIS X.X Bundle.
14. Click on Next.
15. Click on Next.
16. Agree to the terms in order to continue.
17. Select PostGIS and click on Next.
18. Select the location for installing PostGIS
19. Select Yes.
20. Select Yes.
21. Select Yes.
22. Select Close.
23. Select Finish.
Now your PostgresSQL installation is done!
Edit the GpsGate.Service.config file
4.1. Click to edit C:\GpsGateServer\Franson NMEA Service\GpsGate.Service.exe.config.
4.2. In the "<appSettings>" section, paste the following settings:
<!-- Username to connect to PostgreSQL. -->
<!-- Enter the username selected during the installation process. -->
<add key="POSTGRESQL_USERNAME" value="postgres"/>
<!-- Password to connect to PostgreSQL. -->
<!-- Enter the password selected during the installation process. -->
<add key="POSTGRESQL_PASSWORD" value="postgres"/>
<!-- The hostname to PostgreSQL database server. -->
<!-- Set this if it's installed on a remote server. -->
<!-- If it is not, you can exclude this setting. -->
<add key="POSTGRESQL_HOSTNAME" value="localhost"/>
<!-- Set this if you selected a custom port during the installation. -->
<!-- If you did not, you can exclude this setting. -->
<add key="POSTGRESQL_PORT" value="5432"/>
Note: complete the "value" parameter with the password used in the PostgreSQL installation.
4.3. Save the file.
Additional notes
- For security reasons, don't expose the Postgresql server to the internet. Make sure the ports in use are blocked by your firewall.