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:[email protected]] On Behalf Of Simon SPDBA Greener Sent: Wednesday, September 28, 2022 10:15 PM To: [email protected] 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) [email protected] <mailto:[email protected]>
_______________________________________________ postgis-users mailing list [email protected] https://lists.osgeo.org/mailman/listinfo/postgis-users
