<html>
<head>
<meta http-equiv="content-type" content="text/html; charset=UTF-8">
</head>
<body>
<div class="moz-forward-container">
<p>Regina,</p>
<p>Thanks for the quick response.</p>
<p>Windows services says there is only one instance running.<br>
</p>
<p>I rebooted and reconnected via pgAdmin 4.</p>
<p>Two connections now appear and both return <br>
</p>
<p class="MsoNormal"><span
style="font-size:11.0pt;font-family:"Calibri",sans-serif;color:#1F497D">"PostgreSQL
14.5, compiled by Visual C++ build 1914, 64-bit"</span></p>
<p class="MsoNormal"><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">for
<br>
</span></p>
<p class="MsoNormal"><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
version();</span></p>
<span
style="font-size:11.0pt;font-family:"Calibri",sans-serif;color:#1F497D"></span>
<p>The default/new PostgreSQL 14 connection <b>allows </b>create
extension postgis to execute correctly.<br>
</p>
<p>And returns this:</p>
<p>SELECT name, setting, category FROM pg_settings WHERE category
IN('File Locations') or name IN('port', 'listen_addresses') ;</p>
<p>"config_file" "F:/PostgreSQL/14/data/postgresql.conf"
"File Locations"<br>
"data_directory" "F:/PostgreSQL/14/data" "File Locations"<br>
"external_pid_file" "File Locations"<br>
"hba_file" "F:/PostgreSQL/14/data/pg_hba.conf" "File
Locations"<br>
"ident_file" "F:/PostgreSQL/14/data/pg_ident.conf" "File
Locations"<br>
"listen_addresses" "*" "Connections and Authentication /
Connection Settings"<br>
"port" "5433" "Connections and Authentication / Connection
Settings"</p>
<p>Whereas the bad connection (from the previous 13 database)
returns:</p>
<p>"config_file"
"E:/Bitnami/WAPPST~1.0-1/POSTGR~1/data/postgresql.conf" "File
Locations"<br>
"data_directory" "E:/Bitnami/WAPPST~1.0-1/POSTGR~1/data"
"File Locations"<br>
"external_pid_file" "File Locations"<br>
"hba_file"
"E:/Bitnami/WAPPST~1.0-1/POSTGR~1/data/pg_hba.conf" "File
Locations"<br>
"ident_file"
"E:/Bitnami/WAPPST~1.0-1/POSTGR~1/data/pg_ident.conf" "File
Locations"<br>
"listen_addresses" "127.0.0.1" "Connections and
Authentication / Connection Settings"<br>
"port" "5432" "Connections and Authentication / Connection
Settings"</p>
<p>I have blown away this connection. I wonder if there is
anything else I need to do?</p>
<p>regards</p>
<p>Simon<br>
</p>
<div class="moz-cite-prefix">On 29/09/2022 11:39 am, Regina Obe
wrote:<br>
</div>
<blockquote type="cite"
cite="mid:001901d8d3a4$53f370f0$fbda52d0$@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">Is
it possible that maybe you have another PostgreSQL service
running on the port you think you are running PostgreSQL
14 on.<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>
<p class="MsoNormal"><span
style="font-size:11.0pt;font-family:"Calibri",sans-serif;color:#1F497D">The
following queries might give you some clues what’s going
on.<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>
<br>
<span
style="font-size:11.0pt;font-family:"Calibri",sans-serif;color:#1F497D"><o:p> </o:p></span>
<p class="MsoNormal"><span
style="font-size:11.0pt;font-family:"Calibri",sans-serif;color:#1F497D">SELECT
name, setting, category FROM pg_settings WHERE category
IN('File Locations') or name IN('port',
'listen_addresses') ;<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>
<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"
moz-do-not-send="true">mailto:postgis-users-bounces@lists.osgeo.org</a>]
<b>On Behalf Of </b>Simon SPDBA Greener<br>
<b>Sent:</b> Wednesday, September 28, 2022 9:00 PM<br>
<b>To:</b> <a class="moz-txt-link-abbreviated
moz-txt-link-freetext"
href="mailto:postgis-users@lists.osgeo.org"
moz-do-not-send="true">postgis-users@lists.osgeo.org</a><br>
<b>Subject:</b> [postgis-users] Migration issue<o:p></o:p></span></p>
</div>
</div>
<p class="MsoNormal"><o:p> </o:p></p>
<p>Windows 10 64bit<o:p></o:p></p>
<p>I had a Postgresql 13 instance. <o:p></o:p></p>
<p>I exported all the databases within that instance.<o:p></o:p></p>
<p>I removed the 13 instance.<o:p></o:p></p>
<p>I installed Postgresql 14.<o:p></o:p></p>
<p>In PgAdmin 4 I created a new empty database for one of
the databases exported from the 13 instance.<o:p></o:p></p>
<p>I then tried:<o:p></o:p></p>
<p><span style="font-family:"Courier New"">create
extension postgis;</span><o:p></o:p></p>
<p>And got this:<o:p></o:p></p>
<p><span
style="font-size:9.0pt;font-family:Consolas;color:#222222;letter-spacing:.1pt;background:white">ERROR:
could not open extension control file
"E:/Bitnami/WAPPST~1.0-1/POSTGR~1/share/extension/postgis.control":
No such file or directory SQL state: 58P01</span><o:p></o:p></p>
<p>I have no idea why it is looking in this this E: folder
and not the new 14 install directory.<br>
<br>
Any hints as to what I can do?<br>
<br>
regards<br>
<br>
Simon<o:p></o:p></p>
<p>-- <o:p></o:p></p>
<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 moz-txt-link-freetext" href="mailto:postgis-users@lists.osgeo.org" moz-do-not-send="true">postgis-users@lists.osgeo.org</a>
<a class="moz-txt-link-freetext" href="https://lists.osgeo.org/mailman/listinfo/postgis-users" moz-do-not-send="true">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" moz-do-not-send="true">www.spdba.com.au</a>
(m) <a class="moz-txt-link-abbreviated moz-txt-link-freetext" href="mailto:simon@spdba.com.au" moz-do-not-send="true">simon@spdba.com.au</a></pre>
</div>
</body>
</html>