[postgis-users] No extension

Tue Oct 4 13:57:03 PDT 2022

Search path is set. Because it is set in the database it is independent of the port, correct?

Because I need to move forward, I've gone back to using port 5433 and all is working.

Thanks to all for taking the time to help.

Simon

⁣39 Cliff View Drive
Allens Rivulet Tas 7150
(W) 0418 396 391

On 5 Oct 2022, 06:09, at 06:09, Bo Victor Thomsen <bo.victor.thomsen at gmail.com> wrote:
>What about search path for Postgres ? It could be different for each 
>client accessing Postgres.
>
>Den 03-10-2022 kl. 20:27 skrev Regina Obe:
>> That is weird.  I would have thought maybe a JDBC driver issue, but
>the error suggests it was able to connect and just not able to access
>that function.  Or that error is just bogus and it really can't
>connect.
>>
>> 1) Is it using the same account as other apps.  Could be a permission
>issue.
>> 2) Can you do a quick non-postgis test like?
>>
>> SELECT version();
>>
>> 3) I know there were big changes between PG 11 / PG 12 that
>necessitated upgrades of drivers, but didn't think much difference
>between PG13 and PG14. If option 1 and 2 were not useful, I'd suggest
>just upgrading to the latest JDBC driver from
>https://jdbc.postgresql.org/download/
>>
>>
>>
>>
>>
>>> -----Original Message-----
>>> From: postgis-users [mailto:postgis-users-bounces at lists.osgeo.org]
>On Behalf
>>> Of Simon Greener
>>> Sent: Friday, September 30, 2022 4:56 AM
>>> To: PostGIS Users Discussion <postgis-users at lists.osgeo.org>
>>> Subject: Re: [postgis-users] No extension
>>>
>>> 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
><senhor.neto at gmail.com>
>>> wrote:
>>>> 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:213
>>>> 2)
>>>>> 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
>>>>>
>>>>
>>>>
>-----------------------------------------------------------------------
>>>> -
>>>>
>>>> _______________________________________________
>>>> 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
>> _______________________________________________
>> postgis-users mailing list
>> postgis-users at lists.osgeo.org
>> https://lists.osgeo.org/mailman/listinfo/postgis-users
>
>-- 
>Med venlig hilsen / Best regards
>
>Bo Victor Thomsen
>
>_______________________________________________
>postgis-users mailing list
>postgis-users at lists.osgeo.org
>https://lists.osgeo.org/mailman/listinfo/postgis-users