[postgis-users] No extension

[Simon SPDBA Greener]

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