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:[email protected]]
*On Behalf Of *Simon SPDBA Greener
*Sent:* Wednesday, September 28, 2022 9:00 PM
*To:* [email protected]
*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)[email protected]
_______________________________________________
postgis-users mailing list
[email protected]
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)[email protected]
_______________________________________________
postgis-users mailing list
[email protected]
https://lists.osgeo.org/mailman/listinfo/postgis-users
