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

[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