Install PostgreSQL/PostGIS using EnterpriseDB Installerĭownload the PostgreSQL 9.6.1 from EnterpriseDB site. See PostgreSQL website for more information C:\Program Files\PostgreSQL\9.6\bin\postgisgui). If you don't see it in your startup menu, it should be where you install PostgreSQL (e.g. It is a separate application under the PostGIS Bundle 2.3 in the startup menu. The EnterpriseDB installer does include shp2pgsql-gui but it is not added to pgAdmin 4 as a plugin like with pgAdmin 3.
It also doesn't include shp2pgsql-gui to import shapefiles to PostGIS - you have to do this manually - see section on Installing pgAdmin 3 below. if you are using the 圆4 PostgreSQL make sure you also use the 圆4 PostGIS installer tooĪ caveat about BigSQL installer - it will install pgAdmin 3 but it does not include an option to install a sample PostGIS database, which I find useful for doing a quick test since it already has most of the extensions enabled. pgAgent can install itself as a service on Windows systems. If installed in this way, the service will automatically be created and the instructions below can be ignored. Use the StackBuilder application to download and install it. Select all the components if not done automatically. Accept the Default installation directory and click Next. Click Yes when asked do you want to allow this app to make changes to your device. PostgreSQL must be installed first before PostGIS. pgAgent is available in a pre-built installer if you use EnterpriseDB’s PostgreSQL Installers. Right click the installer and select Run as administrator. At this point, I'd rather stick with pgAdmin 3 for now. I started application a few times and everytime it took anywhere from 1-5 minutes or it just hangs. This release contains a number of bug fixes and new features since the release of pgAdmin 4 v6.9. Slow start up was an issue on the laptop as well. PgAdmin 4 on the Windows Server had no display resolution problem. I tried changing the program's properties to "Disable display scaling on high DPI settings "as well as "Run this program in compatibility mode for" for Windows 7 and 8 these options didn't seem to make a difference. My laptop OS is Windows 10 so I'm not sure if it's just and issue particular to Windows 10 or not. The pgAdmin 4 GUI was tiny text and graphics were so small I couldn't see anything. The second time worked but the display resolution was horrible on my laptop's very high resolution (3200x1800) screen. Warning: This documentation is for a pre-release version of pgAdmin 4. Just said "loading" for a long time before I manually ended the process. On the laptop pgAdmin did not work the first time I tried it. I then did a separate installation of pgAdmin 3. After testing and playing around I decided to use the EnterpriseDB installer to install PostgreSQL 9.6 with PostGIS bundle 2.3.1. The installation process was fairly easy. Although the EnterpriseDB included the current pgAdmin 4 and the BigSQL installer package I used included pgAdmin 3 LTR. Both installers include the option to install PostGIS 2.3.1 bundle. I tried both installers from both EnterpriseDB and BigSQL to install PostgreSQL 9.6. Part 1 was installing QGIS, an open source desktop GIS - download pdf. This post is part 2 of my Open Source GIS Implementation Experiment.