[postgis-users] "postgis-3" extension in PostgreSQL extension list of pgAdmin

[Marco Boeringa]

Minor correction / addition to the below specs: PostgreSQL runs on a VM 
with Ubuntu 20.04.3 LTS as OS, pgAdmin4 is run from a Windows 10 machine.

Op 3-11-2021 om 18:06 schreef Marco Boeringa:
> Hi Regina,
>
> It is Ubuntu 20.04.3 LTS, with PostgreSQL 13.4. PostGIS is at 3.1.4 
> after enabling the "postgis" extension in pgAdmin4 (v6.1).
>
> Marco
>
> Op 3-11-2021 om 18:00 schreef Regina Obe:
>>> From: postgis-users [mailto:postgis-users-bounces at lists.osgeo.org] 
>>> On Behalf
>>> Of Marco Boeringa
>>> Sent: Wednesday, November 3, 2021 9:11 AM
>>> To: PostGIS Users Discussion <postgis-users at lists.osgeo.org>
>>> Subject: [postgis-users] "postgis-3" extension in PostgreSQL 
>>> extension list of
>>> pgAdmin
>>>
>>>    Hi all,
>>>
>>> Having to re-create a database using pgAdmin, I just wondered what the
>>> "postgis-3" extension represents that is visible in the list of 
>>> suggested
>>> extensions in pgAdmin? I have always ignored the entry, and chosen 
>>> "postgis",
>>> which seems to work fine, but I have never quite understood what the 
>>> "*-3"
>>> post fixed extension objects are (e.g. there is also a 
>>> "postgis_raster-3" visible
>>> next the to "postgis_raster" one).
>>>
>>> Can someone explain?
>>>
>>> Marco
>>>
>> [Regina Obe]
>> Are you running Debian or Ubuntu?  I think that is a specific packaging.
>> I recall seeing that funniness on a Debian install.
>>
>> The extension should just be postgis, but I think for some reason 
>> they also created an alias -3 to differentiate it from postgis (which 
>> the default version might be 2.5 depending on what OS you are on and 
>> the default version for the -3 would be 3.something.
>>
>> So they had essentially created two postgis.control files one 
>> postgis.control and one postgis-3.control so they could control the 
>> default for each.
>>
>> I'd just try using plain old postgis and in the drop down of 
>> versions, see if you see a 3.something
>>
>> _______________________________________________
>> 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