I decided to switch the port back to 5432 following your recipe (because
I have many apps that access postgresql).
I can connect using qGIS/pgAdmin 4 etc but when I try to connect using
GeoServer I get this:
...
at java.base/java.lang.Thread.run(Thread.java:831)
Caused by: java.lang.RuntimeException: Unable to obtain connection:
ERROR: function postgis_lib_version() does not exist
Hint: No function matches the given name and argument types. You
might need to add explicit type casts.
Position: 8
at
org.geotools.jdbc.JDBCDataStore.createConnection(JDBCDataStore.java:2132)
Running the function in pgAdmin 4 returns:
select postgis_lib_version();
"postgis_lib_version"
"3.2.3"
Any ideas?
All other apps work correctly, only GeoServer is returning this error.
regards
Simon
On 30/09/2022 11:39 am, Simon SPDBA Greener wrote:
The old postgresql 13 was running on 5432.
I thought I had shut it down before running the 14 installer.
No matter, your suggestion about 5433 was the key I needed to open the
door.
Thanks for all your patience and help: greatly appreciated.
regards
Simon
On 30/09/2022 10:31 am, Regina Obe wrote:
When you use the PostgreSQL installer on windows,
If you have a PostgreSQL instance running already on Port 5432, it
defaults
the port to the next available increment port.
So my guess is you had your bitnami running on Port 5432, it detected
that,
so then installed on Port 5433.
So your old would have 5432, your new PostgreSQL 14 would be 5433.
That's why I mentioned, if you wanted it to run on default PostgreSQL
5432,
you can do the
Run the sql:
ALTER SYSTEM Set port = '5432';
Then restart the service.
And that registry change I mentioned.
Open regedit.exe
HKEY_LOCAL_MACHINE\SOFTWARE\PostgreSQL\Services\postgresql-x64-14\
Key: Port
The registry change you do so if you install other extensions such as
postgis or pgAgent that need to connect to the database, they read
the port
number from the registry and default to that. I think pgAdmin4 also
when you
first setup reads port from registry.
-----Original Message-----
From: postgis-users [mailto:[email protected]] On
Behalf
Of Simon SPDBA Greener
Sent: Thursday, September 29, 2022 7:50 PM
To: [email protected]
Subject: Re: [postgis-users] No extension
Hold that thought.
Port 5432 didn't work on DFDB as I thought it did.
Port 5433 works.
Has the default port changed with database installs?
Simon
--
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
--
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
_______________________________________________
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
