[postgis-users] No extension

[Regina Obe]

Do you have PostGIS tables.

 

What does 

 

SELECT *

FROM geometry_columns;

 

Return.  I’m guessing maybe QGIS is complaining about lack of spatial tables.

 

Regarding the PostgreSQL 14 / 13.

 

Looked like your PostgreSQL 13 is running on 5432, you could just disable it.  I assume it’s maybe still running in services?

 

I’m not familiar with bitnami so not sure how you completely remove it.

 

 

If you want set your PostgreSQL 14 to run on 5432

You can do ALTER SYSTEM set port = ‘5432’;

 

And then restart your PostgreSQL 14 service.

 

For good measure, you could also edit the registry so when you install new things, it correctly detects the new port

 

Open regedit.exe

 

HKEY_LOCAL_MACHINE\SOFTWARE\PostgreSQL\Services\postgresql-x64-14\

Key: Port

 

 

 

From: postgis-users [mailto:postgis-users-bounces at lists.osgeo.org] On Behalf Of Simon SPDBA Greener
Sent: Wednesday, September 28, 2022 10:15 PM
To: postgis-users at lists.osgeo.org
Subject: [postgis-users] No extension

 

When I tried to access my new Postgresql 14 database using qGIS 3.26 I get this when connecting..

2022-09-29T12:09:14     WARNING    Database connection was successful, but the accessible tables could not be determined.
2022-09-29T12:10:41     WARNING    No PostGIS support in the database.

But the nominated database has PostGIS .... in pgAdmin 4

 

create extension postgis;

 

ERROR: extension "postgis" already exists SQL state: 42710

regards

Simon 

-- 

Simon Greener
39 Cliff View Drive, Allens Rivulet, 7150, Tasmania, Australia
(m) +61 418 396 391
(w) www.spdba.com.au <http://www.spdba.com.au> 
(m) simon at spdba.com.au <mailto:simon at spdba.com.au>         
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://lists.osgeo.org/pipermail/postgis-users/attachments/20220929/66aa9072/attachment.htm>