postgis

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 ?

Where did you install Postgres from, the Debian or the Postgres
community repos?

thanks

Marc MILLAS
Senior Architect
+33607850334
www.mokadb.com <http://www.mokadb.com&gt;

--
Adrian Klaver
adrian.klaver@aklaver.com

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&gt;

--
Adrian Klaver
adrian.klaver@aklaver.com

Hi,
postgres 12.
I may use whatever repo.

I install postgres from postgresql.org...

Marc MILLAS
Senior Architect
+33607850334
www.mokadb.com

On Mon, Jul 18, 2022 at 7:15 PM Adrian Klaver <adrian.klaver@aklaver.com>
wrote:

On 7/18/22 11:48, Marc Millas wrote:

Hi,
postgres 12.
I may use whatever repo.

I install postgres from postgresql.org...

You pretty much need to install from the same repo for PostGIS.
Otherwise you will most likely run into compatibility issues.

From here:

https://apt.postgresql.org/pub/repos/apt/pool/main/p/postgis/

I only see 3.0.1 and 3.0.3 as options.

A more complete answer will need to come from one of the maintainers.

Marc MILLAS
Senior Architect
+33607850334
www.mokadb.com <http://www.mokadb.com&gt;

--
Adrian Klaver
adrian.klaver@aklaver.com

On 7/18/22 13: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 ?

thanks

Marc MILLAS
Senior Architect
+33607850334
www.mokadb.com <http://www.mokadb.com&gt;

Install alien and convert the .rpm package into the .deb package. When
dealing with alien be careful, so that it doesn't jump and stick to your
face. Bad things can happen then....

--
Mladen Gogala
Database Consultant
Tel: (347) 321-1217
https://dbwhisperer.wordpress.com

Thanks Adrian

still, I see a bunch of files, and nothing that can be installed via
apt-get install.
The only "things" big enough to contain a postgis distrib, like
https://apt.postgresql.org/pub/repos/apt/pool/main/p/postgis/postgis_3.0.3%2Bdfsg.orig.tar.xz

can obviously not be installed via apt.

what am I missing ??

Marc MILLAS
Senior Architect
+33607850334
www.mokadb.com

On Tue, Jul 19, 2022 at 12:09 AM Adrian Klaver <adrian.klaver@aklaver.com>
wrote:

On 7/19/22 9:01 AM, Marc Millas wrote:

Thanks Adrian

still, I see a bunch of files, and nothing that can be installed via
apt-get install.
The only "things" big enough to contain a postgis distrib, like
https://apt.postgresql.org/pub/repos/apt/pool/main/p/postgis/postgis_3.0.3%2Bdfsg.orig.tar.xz
<https://apt.postgresql.org/pub/repos/apt/pool/main/p/postgis/postgis_3.0.3%2Bdfsg.orig.tar.xz&gt;

can obviously not be installed via apt.

what am I missing ??

What does:

apt-cache search postgresql-12-postgis

return?

Marc MILLAS
Senior Architect
+33607850334
www.mokadb.com <http://www.mokadb.com&gt;

--
Adrian Klaver
adrian.klaver@aklaver.com

just... nothing !

Marc MILLAS
Senior Architect
+33607850334
www.mokadb.com

On Tue, Jul 19, 2022 at 6:36 PM Adrian Klaver <adrian.klaver@aklaver.com>
wrote:

On 7/19/22 9:51 AM, Marc Millas wrote:

just... nothing !

I thought you said you used the Postgres community repo to install
Postgres.

Is that not the case?

Marc MILLAS
Senior Architect
+33607850334
www.mokadb.com <http://www.mokadb.com&gt;

--
Adrian Klaver
adrian.klaver@aklaver.com

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):

It is. I do begin with the postgres site script:

sudo sh -c 'echo "deb http://apt.postgresql.org/pub/repos/apt
$(lsb_release -cs)-pgdg main" > /etc/apt/sources.list.d/pgdg.list'

so...

Marc MILLAS
Senior Architect
+33607850334
www.mokadb.com

On Tue, Jul 19, 2022 at 6:54 PM Adrian Klaver <adrian.klaver@aklaver.com>
wrote:

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
www.mokadb.com

On Tue, Jul 19, 2022 at 7:20 PM Imre Samu <pella.samu@gmail.com> wrote:

