[postgis-users] No extension

[Simon SPDBA Greener]

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:postgis-users-bounces at lists.osgeo.org] 
> *On Behalf Of *Simon SPDBA Greener
> *Sent:* Thursday, September 29, 2022 2:03 AM
> *To:* postgis-users at lists.osgeo.org
> *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)simon at spdba.com.au
>
> _______________________________________________
> postgis-users mailing list
> postgis-users at lists.osgeo.org
> 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)simon at spdba.com.au
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://lists.osgeo.org/pipermail/postgis-users/attachments/20220930/5e1058e2/attachment.htm>