Postgres Pro
Downloads
Home   >   mailing lists

Re: postgis - Mailing list pgsql-general

From Imre Samu
Subject Re: postgis
Date
Msg-id CAJnEWwkNbfPom+zVF=pLqBn0tyXnnZ7uf1x+cCM2HuB+KjxTxg@mail.gmail.com
Whole thread Raw
In response to Re: postgis  (Marc Millas <marc.millas@mokadb.com>)
List pgsql-general
Tree view
> from your message, I understand that for debian 11, I can NOT get any 3.0.x version.

I can't see any Postgis 3.0.x version 
in the default "http://apt.postgresql.org/pub/repos/apt/ bullseye-pgdg main 12"  repo

root@6b22a4450d93:/# cat /etc/apt/sources.list.d/pgdg.list
deb [ signed-by=/usr/local/share/keyrings/postgres.gpg.asc ] http://apt.postgresql.org/pub/repos/apt/ bullseye-pgdg main 12

If the version of PostGIS(3.0.x) is important for compatibility, 
you should also pay attention to the version of the "geos" and "proj" packages.

As I understand the debian "postgresql-12-postgis-3" package is continuously updated to the latest official postgis version.
( postgis 3.0 -> postgis 3.1 -> postgis 3.2  ... ) 
And the latest update was at 2022-02-14

( My knowledge is limited .. ) 
and there is a dedicated Postgis mail list:
and a Debian packaging mail list:

Regards,
 Imre



Marc Millas <marc.millas@mokadb.com> ezt írta (időpont: 2022. júl. 19., K, 20:20):
Hi,

from your message, I understand that for debian 11, I can NOT get any 3.0.x version.
right ?

Marc MILLAS
Senior Architect
+33607850334



On Tue, Jul 19, 2022 at 7:20 PM Imre Samu <pella.samu@gmail.com> wrote:
> I would like to install postgis 3.04 on a debian 11
> postgres 12.
> I may use whatever repo.
> I install postgres from postgresql.org...

As I see - from the official postgresql.org debian11 repo, 
you can only install the "postgresql-12-postgis-3" package  ( now: Postgis=3.2.1 )

docker run -it --rm postgres:12 bash
  apt update && apt search postgis | grep postgresql-12-postgis-3
   ---> postgresql-12-postgis-3/bullseye-pgdg 3.2.1+dfsg-1.pgdg110+1 amd64
  cat /etc/os-release | grep VERSION
   ---> VERSION="11 (bullseye)

Now the latest 3.0 version is http://postgis.net/2022/02/02/postgis-3.0.5/

regards,
  Imre

Marc Millas <marc.millas@mokadb.com> ezt írta (időpont: 2022. júl. 18., H, 20:48):
Hi,
postgres 12.
I may use whatever repo.

I install postgres from postgresql.org...



Marc MILLAS
Senior Architect
+33607850334



On Mon, Jul 18, 2022 at 7:15 PM Adrian Klaver <adrian.klaver@aklaver.com> wrote:
On 7/18/22 10:08, Marc Millas wrote:
> Hi,
>
> I would like to install postgis 3.04 on a debian 11.
>
> digging into various web sites, I didnt found the name of that packet.
>
> can someone help ?

Should have added to previous response, what version of Postgres?
>
> thanks
>
> Marc MILLAS
> Senior Architect
> +33607850334
> www.mokadb.com <http://www.mokadb.com>
>


--
Adrian Klaver
adrian.klaver@aklaver.com

pgsql-general by date:

Previous
From: Tom Lane
Date:
Subject: Re: citext on exclude using gist
Next
From: "David G. Johnston"
Date:
Subject: Re: citext on exclude using gist