[postgis-users] Migration issue

[Regina Obe]

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 version();

 

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 <mailto:simon at spdba.com.au>                
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://lists.osgeo.org/pipermail/postgis-users/attachments/20220928/7cd12e60/attachment.htm>