[postgis-users] Migration issue

[Simon SPDBA Greener]

Regina,

Thanks for the quick response.

Windows services says there is only one instance running.

I rebooted and reconnected via pgAdmin 4.

Two connections now appear and both return

"PostgreSQL 14.5, compiled by Visual C++ build 1914, 64-bit"


for


SELECT version();

The default/new PostgreSQL 14 connection *allows *create extension 
postgis to execute correctly.

And returns this:

SELECT name, setting, category FROM pg_settings WHERE category IN('File 
Locations') or name IN('port', 'listen_addresses') ;

"config_file"    "F:/PostgreSQL/14/data/postgresql.conf" "File Locations"
"data_directory"    "F:/PostgreSQL/14/data"    "File Locations"
"external_pid_file"        "File Locations"
"hba_file"    "F:/PostgreSQL/14/data/pg_hba.conf"    "File Locations"
"ident_file"    "F:/PostgreSQL/14/data/pg_ident.conf"    "File Locations"
"listen_addresses"    "*"    "Connections and Authentication / 
Connection Settings"
"port"    "5433"    "Connections and Authentication / Connection Settings"

Whereas the bad connection (from the previous 13 database) returns:

"config_file" "E:/Bitnami/WAPPST~1.0-1/POSTGR~1/data/postgresql.conf"    
"File Locations"
"data_directory"    "E:/Bitnami/WAPPST~1.0-1/POSTGR~1/data" "File Locations"
"external_pid_file"        "File Locations"
"hba_file" "E:/Bitnami/WAPPST~1.0-1/POSTGR~1/data/pg_hba.conf"    "File 
Locations"
"ident_file" "E:/Bitnami/WAPPST~1.0-1/POSTGR~1/data/pg_ident.conf"    
"File Locations"
"listen_addresses"    "127.0.0.1"    "Connections and Authentication / 
Connection Settings"
"port"    "5432"    "Connections and Authentication / Connection Settings"

I have blown away this connection. I wonder if there is anything else I 
need to do?

regards

Simon

On 29/09/2022 11:39 am, Regina Obe wrote:
>
> Is it possible that maybe you have another PostgreSQL service running 
> on the port you think you are running PostgreSQL 14 on.
>
> The following queries might give you some clues what’s going on.
>
>
> SELECT name, setting, category FROM pg_settings WHERE category 
> IN('File Locations') or name IN('port', 'listen_addresses') ;
>
> *From:*postgis-users [mailto:postgis-users-bounces at lists.osgeo.org] 
> *On Behalf Of *Simon SPDBA Greener
> *Sent:* Wednesday, September 28, 2022 9:00 PM
> *To:* postgis-users at lists.osgeo.org
> *Subject:* [postgis-users] Migration issue
>
> Windows 10 64bit
>
> I had a Postgresql 13 instance.
>
> I exported all the databases within that instance.
>
> I removed the 13 instance.
>
> I installed Postgresql 14.
>
> In PgAdmin 4 I created a new empty database for one of the databases 
> exported from the 13 instance.
>
> I then tried:
>
> create extension postgis;
>
> And got this:
>
> 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
>
> I have no idea why it is looking in this this E: folder and not the 
> new 14 install directory.
>
> Any hints as to what I can do?
>
> 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/20220929/95be821b/attachment.htm>