<html>
<head>
<meta http-equiv="Content-Type" content="text/html; charset=UTF-8">
</head>
<body>
<p>Regina,</p>
<p>Thanks for the reply.</p>
<p>> <span
style="font-size:11.0pt;font-family:"Calibri",sans-serif;color:#1F497D">What
does <o:p></o:p></span><span
style="font-size:11.0pt;font-family:"Calibri",sans-serif;color:#1F497D">
<br>
</span></p>
<p class="MsoNormal"><span
style="font-size:11.0pt;font-family:"Calibri",sans-serif;color:#1F497D">>
SELECT *<o:p></o:p></span><span
style="font-size:11.0pt;font-family:"Calibri",sans-serif;color:#1F497D"></span><span
style="font-size:11.0pt;font-family:"Calibri",sans-serif;color:#1F497D">
FROM geometry_columns;<br>
<br>
> Return. I’m guessing maybe QGIS is complaining about lack
of spatial tables.</span></p>
<p class="MsoNormal"><span
style="font-size:11.0pt;font-family:"Calibri",sans-serif;color:#1F497D">It
returns a data grid showing all the spatial layers.<br>
</span></p>
<p>> <span
style="font-size:11.0pt;font-family:"Calibri",sans-serif;color:#1F497D">Looked
like your PostgreSQL 13 is running on 5432, you could just
disable it. I assume it’s maybe still running in services?</span></p>
<p><span
style="font-size:11.0pt;font-family:"Calibri",sans-serif;color:#1F497D">The
strange thing was that it had been uninstalled. I removed the
rogue connection in PgAdmin 4 and it fixed the problem.</span></p>
<p>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...</p>
<p><span style=" color:#dc7d00;">2022-09-29T14:38:36 WARNING </span>No
PostGIS support in the database.</p>
<p></p>
<p><span style=" color:#dc7d00;">2022-09-29T14:38:36 WARNING </span>Database
connection was successful, but the accessible tables could not be
determined.</p>
<p>regards</p>
<p>Simon</p>
<pre class="moz-signature" cols="72">--
Simon Greener
39 Cliff View Drive, Allens Rivulet, 7150, Tasmania, Australia
(m) +61 418 396 391
(w) <a class="moz-txt-link-abbreviated" href="http://www.spdba.com.au">www.spdba.com.au</a>
(m) <a class="moz-txt-link-abbreviated" href="mailto:simon@spdba.com.au">simon@spdba.com.au</a></pre>
</body>
</html>