Yes, it is uninstalled. 39 Cliff View Drive Allens Rivulet Tas 7150 (W) 0418 396 391
On 30 Sep 2022, 18:24, at 18:24, Alexandre Neto <[email protected]> wrote: >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 _______________________________________________ postgis-users mailing list [email protected] https://lists.osgeo.org/mailman/listinfo/postgis-users