On 7/19/22 11:19, Marc Millas wrote:

It is. I do begin with the postgres site script:

sudo sh -c 'echo "debhttp://apt.postgresql.org/pub/repos/apt <http://apt.postgresql.org/pub/repos/apt&gt; $(lsb_release -cs)-pgdg main" > /etc/apt/sources.list.d/pgdg.list'

so...

Have you run?:

sudo apt update

Marc MILLAS
Senior Architect
+33607850334
www.mokadb.com <http://www.mokadb.com&gt;

--
Adrian Klaver
adrian.klaver@aklaver.com

I did run each step of the script and did install a postgres 12.11.
then destroyed the instance created by the script, and, then
pg_createcluster a new one, which is running fine.
Marc MILLAS
Senior Architect
+33607850334
www.mokadb.com

On Tue, Jul 19, 2022 at 8:42 PM Adrian Klaver <adrian.klaver@aklaver.com>
wrote:

On 7/19/22 2:09 PM, Marc Millas wrote:

I did run each step of the script and did install a postgres 12.11.
then destroyed the instance created by the script, and, then
pg_createcluster a new one, which is running fine.

Does this mean you have PostGIS installed now?

Marc MILLAS
Senior Architect
+33607850334
www.mokadb.com <http://www.mokadb.com&gt;

--
Adrian Klaver
adrian.klaver@aklaver.com

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/
<http://apt.postgresql.org/pub/repos/apt/&gt; bullseye-pgdg main 12"* repo

*root@6b22a4450d93:/# cat /etc/apt/sources.list.d/pgdg.listdeb [
signed-by=/usr/local/share/keyrings/postgres.gpg.asc ]
http://apt.postgresql.org/pub/repos/apt/
<http://apt.postgresql.org/pub/repos/apt/&gt; 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
/messages/by-id/E1nJY2B-0006m6-IM@atalia.postgresql.org

( My knowledge is limited .. )
and there is a dedicated Postgis mail list:
- https://lists.osgeo.org/mailman/listinfo/postgis-users
and a Debian packaging mail list:
- https://www.postgresql.org/list/pgsql-pkg-debian/

Regards,
Imre

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

Postgres installed, but not postgis.. which is why I need some help...

Marc MILLAS
Senior Architect
+33607850334
www.mokadb.com

On Tue, Jul 19, 2022 at 11:43 PM Adrian Klaver <adrian.klaver@aklaver.com>
wrote:

You've never shown us *exactly what you did*, along with any *error messages*.

On 7/19/22 22:07, Marc Millas wrote:

Postgres installed, but not postgis.. which is why I need some help...

Marc MILLAS
Senior Architect
+33607850334
www.mokadb.com <http://www.mokadb.com&gt;

On Tue, Jul 19, 2022 at 11:43 PM Adrian Klaver <adrian.klaver@aklaver.com>
wrote:

On 7/19/22 2:09 PM, Marc Millas wrote:

I did run each step of the script and did install a postgres 12.11.
then destroyed the instance created by the script, and, then
pg_createcluster a new one, which is running fine.

Does this mean you have PostGIS installed now?

Marc MILLAS
Senior Architect
+33607850334
www.mokadb.com <http://www.mokadb.com&gt; <http://www.mokadb.com&gt;

--
Adrian Klaver
adrian.klaver@aklaver.com

--
Angular momentum makes the world go 'round.

???

I did describe precisely what I did:

On 7/19/22 2:09 PM, Marc Millas wrote:

I did run each step of the script and did install a postgres 12.11.
then destroyed the instance created by the script, and, then
pg_createcluster a new one, which is running fine.

no error messages.. Postgres is fine.

My question i(from the beginning) s about the availability of a *postgis *3.0.x
distro for postgres 12 on debian 11.
and, if yes, the name of the package, and the @ of the repo.

To my understanding, such a *postgis* distro does not exist in the
postgresql.org repos
so through this mail list, I was trying to know if it may exist somewhere.

I know that I am supposed to post such a question on the postgis mail list.
But.. I register thru the postgis web site, and didnt get any answer.
...

Marc MILLAS
Senior Architect
+33607850334
www.mokadb.com

On Wed, Jul 20, 2022 at 10:25 AM Ron <ronljohnsonjr@gmail.com> wrote: