[Qgis-user] Postgres 11 will not CREATE EXTENSION postgis;

[Jorge Gustavo Rocha]

Hi Bryan,

This error is not related to QGIS.

After installing Postgresql, you have to install Postgis [1]. After
installing Postgis, you have to enable that extension in each database
that handles geospatial data.

If you are using Windows, there are Windows installers available that
allows you to install additional packages, like Postgis, using the
installation GUI, like EnterpriseDB Windows installer [2]. If you are
just starting learning, use something like this.

Regards,

Jorge Gustavo

[1] https://postgis.net/install/

[2] https://www.postgresql.org/download/windows/

Às 13:29 de 28/08/19, Bryan Price escreveu:
>
>  
>
>                 I am new to Postgres and QGIS but when attempting to
> "CREATE EXTENSION postgis;" I consistently receive ERROR:  could not
> load library "C:/Program Files/PostgreSQL/11/lib/rtpostgis-2.5.dll":
> The specified module could not be found.SQL state: XX000 . Most
> references on web refer to incompatible  versions of QGIS / Postgresql
> . this is not the case I have verified, in fact the same installation
> runs fine on my win 10 laptop. It has something to do with the Win
> Server 2012 R2 that I have installed it on. Need some direction of
> where to look next
>
> PostGres v11
> pgAdmin4
>
> QGIS v 3.8.1
>
>  
>
> Sincerely,
> *Bryan Price*
>
> GIS Manager | St. Clair County, AL
> bryan at stclairco.com <mailto:bryan at stclairco.com>
>
> www.stclairgis.com <http://www.stclairgis.com/>
>
>  
>
>  
>
>
> _______________________________________________
> Qgis-user mailing list
> Qgis-user at lists.osgeo.org
> List info: https://lists.osgeo.org/mailman/listinfo/qgis-user
> Unsubscribe: https://lists.osgeo.org/mailman/listinfo/qgis-user
-- 
Logo*   Geomaster, LDA*
  *VENHA DESCOBRIR O CAMINHO DO OPEN SOURCE CONNOSC**O

*
 
Avenida Barros e Soares
N.º 423, 4715-214 Braga
VAT/NIF510 906 109
Phone  +351 253 680 323
Site       geomaster.pt <http://geomaster.pt>
GPS       41.53322, -8.41929
	
------------------------------------------------------------------------
	 
Jorge Gustavo Rocha
CTO

Mobile  +351 910 333 888
Email    jgr at geomaster.pt


-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://lists.osgeo.org/pipermail/qgis-user/attachments/20190828/1d2ab753/attachment-0001.html>
-------------- next part --------------
A non-text attachment was scrubbed...
Name: cropped-geomaster300x300-1.png
Type: image/png
Size: 33896 bytes
Desc: not available
URL: <http://lists.osgeo.org/pipermail/qgis-user/attachments/20190828/1d2ab753/attachment-0001.png>