[postgis-users] No extension

[Regina Obe]

> If I try to connect to another database in the same instance (gisdb) I get 

> FATAL: database "gisdb" does not exist.

Hmm strange it says the database doesn’t exist.

 

You confirmed the port is right the 5433 port (not 5432).

 

Just still sounds like it’s trying to connect to the wrong service or server still.

 

I’d triple check the connection settings, make sure the port and IP/hostname is right.

 

From: postgis-users [mailto:postgis-users-bounces at lists.osgeo.org] On Behalf Of Simon SPDBA Greener
Sent: Thursday, September 29, 2022 6:54 PM
To: postgis-users at lists.osgeo.org
Subject: Re: [postgis-users] No extension

 

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 <mailto: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 <mailto:simon at spdba.com.au> 





_______________________________________________
postgis-users mailing list
postgis-users at lists.osgeo.org <mailto: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 <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/beadc7d3/attachment.htm>