Re: postgis

2022-07-20 Thread Marc Millas
right. so I scratch the debian vm, install a centos 7 and within minutes I have a postgres 12 with postgis 3.0.4 running. so easy. regards. Marc MILLAS Senior Architect +33607850334 www.mokadb.com On Wed, Jul 20, 2022 at 7:27 PM Imre Samu wrote: > > I would expect the 35 packages implied by

Re: postgis

2022-07-20 Thread Imre Samu
> I would expect the 35 packages implied by the version policies of those two projects. Based on my docker-postgis support - the "geos" is also important. Now Bullseye(Debian11) geos version is 3.9 - and this is likely to continue until the end of the cycle ( so no upgrade expected to 3.10,3.11)

Re: postgis

2022-07-20 Thread David G. Johnston
On Wed, Jul 20, 2022 at 9:21 AM Imre Samu wrote: > > My general impression is that the packaging, at least for Debian, > > doesn’t actually understand how the PostGIS project handles versioning > support. > > But i may be missing something > > "PostGIS Pre-built Binary Distributions for various O

Re: postgis

2022-07-20 Thread David G. Johnston
On Wed, Jul 20, 2022 at 9:16 AM Adrian Klaver wrote: > On 7/20/22 08:55, David G. Johnston wrote: > > > That is what I found, and nowhere on the web can I find confirmation of > > the existence of the package: > > > > 3.0.3+dfsg-2.pgdg+1 > > https://apt.postgresql.org/pub/repos/apt/pool/main/p/po

Re: postgis

2022-07-20 Thread Imre Samu
> My general impression is that the packaging, at least for Debian, > doesn’t actually understand how the PostGIS project handles versioning support. > But i may be missing something "PostGIS Pre-built Binary Distributions for various OS" ---> https://trac.osgeo.org/postgis/wiki/UsersWikiPackages

Re: postgis

2022-07-20 Thread Adrian Klaver
On 7/20/22 08:55, David G. Johnston wrote: That is what I found, and nowhere on the web can I find confirmation of the existence of the package: 3.0.3+dfsg-2.pgdg+1 https://apt.postgresql.org/pub/repos/apt/pool/main/p/postgis/ See my most recent reply to Marc on how to get at it. Even th

Re: postgis

2022-07-20 Thread Adrian Klaver
On 7/20/22 07:21, Marc Millas wrote: Thanks for your answer. I would like to avoid compiling as much as possible. I know that postgis 3.2.1 is available and does install without pb. but.. That db run an app which is very long to test, so I need to stick to a postgis 3.0.x Alright as close as c

Re: postgis

2022-07-20 Thread David G. Johnston
On Wed, Jul 20, 2022 at 8:36 AM Adrian Klaver wrote: > On 7/20/22 07:57, David G. Johnston wrote: > > On Wednesday, July 20, 2022, Marc Millas > > wrote: > > > My general impression is that the packaging, at least for Debian, > > doesn’t actually understand how the

Re: postgis

2022-07-20 Thread Adrian Klaver
On 7/20/22 07:57, David G. Johnston wrote: On Wednesday, July 20, 2022, Marc Millas > wrote: My general impression is that the packaging, at least for Debian, doesn’t actually understand how the PostGIS project handles versioning support.  But i may be missing so

Re: postgis

2022-07-20 Thread David G. Johnston
On Wednesday, July 20, 2022, Marc Millas wrote: > Thanks for your answer. > I would like to avoid compiling as much as possible. > I know that postgis 3.2.1 is available and does install without pb. but.. > That db run an app which is very long to test, so I need to stick to a > postgis 3.0.x >

Re: postgis

2022-07-20 Thread Marc Millas
Thanks for your answer. I would like to avoid compiling as much as possible. I know that postgis 3.2.1 is available and does install without pb. but.. That db run an app which is very long to test, so I need to stick to a postgis 3.0.x regards, Marc MILLAS Senior Architect +33607850334 www.mokadb

Re: postgis

2022-07-20 Thread jian he
Can you try compiling from source: https://postgis.net/source/ postgis 3.2.1 is OK. postgresql & postgis version info: https://trac.osgeo.org/postgis/wiki/UsersWikiPostgreSQLPostGIS if you already installed check postgis version: https://postgis.net/docs/PostGIS_Version.html On Wed, Jul 20, 2022

Re: postgis

2022-07-20 Thread Marc Millas
??? I didnt get any error, as I dont know the name of the package to be installed !!! my question was, and still is: "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 ?" so.. the only info on the deb

Re: postgis

2022-07-20 Thread Ron
This long drama is about *POSTGIS*, not Postgresql.  What error do you get when trying to install *POSTGIS*? On 7/20/22 08:26, Marc Millas wrote: ??? 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 post

Re: postgis

2022-07-20 Thread Marc Millas
??? 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.. Post

Re: postgis

2022-07-20 Thread Ron
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 On Tue, Jul 19, 2022 at

Re: postgis

2022-07-19 Thread Marc Millas
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 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

Re: postgis

2022-07-19 Thread Imre Samu
> 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/sourc

Re: postgis

2022-07-19 Thread Adrian Klaver
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 Archite

Re: postgis

2022-07-19 Thread Marc Millas
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 wrote: > On

Re: postgis

2022-07-19 Thread Adrian Klaver
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 $(lsb_release -cs)-pgdg main" > /etc/apt/sources.list.d/pgdg.list' so... Have you run?: sudo apt u

Re: postgis

2022-07-19 Thread Marc Millas
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 wrote: > > I would like to install postgis 3.04 on a debian 11 > > postgres 12. > > I may use wh

Re: postgis

2022-07-19 Thread Marc Millas
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 wro

Re: postgis

2022-07-19 Thread Imre Samu
> 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

Re: postgis

