Regina,
This I suppose could be a permission issue or search path one.
I used pgAdmin 4 to set the search_path parameter to "$user", public,
topology for all the databases.
Didn't seem to make a difference.
Are you using the same account in QGIS to connect as you are in pgAdmin?
Yes, I believe so. All connections use the postgres user who owns all
the databases.
Are you connecting from QGIS PostGIS layers or via QGIS DBManager menu
option?
Both.
If you haven’t tried DBManager, I would try that to see what tables
you are able to see. That should give you a clue if it’s a permission
issue.
When I connection using DBManager to one of the databases (dfdb) in the
instance I still get the following message....
2022-09-30T08:35:24 WARNING Database connection was successful, but
the accessible tables could not be determined.
If I try to connect to another database in the same instance (gisdb) I get
FATAL: database "gisdb" does not exist.
Sorry if this is not that helpful.
regards
Simon
*From:*postgis-users [mailto:[email protected]]
*On Behalf Of *Simon SPDBA Greener
*Sent:* Thursday, September 29, 2022 2:03 AM
*To:* [email protected]
*Subject:* Re: [postgis-users] No extension
Regina,
Thanks for the reply.
> What does
> SELECT * FROM geometry_columns;
> Return. I’m guessing maybe QGIS is complaining about lack of
spatial tables.
It returns a data grid showing all the spatial layers.
> Looked like your PostgreSQL 13 is running on 5432, you could just
disable it. I assume it’s maybe still running in services?
The strange thing was that it had been uninstalled. I removed the
rogue connection in PgAdmin 4 and it fixed the problem.
In my new instance I created a database for each of the backup
databases, execute "create extension postgis" for all of them, then
restored the original data from the backups successfully. I am still
getting this in qGIS logs...
2022-09-29T14:38:36 WARNING No PostGIS support in the database.
2022-09-29T14:38:36 WARNING Database connection was successful,
but the accessible tables could not be determined.
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]
_______________________________________________
postgis-users mailing list
[email protected]
https://lists.osgeo.org/mailman/listinfo/postgis-users
--
Simon Greener
39 Cliff View Drive, Allens Rivulet, 7150, Tasmania, Australia
(m) +61 418 396 391
(w)www.spdba.com.au
(m)[email protected]
_______________________________________________
postgis-users mailing list
[email protected]
https://lists.osgeo.org/mailman/listinfo/postgis-users
