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

[Regina Obe]

Doesn't matter where pgAdmin is run you'd see the same issue since it just reads the extension tables from the server.

If you do the query 

SELECT * FROM pg_available_extensions;

I suspect you'll see two and they have different default versions.

> -----Original Message-----
> From: postgis-users [mailto:postgis-users-bounces at lists.osgeo.org] On Behalf
> Of Marco Boeringa
> Sent: Wednesday, November 3, 2021 2:01 PM
> To: postgis-users at lists.osgeo.org
> Subject: Re: [postgis-users] "postgis-3" extension in PostgreSQL extension list
> of pgAdmin
> 
> 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
> _______________________________________________
> postgis-users mailing list
> postgis-users at lists.osgeo.org
> https://lists.osgeo.org/mailman/listinfo/postgis-users