2022-07-19 Thread Adrian Klaver
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 -- Adrian Klaver adrian.kla...@aklaver.com

Re: postgis

2022-07-19 Thread Marc Millas
just... nothing ! Marc MILLAS Senior Architect +33607850334 www.mokadb.com On Tue, Jul 19, 2022 at 6:36 PM Adrian Klaver 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

Re: postgis

2022-07-19 Thread Adrian Klaver
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.

Re: postgis

2022-07-19 Thread Marc Millas
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.

Re: postgis

2022-07-19 Thread Mladen Gogala
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 Install alien and c

Re: postgis

2022-07-18 Thread Adrian Klaver
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/r

Re: postgis

2022-07-18 Thread Marc Millas
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 wrote: > On 7/18/22 10:08, Marc Millas wrote: > > Hi, > > > > I would like to install postgis 3.04 on a

Re: postgis

2022-07-18 Thread Adrian Klaver
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 +33

Re: postgis

2022-07-18 Thread Adrian Klaver
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 Se

Re: Postgis - geography function

2022-01-05 Thread Tomas Vondra
On 1/5/22 09:48, Sameer TWAYANA wrote: Hi Sir, I need some help. I have been using the postgis extension for many years. Now in postgis version 3.2 using geom data in geography with ST_Length and ST_Distance function returns some weird results. Before I used 3.1.4, all was good. But I got dif

Re: [postgis-users] Exclusion constraint with custom operator not working as expected

2021-06-23 Thread Komяpa
Hello, The reason why constraint is not working is that GIST scan using your operator does not return what you expect. Deeper debugging needed on your side to fix that select to return the rows you need. 12:23:37 [kom] > explain select * from test_1 where g |*| 'LINESTRING(10 10,50 50)'; ┌──

Re: postgis update wants to install postgresql-13

2020-10-27 Thread Adrian Klaver
On 10/26/20 10:53 PM, Hu Bert wrote: Hi Adrian, thx for your answer. I checked all the relevant & installed packages: hi postgis 3.0.2+dfsg-2.pgdg100+1 ii postgis-doc 3.0.2+dfsg-2.pgdg100+1 ii postgresql-12 12.4-1.pgdg100+1

Re: postgis update wants to install postgresql-13

2020-10-27 Thread Hu Bert
Hi Adrian, thx for your answer. I checked all the relevant & installed packages: hi postgis 3.0.2+dfsg-2.pgdg100+1 ii postgis-doc 3.0.2+dfsg-2.pgdg100+1 ii postgresql-12 12.4-1.pgdg100+1 ii postgresql-12-postgis-2.5 2

Re: postgis update wants to install postgresql-13

2020-10-26 Thread Adrian Klaver
On 10/26/20 6:34 AM, Hu Bert wrote: Hi there, i hope i'm right here... i just wanted to install some debian updates (buster) and saw that there are postgres/postgis updates as well. Currently installed: postgis 3.0.2+dfsg-2.pgdg100+1 postgis-doc 3

Re: postgis after pg_upgrade

2018-12-06 Thread Adrian Klaver
On 12/6/18 12:40 AM, Slavcho Trnkovski wrote: Hi, But my understanding is that this approach is used when upgrading PostGIS. Which maybe necessary when upgrading the database: http://postgis.net/docs/manual-2.4/postgis_installation.html#upgrading Which seems to be what is happening in your ca

Re: postgis after pg_upgrade

2018-12-06 Thread Slavcho Trnkovski
Hi, But my understanding is that this approach is used when upgrading PostGIS. I'm upgrading postgresql from 9.4 to 9.6 and PostGIS version remains the same (2.4.5). If I execute: drop extension postgis; CREATE EXTENSION postgis SCHEMA postgis; select PostGIS_full_version(); postgis_full_v

Re: postgis after pg_upgrade

2018-12-04 Thread Jeremy Schneider
On 11/30/18 05:11, Slavcho Trnkovski wrote: > I have postgresql 9.4 with postgis extension installed (latest version, > 2.4.5). I upgraded postgresql from 9.4 to 9.6.  > After upgrading to 9.6 I get the following result > from PostGIS_full_version() >  select PostGIS_full_version(); > >  ... (proc

Re: postgis after pg_upgrade

2018-12-03 Thread Adrian Klaver
On 12/1/18 8:56 AM, Slavcho Trnkovski wrote: Hi, This will not resolve the issue I have because extension is already to the latest version, but it is using postgres 9.4 and it should use 9.6. Well according to below: POSTGIS="2.4.5 r16765" According to this: http://postgis.net/source/ pos

Re: postgis after pg_upgrade

2018-12-03 Thread Rene Romero Benavides
Are the postgis functions usable? do they currently work ? any error messages in the database server logs ? have you installed the postgis binaries for postgres 9.6? if you follow the given advise by Paul Ramsey, what happens? Am So., 2. Dez. 2018 um 14:24 Uhr schrieb Slavcho Trnkovski < strnkov..

Re: postgis after pg_upgrade

2018-12-02 Thread Slavcho Trnkovski
Hi, This will not resolve the issue I have because extension is already to the latest version, but it is using postgres 9.4 and it should use 9.6. Regards, Slavcho On Fri, Nov 30, 2018 at 6:01 PM Paul Ramsey wrote: > If you install the new version, and then use ‘ALTER EXTENSION UPDATE’ to > up

Re: postgis after pg_upgrade

2018-11-30 Thread Paul Ramsey
If you install the new version, and then use ‘ALTER EXTENSION UPDATE’ to update the SQL-side bindings, everything should improve. > On Nov 30, 2018, at 5:11 AM, Slavcho Trnkovski wrote: > > Hi, > > I have postgresql 9.4 with postgis extension installed (latest version, > 2.4.5). I upgraded po