Did you uninstall PostgreSQL 13? A sexta, 30/09/2022, 04:08, Simon SPDBA Greener <[email protected]> escreveu:
> 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 >
_______________________________________________ postgis-users mailing list [email protected] https://lists.osgeo.org/mailman/listinfo/postgis-users
