[postgis-users] No extension

[Alexandre Neto]

Did you uninstall PostgreSQL 13?

A sexta, 30/09/2022, 04:08, Simon SPDBA Greener <simon at spdba.com.au>
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:postgis-users-bounces at lists.osgeo.org] On
> >> Behalf
> >>> Of Simon SPDBA Greener
> >>> Sent: Thursday, September 29, 2022 7:50 PM
> >>> To: postgis-users at lists.osgeo.org
> >>> 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)simon at spdba.com.au
> >>>>
> >>>> _______________________________________________
> >>>> postgis-users mailing list
> >>>> postgis-users at lists.osgeo.org
> >>>> 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) simon at spdba.com.au
> >>>
> >>> _______________________________________________
> >>> postgis-users mailing list
> >>> postgis-users at lists.osgeo.org
> >>> https://lists.osgeo.org/mailman/listinfo/postgis-users
> >> _______________________________________________
> >> postgis-users mailing list
> >> postgis-users at lists.osgeo.org
> >> 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) simon at spdba.com.au
>
> _______________________________________________
> postgis-users mailing list
> postgis-users at lists.osgeo.org
> https://lists.osgeo.org/mailman/listinfo/postgis-users
>
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://lists.osgeo.org/pipermail/postgis-users/attachments/20220930/7bd672bc/attachment.htm>