Shulou(Shulou.com)06/01 Report--

1) Source code compilation

PostGIS has many installation packages, try to compile separately, you can download the source code, and then compile http://www.postgis.net/source/

2) the components available for matching are as follows:

Postgresql-11.5-1-windows-x64 with postgis-bundle-pg11x64-setup-2.5.3-1

Postgresql-9.4.24-1-windows-x64.exe with postgis-bundle-pg94x64-setup-2.3.7-1.exe

3) neither the currently installed 32-bit postgresql nor postgis can start the GIS function properly

Error

1)

Error: type "public.geometry" does not exist

LINE 25: "geometry", "public". "geometry"

^

* error *

Error: type "public.geometry" does not exist

SQL status: 42704

Character: 574

Indicates that the postgis plug-in is not installed

2)

ERROR: could not load library "C:/Program Files (x86) / PostgreSQL/9.4/lib/postgis-2.3.dll": The specified module could not be found. "

The currently installed 32-bit postgresql server can not be compatible with each other by installing 32-bit postgis plug-ins, nor can it be installed and used normally with Stack Builder.

3) execute CREATE EXTENSION postgis

Error: unable to open extension control file "C:/Program Files/PostgreSQL/9.4/share/extension/postgis.control": No such file or directory

SQL status: 58P01

Indicates that the postgis plug-in is not installed

4)

Error: relationship "spatial_ref_sys" already exists

* error *

Execute the instruction CREATE EXTENSION postgis, which will default to plug-in spatial_ref_sys spatial data table

Welcome to subscribe "Shulou Technology Information " to get latest news, interesting things and hot topics in the IT industry, and controls the hottest and latest Internet news, technology news and IT industry trends.