<html>
<head>
<meta http-equiv="Content-Type" content="text/html; charset=UTF-8">
</head>
<body>
<p>Regina,</p>
<blockquote type="cite"
cite="mid:000a01d8d44c$7f526960$7df73c20$@pcorp.us">
<meta http-equiv="Content-Type" content="text/html; charset=UTF-8">
<meta name="Generator" content="Microsoft Word 15 (filtered
medium)">
<style>@font-face
{font-family:"Cambria Math";
panose-1:2 4 5 3 5 4 6 3 2 4;}@font-face
{font-family:Calibri;
panose-1:2 15 5 2 2 2 4 3 2 4;}@font-face
{font-family:Consolas;
panose-1:2 11 6 9 2 2 4 3 2 4;}p.MsoNormal, li.MsoNormal, div.MsoNormal
{margin:0in;
margin-bottom:.0001pt;
font-size:12.0pt;
font-family:"Times New Roman",serif;}a:link, span.MsoHyperlink
{mso-style-priority:99;
color:blue;
text-decoration:underline;}a:visited, span.MsoHyperlinkFollowed
{mso-style-priority:99;
color:purple;
text-decoration:underline;}p
{mso-style-priority:99;
mso-margin-top-alt:auto;
margin-right:0in;
mso-margin-bottom-alt:auto;
margin-left:0in;
font-size:12.0pt;
font-family:"Times New Roman",serif;}pre
{mso-style-priority:99;
mso-style-link:"HTML Preformatted Char";
margin:0in;
margin-bottom:.0001pt;
font-size:10.0pt;
font-family:"Courier New";}span.HTMLPreformattedChar
{mso-style-name:"HTML Preformatted Char";
mso-style-priority:99;
mso-style-link:"HTML Preformatted";
font-family:Consolas;}span.EmailStyle20
{mso-style-type:personal-reply;
font-family:"Calibri",sans-serif;
color:#1F497D;}.MsoChpDefault
{mso-style-type:export-only;
font-size:10.0pt;}div.WordSection1
{page:WordSection1;}</style><!--[if gte mso 9]><xml>
<o:shapedefaults v:ext="edit" spidmax="1026" />
</xml><![endif]--><!--[if gte mso 9]><xml>
<o:shapelayout v:ext="edit">
<o:idmap v:ext="edit" data="1" />
</o:shapelayout></xml><![endif]-->
<div class="WordSection1">
<p class="MsoNormal"><span
style="font-size:11.0pt;font-family:"Calibri",sans-serif;color:#1F497D">This
I suppose could be a permission issue or search path one.</span></p>
</div>
</blockquote>
<p>I used pgAdmin 4 to set the search_path parameter to "$user",
public, topology for all the databases.<br>
</p>
<p>Didn't seem to make a difference.<br>
</p>
<blockquote type="cite"
cite="mid:000a01d8d44c$7f526960$7df73c20$@pcorp.us">
<div class="WordSection1">
<p class="MsoNormal"><span
style="font-size:11.0pt;font-family:"Calibri",sans-serif;color:#1F497D"><o:p></o:p></span></p>
<p class="MsoNormal"><span
style="font-size:11.0pt;font-family:"Calibri",sans-serif;color:#1F497D"><o:p> </o:p>Are
you using the same account in QGIS to connect as you are in
pgAdmin?</span></p>
</div>
</blockquote>
<p>Yes, I believe so. All connections use the postgres user who owns
all the databases.</p>
<div class="WordSection1">
<p class="MsoNormal"><span
style="font-size:11.0pt;font-family:"Calibri",sans-serif;color:#1F497D">Are
you connecting from QGIS PostGIS layers or via QGIS DBManager
menu option?</span></p>
</div>
Both.<br>
<blockquote type="cite"
cite="mid:000a01d8d44c$7f526960$7df73c20$@pcorp.us">
<div class="WordSection1">
<p class="MsoNormal"><span
style="font-size:11.0pt;font-family:"Calibri",sans-serif;color:#1F497D"><o:p></o:p></span></p>
<p class="MsoNormal"><span
style="font-size:11.0pt;font-family:"Calibri",sans-serif;color:#1F497D"><o:p> </o:p>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.</span></p>
</div>
</blockquote>
<p>When I connection using DBManager to one of the databases (dfdb)
in the instance I still get the following message....</p>
<p><span style=" color:#dc7d00;">2022-09-30T08:35:24 WARNING </span>Database
connection was successful, but the accessible tables could not be
determined.</p>
<p>If I try to connect to another database in the same instance
(gisdb) I get <br>
</p>
<p>FATAL: database "gisdb" does not exist.</p>
<p>Sorry if this is not that helpful.<br>
</p>
<p>regards</p>
<p>Simon<br>
</p>
<blockquote type="cite"
cite="mid:000a01d8d44c$7f526960$7df73c20$@pcorp.us">
<div class="WordSection1">
<p class="MsoNormal"><span
style="font-size:11.0pt;font-family:"Calibri",sans-serif;color:#1F497D"><o:p></o:p></span></p>
<p class="MsoNormal"><span
style="font-size:11.0pt;font-family:"Calibri",sans-serif;color:#1F497D"><o:p> </o:p></span></p>
<div style="border:none;border-left:solid blue 1.5pt;padding:0in
0in 0in 4.0pt">
<div>
<div style="border:none;border-top:solid #E1E1E1
1.0pt;padding:3.0pt 0in 0in 0in">
<p class="MsoNormal"><b><span
style="font-size:11.0pt;font-family:"Calibri",sans-serif">From:</span></b><span
style="font-size:11.0pt;font-family:"Calibri",sans-serif">
postgis-users
[<a class="moz-txt-link-freetext" href="mailto:postgis-users-bounces@lists.osgeo.org">mailto:postgis-users-bounces@lists.osgeo.org</a>] <b>On
Behalf Of </b>Simon SPDBA Greener<br>
<b>Sent:</b> Thursday, September 29, 2022 2:03 AM<br>
<b>To:</b> <a class="moz-txt-link-abbreviated" href="mailto:postgis-users@lists.osgeo.org">postgis-users@lists.osgeo.org</a><br>
<b>Subject:</b> Re: [postgis-users] No extension<o:p></o:p></span></p>
</div>
</div>
<p class="MsoNormal"><o:p> </o:p></p>
<p>Regina,<o:p></o:p></p>
<p>Thanks for the reply.<o:p></o:p></p>
<p>> <span
style="font-size:11.0pt;font-family:"Calibri",sans-serif;color:#1F497D">What
does </span><o:p></o:p></p>
<p class="MsoNormal"
style="mso-margin-top-alt:auto;mso-margin-bottom-alt:auto"><span
style="font-size:11.0pt;font-family:"Calibri",sans-serif;color:#1F497D">>
SELECT * FROM geometry_columns;<br>
<br>
> Return. I’m guessing maybe QGIS is complaining about
lack of spatial tables.</span><o:p></o:p></p>
<p class="MsoNormal"
style="mso-margin-top-alt:auto;mso-margin-bottom-alt:auto"><span
style="font-size:11.0pt;font-family:"Calibri",sans-serif;color:#1F497D">It
returns a data grid showing all the spatial layers.</span><o:p></o:p></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><o:p></o:p></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><o:p></o:p></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...<o:p></o:p></p>
<p><span style="color:#DC7D00">2022-09-29T14:38:36 WARNING
</span>No PostGIS support in the database.<o:p></o: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.<o:p></o:p></p>
<p>regards<o:p></o:p></p>
<p>Simon<o:p></o:p></p>
<pre>-- <o:p></o:p></pre>
<pre>Simon Greener<o:p></o:p></pre>
<pre>39 Cliff View Drive, Allens Rivulet, 7150, Tasmania, Australia<o:p></o:p></pre>
<pre>(m) +61 418 396 391<o:p></o:p></pre>
<pre>(w) <a href="http://www.spdba.com.au" moz-do-not-send="true">www.spdba.com.au</a><o:p></o:p></pre>
<pre>(m) <a href="mailto:simon@spdba.com.au" moz-do-not-send="true" class="moz-txt-link-freetext">simon@spdba.com.au</a><o:p></o:p></pre>
</div>
</div>
<br>
<fieldset class="moz-mime-attachment-header"></fieldset>
<pre class="moz-quote-pre" wrap="">_______________________________________________
postgis-users mailing list
<a class="moz-txt-link-abbreviated" href="mailto:postgis-users@lists.osgeo.org">postgis-users@lists.osgeo.org</a>
<a class="moz-txt-link-freetext" href="https://lists.osgeo.org/mailman/listinfo/postgis-users">https://lists.osgeo.org/mailman/listinfo/postgis-users</a>
</pre>
</blockquote>
<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>