[prev in list] [next in list] [prev in thread] [next in thread] 

List:       postgis-users
Subject:    Re: [postgis-users] "postgis-3" extension in PostgreSQL extension list of pgAdmin
From:       Marco Boeringa <marco () boeringa ! demon ! nl>
Date:       2021-11-03 21:58:00
Message-ID: dc8f6c2f-7f47-aa13-bba0-5f37f21a72c9 () boeringa ! demon ! nl
[Download RAW message or body]

Hi Regina,

Your query shows me the same "3.1.4" 'default_version' for both the 
'postgis' and 'postgis-3' entries in the table, so no difference 
contrary to your expectation.

The same for all other duplicate "*-3" entries for e.g. 
'address_standardizer-3', 'postgis_raster-3', etc., they all point to 
the same "3.1.4" 'default_version' as the non post fixed ones.

By the way, only a small part of the extensions is duplicated like that, 
the address stuff and postgis related, the rest only has a single entry 
in the table, without "*-3" extension.

Marco

Op 3-11-2021 om 22:09 schreef 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@lists.osgeo.org] On Behalf
> > Of Marco Boeringa
> > Sent: Wednesday, November 3, 2021 2:01 PM
> > To: postgis-users@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@lists.osgeo.org]
> > > > > On Behalf
> > > > > Of Marco Boeringa
> > > > > Sent: Wednesday, November 3, 2021 9:11 AM
> > > > > To: PostGIS Users Discussion <postgis-users@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@lists.osgeo.org
> > > > https://lists.osgeo.org/mailman/listinfo/postgis-users
> > > _______________________________________________
> > > postgis-users mailing list
> > > postgis-users@lists.osgeo.org
> > > https://lists.osgeo.org/mailman/listinfo/postgis-users
> > _______________________________________________
> > postgis-users mailing list
> > postgis-users@lists.osgeo.org
> > https://lists.osgeo.org/mailman/listinfo/postgis-users
> _______________________________________________
> postgis-users mailing list
> postgis-users@lists.osgeo.org
> https://lists.osgeo.org/mailman/listinfo/postgis-users
_______________________________________________
postgis-users mailing list
postgis-users@lists.osgeo.org
https://lists.osgeo.org/mailman/listinfo/postgis-users


[prev in list] [next in list] [prev in thread] [next in thread]