Re: Issue installing postgis on RHEL9

; nobest' to > use not only best candidate packages) > > I have epel enabled and the only version of armadillo available is > 12.6.6-2.el9 > > Does anyone have any suggestions on how to resolve the issue? I haven't been maintaining PostGIS 3.0 RPMs for a while. Let

Issue installing postgis on RHEL9

Hello, I am having issues trying to install the postgis30_13 package on a RHEL9 host. Attempting to install the package gives me this error: $ sudo dnf install postgis30_13 Updating Subscription Management repositories. Zabbix 6.0 LTS RHEL9 50 kB/s | 2.0 kB

Re: Issue installing postgis on RHEL9

I have confirmed that the package installs successfully, thank you! On Wed, Apr 2, 2025 at 1:48 PM Devrim Gündüz wrote: > Hi, > > On Wed, 2025-04-02 at 11:29 -0500, Danny Im wrote: > > Problem: package postgis30_13-3.0.7-1.rhel9.x86_64 from postgresql > > requires gdal33-libs >= 3.3.3, but none

Re: Issue installing postgis on RHEL9

Hi, On Wed, 2025-04-02 at 11:29 -0500, Danny Im wrote: > Problem: package postgis30_13-3.0.7-1.rhel9.x86_64 from postgresql > requires gdal33-libs >= 3.3.3, but none of the providers can be > installed >   - package postgis30_13-3.0.7-1.rhel9.x86_64 from postgresql requires > libgdal.so.29()(64bit

Re: Issue installing postgis on RHEL9

It doesn't look like it. I tried to find what provides libarmadillo.so.10 but could not find any packages: $ sudo dnf provides */libarmadillo.so.10 Updating Subscription Management repositories. Last metadata expiration check: 0:20:05 ago on Wed Apr 2 11:17:43 2025. Error: No matches found. If s

Re: Issue installing postgis on RHEL9

On Wed, Apr 2, 2025 at 12:29 PM Danny Im wrote: > Hello, > > I am having issues trying to install the postgis30_13 package on a RHEL9 > host. Attempting to install the package gives me this error: > > $ sudo dnf install postgis30_13 > Updating Subscription Management repositories. > Zabbix 6.0 LT

Re: How to pass a list of locations (longitude, latitude) to a PostgreSQL/PostGIS stored function?

Thank you all. I would like to use a geometry type, but will it work well with the Npgsql C# packages? >

Re: How to pass a list of locations (longitude, latitude) to a PostgreSQL/PostGIS stored function?

On Tue, 25 Mar 2025 at 19:07, Tom Lane wrote: > Alexander Farber writes: > > Then I am trying to add a function, which would receive a series of > > locations (longitude and latitude pairs in microdegrees) and return a > list > > of lowercase 2-letter country codes, like "de", "pl", "lv": > > >

Re: How to pass a list of locations (longitude, latitude) to a PostgreSQL/PostGIS stored function?

El 25-03-25 a las 18:58, Christoph Berg escribió: Re: Tom Lane You might be best advised to create a composite type like "location (long bigint, lat bigint)" and use an array of that. Or use the geometry types from PostGIS, since you are probably going to do geo lookups on th

Re: How to pass a list of locations (longitude, latitude) to a PostgreSQL/PostGIS stored function?

Re: Tom Lane > You might be best advised to create a composite > type like "location (long bigint, lat bigint)" and use an array of > that. Or use the geometry types from PostGIS, since you are probably going to do geo lookups on these points anyway. Christoph

Re: How to pass a list of locations (longitude, latitude) to a PostgreSQL/PostGIS stored function?

Alexander Farber writes: > Then I am trying to add a function, which would receive a series of > locations (longitude and latitude pairs in microdegrees) and return a list > of lowercase 2-letter country codes, like "de", "pl", "lv": > CREATE OR REPLACE FUNCTION find_countries(locations BIGIN

How to pass a list of locations (longitude, latitude) to a PostgreSQL/PostGIS stored function?

Hello dear PostgreSQL users I have prepared a https://dbfiddle.uk/vOFXNgns for my question and also list my SQL code below. I have created a countires_boundaries table, which I intend to fill with .poly files provided at Geofabrik: CREATE EXTENSION IF NOT EXISTS postgis; CREATE TABLE

Fwd: Postgresql/Postgis: Trigger for historization/versioning

Good evening, I work with Postgresql 13, Postgis (and Qgis 3.22.) My need is to set up within my Postgis database (used for maps production), triggers for automation of data historization/versioning. The idea: For instance within a table 'BOREHOLE' (geometry: points), different upda

Re: postgis

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 impl

Re: postgis

> 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

Re: postgis

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

Re: postgis

gresql.org/pub/repos/apt/pool/main/p/postgis/ > > See my most recent reply to Marc on how to get at it. > > Right, I vaguely knew how to get at it while at the Linux terminal, wasn't my point. That does confirm that two releases are for sure missing and I'm doubting the 3.0.6 r

Re: postgis

> 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.

Re: postgis

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

Re: postgis

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

Re: postgis

> doesn’t actually understand how the PostGIS project handles versioning > > support. But i may be missing something as I’m doing this web-only and > > apt.postgresql.org <http://apt.postgresql.org> is basically impossible > > to inspect on the web. > > Are you looki

Re: postgis

On 7/20/22 07:57, David G. Johnston wrote: On Wednesday, July 20, 2022, Marc Millas <mailto:marc.mil...@mokadb.com>> 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 b

Re: postgis

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 >

Re: postgis

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

Re: postgis

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, Ju

Re: postgis

??? 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 i

Re: postgis

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 instal

Re: postgis

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 rep

Re: postgis

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> On Tue, Jul

Re: postgis

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

Re: postgis

> 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/> bullseye-pgdg main 12"* repo *root@6b22

Re: postgis

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

Re: postgis

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

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

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. &

Re: postgis

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

> 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

Re: postgis

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

t; 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/p

Re: postgis

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/pos

Re: postgis

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 install

Re: postgis

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> Install ali

Re: postgis

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

Re: postgis

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 in

Re: 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 ? Should have added to previous response, what version of Postgres? thanks Marc MILLAS Senior Architect

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

postgis

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

Re: logical replication worker can't find postgis function

OK thanks for the help, have a nice weekend! On Fri, Apr 22, 2022 at 3:39 PM Laurenz Albe wrote: > On Fri, 2022-04-22 at 15:26 +0200, Willy-Bas Loos wrote: > > On Fri, Apr 22, 2022 at 3:20 PM Laurenz Albe > wrote: > > > > > > The trigger function is bad and dangerous, because it relies on the >

Re: logical replication worker can't find postgis function

On Fri, 2022-04-22 at 15:26 +0200, Willy-Bas Loos wrote: > On Fri, Apr 22, 2022 at 3:20 PM Laurenz Albe wrote: > > > > The trigger function is bad and dangerous, because it relies on the current > > setting of "search_path". > > > > You notice that with logical replication, because "search_path

Re: logical replication worker can't find postgis function

On Fri, Apr 22, 2022 at 3:20 PM Laurenz Albe wrote: > > The trigger function is bad and dangerous, because it relies on the > current setting of "search_path". > > You notice that with logical replication, because "search_path" is empty > to avoid security problems. > Thanks a lot! Do you mean t

Re: logical replication worker can't find postgis function

On Fri, 2022-04-22 at 13:25 +0200, Willy-Bas Loos wrote: > I'm using logical replication on postgresql 13. On the subscriber, there's a > trigger on a table that calculates the area of the geometry that's in another > column. > I enabled the trigger with > ALTER TABLE atable ENABLE ALWAYS TRIGG

logical replication worker can't find postgis function

Hi! I'm using logical replication on postgresql 13. On the subscriber, there's a trigger on a table that calculates the area of the geometry that's in another column. I enabled the trigger with ALTER TABLE atable ENABLE ALWAYS TRIGGER atrigger; But the logical replication worker can't find st_are

Configuration and performance of Postgres/PostGIS

Whenever geospatial functions such as St_intersects or recursive query used, the Postgres/PostGIS appears to spawn away to many child queries and just obliterate the CPU. Nothing finishes. That forced me to try out to do the some tasks on the FME server. I tried to use this http

Re: FDW to postGIS Database

: Let say that I have a database named stp. I also have another database named geo that is a PostGIS database for storing geopolitical and geospatial data. I want to set up a foreign data wrapper in stp to connect to geo, so that for each address in stp, I only have to store the primary key

Re: FDW to postGIS Database

In line below... On Monday, March 7, 2022, 05:36:34 AM GMT+13, Susan Hurst wrote: Let say that I have a database named stp. I also have another database named geo that is a PostGIS database for storing geopolitical and geospatial data. I want to set up a foreign data wrapper in stp

FDW to postGIS Database

Let say that I have a database named stp. I also have another database named geo that is a PostGIS database for storing geopolitical and geospatial data. I want to set up a foreign data wrapper in stp to connect to geo, so that for each address in stp, I only have to store the primary key

Re: Postgis - geography function

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

Postgis - geography function

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 different results in version 3.2. So can you

Re: Postresql/postgis/qgis : assign privileges only for access/reading tables ?

Two thoughts: 1. Can the user view the tables when connecting through another database program (ie psql or PgAdmin)? 2. Does the user have access to the database schema that has the PostGIS extension (normally public schema)? cheers Ben On Thu, 14 Oct 2021 at 19:00, celati Laurent wrote

Postresql/postgis/qgis : assign privileges only for access/reading tables ?

Good morning, I work on Postgresql/postgis and Qgis. I had created a superuser account for me. In qgis, I can see the postgis schemas and tables and browse the tables without problem. This time, i created another simple user account just to be able in qgis to access and load the table in qgis

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

└─┴───┘ (0 rows) Time: 0,638 ms On Tue, Jun 22, 2021 at 11:30 PM Rhys A.D. Stewart wrote: > Greetings All, > > Firstly, apologies for cross posting. > I would like to create a table which will contain postGIS geometries, > specifically linestrings. Each line string should

Re: Debugging leaking memory in Postgresql 13.2/Postgis 3.1

Stephan Knauss writes: > On 31.03.2021 20:24, Tom Lane wrote: >> Based on nearby threads, it occurs to me to ask whether you have JIT >> enabled, and if so whether turning it off helps. There seems to be >> a known leak of the code fragments generated by that in some cases. > That's it! > You m

Re: Debugging leaking memory in Postgresql 13.2/Postgis 3.1

Hello Tom, On 31.03.2021 20:24, Tom Lane wrote: Based on nearby threads, it occurs to me to ask whether you have JIT enabled, and if so whether turning it off helps. There seems to be a known leak of the code fragments generated by that in some cases. That's it! I am quite surprised that a f

Re: Debugging leaking memory in Postgresql 13.2/Postgis 3.1

Full query logs are here: https://downloads.osm-tools.org/postgresql-2021-04-03_183913.csv.gz I have the following extensions installed. hstore is heavily used and a little bit postgis. gis=# SELECT extname FROM pg_extension;   extname ---  plpgsql  adminpack  postgis  hstore (4

Re: Debugging leaking memory in Postgresql 13.2/Postgis 3.1

> On Mar 31, 2021, at 11:24 AM, Tom Lane wrote: > > Stephan Knauss writes: >> Hello Tom, the output below looks similar to the OOM output you >> expected. Can you give a hint how to interpret the results? > > Looks like the answer is that wherever the leak is, it's not accounted > for by th

Re: Debugging leaking memory in Postgresql 13.2/Postgis 3.1

Stephan Knauss writes: > Hello Tom, the output below looks similar to the OOM output you > expected. Can you give a hint how to interpret the results? Looks like the answer is that wherever the leak is, it's not accounted for by this info; none of those contexts are particularly large. Based on

Re: Debugging leaking memory in Postgresql 13.2/Postgis 3.1

On 30.03.2021 20:46, Tom Lane wrote: Stephan Knauss writes: The wiki suggested to dump MemoryContext states for more details, but something strange happens when attaching gdb. It seems that the process is immediately killed and I can no longer dump such details. (I think the -v option is the o

Re: Debugging leaking memory in Postgresql 13.2/Postgis 3.1

Stephan Knauss writes: > The wiki suggested to dump MemoryContext states for more details, but > something strange happens when attaching gdb. It seems that the process > is immediately killed and I can no longer dump such details. You might try running the postmaster under a restrictive ulimit

Debugging leaking memory in Postgresql 13.2/Postgis 3.1

Hello, I have a setup in which I have constantly 8 connections to the database open which query data for map rendering. The query involve only a hand full of tables, but could be complex and use postgis functions. The connection stays open. Only read-requests are happening, no update/insert

Ist there a chance to provide postGIS 3.x combined with postgreSQL12 or 13 as a zypper repository released for SLES15 SP1 or SP2

valid zypper repository that can be used within our SUSE Manager environment. As far as we have seen, there doesn't seem to be a postGIS version available for SLES15 at the download directoy https://download.postgresql.org/pub/repos/zypp/ So we would like to ask, if there is a chance to prov

Re: postgis update wants to install postgresql-13

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.pgdg1

Re: postgis update wants to install postgresql-13

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

Re: postgis update wants to install postgresql-13

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 postgi

postgis update wants to install postgresql-13

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.0.2+dfsg-2.pgdg100+1 postgres

PostGIS missing from EDB Windows installer for PG13?

Good day, I just tried a fresh install of PostgreSQL 13 on Windows using the EDB installer, and I see that StackBuilder does not include an option to install PostGIS. Anyone have insight on whether that's a permanent change or not? Thanks, Anthony DeBarros Author, "Practical SQL"

Re: Querying PostgreSQL / PostGIS Databases in Python

We use Postgresql, python and PostGIS. Nearly all our data access is via Postgres functions, both DML and queries. Our system is a vehicle GPS tracking and business function analysis system, with quite a lot of data. Most of our reports require accessing hundreds to 100s of thousands of records

Re: Querying PostgreSQL / PostGIS Databases in Python

We are using python on top of Postgresql / PostGIS, for a vehicle tracking system. THis is quite data intensive, and we have some 'interesting' GIS queries where we see where a vehicle or fleet has stopped within specific areas, where it has traveled, any incidents along the way and

Re: Out of memory with "create extension postgis"

ownloads/72297/pg_store_plans12-1.4-1.el7.x86_64.rpm/ As soon as pg_store_plans is in shared_preload_libraries the postgis extension can not be installed anymore. This is the exact package list: [root@rhel77 ~]# rpm -qa | egrep "postgres|postgis|store_plan" postgresql12-server-12.3-5PGDG.rhel7.x86

Re: Out of memory with "create extension postgis"

.c, line 411. (gdb) cont Continuing. -- First session (nothing else, just creating the extension) # create extension postgis; -- Second session Breakpoint 1, errfinish (dummy=dummy@entry=0) at elog.c:411 411 elog.c: No such file or directory. (gdb) bt #0 errfinish (dummy=dummy@entry=0) at

Re: Querying PostgreSQL / PostGIS Databases in Python

You may write stored procedures using PL/pgSQL,alternatively you may write your queries in python. You may use psycopg2 to query the DB from Python. You may have a mix of the two, it will depend on your preference. Ideally you may not want your users running queries against the data by connecting t

Querying PostgreSQL / PostGIS Databases in Python

Hi, What is the advantage of querying in Python? Has anyone got much experience? What not just use standard query? What is the rationale for querying in Python? Would the performance be better? Regards, Shao

Re: Out of memory with "create extension postgis"

"Daniel Westermann (DWE)" writes: >> Umm ... you didn't issue a "bt" when you got to errfinish, so there's >> no useful info here. > Here is a new one with bt at the end: That's just showing the stack when the backend is idle waiting for input. We need to capture the stack at the moment when the

Re: Out of memory with "create extension postgis"

From: Tom Lane Sent: Wednesday, July 29, 2020 17:05 To: Daniel Westermann (DWE) Cc: pgsql-general@lists.postgresql.org Subject: Re: Out of memory with "create extension postgis"   "Daniel Westermann (DWE)" writes: >> So this is what we got today. In the log file the

Re: Out of memory with "create extension postgis"

uot;. > 2020-07-29 16:33:23 CEST 101995 STATEMENT:  create extension postgis; Is there not a dump of memory context sizes just before the "ERROR: out of memory" line? It should look something like TopMemoryContext: 68720 total in 5 blocks; 17040 free (15 chunks); 51680 used Message

Re: Out of memory with "create extension postgis"

>>>> "Daniel Westermann (DWE)" writes: >>>>> The process eats all the available memory and finally dies: >>>>> # create extension postgis; >>>>> ERROR:  out of memory >>>>> DETAIL:  Failed on request of size 8265

Re: Out of memory with "create extension postgis"

>>> "Daniel Westermann (DWE)" writes: >>>> The process eats all the available memory and finally dies: >>>> # create extension postgis; >>>> ERROR: out of memory >>>> DETAIL: Failed on request of size 8265691 in memory

Re: Out of memory with "create extension postgis"

"Daniel Westermann (DWE)" writes: >> "Daniel Westermann (DWE)" writes: >>> The process eats all the available memory and finally dies: >>> # create extension postgis; >>> ERROR: out of memory >>> DETAIL: Failed on request of

Re: Out of memory with "create extension postgis"

>"Daniel Westermann (DWE)" writes: >> we have a very strange behavior on PostgreSQL 12.3 when we try to create the >> extension postgis. Postgres and postgis have both been installed from >> packages: >> ... >> The process eats all the available mem

Re: Out of memory with "create extension postgis"

"Daniel Westermann (DWE)" writes: > we have a very strange behavior on PostgreSQL 12.3 when we try to create the > extension postgis. Postgres and postgis have both been installed from > packages: > ... > The process eats all the available memory and finally dies: >

Out of memory with "create extension postgis"

Hi, we have a very strange behavior on PostgreSQL 12.3 when we try to create the extension postgis. Postgres and postgis have both been installed from packages: postgresql12-server-12.3-5PGDG postgis30_12-3.0.1-5.rhel7 The OS is RedHat 7.7. Creating other extensions works fine, we only see

Re: gdal, proj and other postgis dependencies missing in postgres repos

ody, do you know what happened to gdal and other postgis >>> dependencies like proj in the official postgres repos? >>> they appear to be missing in these repos >>> >>> https://yum.postgresql.org/12/redhat/rhel-7-x86_64/ >>> https://yum.postgre

Re: gdal, proj and other postgis dependencies missing in postgres repos

On Sunday, June 7, 2020, Rene Romero Benavides wrote: > On Sun, Jun 7, 2020 at 5:37 PM Rene Romero Benavides < > rene.romer...@gmail.com> wrote: > >> Hi everybody, do you know what happened to gdal and other postgis >> dependencies like proj in the official postgres

Re: gdal, proj and other postgis dependencies missing in postgres repos

On Sun, Jun 7, 2020 at 5:37 PM Rene Romero Benavides < rene.romer...@gmail.com> wrote: > Hi everybody, do you know what happened to gdal and other postgis > dependencies like proj in the official postgres repos? > they appear to be missing in these repos > > https://yum.pos

gdal, proj and other postgis dependencies missing in postgres repos

Hi everybody, do you know what happened to gdal and other postgis dependencies like proj in the official postgres repos? they appear to be missing in these repos https://yum.postgresql.org/12/redhat/rhel-7-x86_64/ https://yum.postgresql.org/11/redhat/rhel-7-x86_64/ https://yum.postgresql.org/10

Re: gdal version for Postgis 2.4?

On 3/9/20 8:50 AM, Zwettler Markus (OIZ) wrote: I am in the same situation: I found that Postgis 24 depends on gdal30-libs.x86_64 0:3.0.4-2. But this installation creates an error : dbname=# create extension postgis; ERROR: could not load library "/usr/pgsql-11/lib/rtpostgis-2.4.so&q

gdal version for Postgis 2.4?

I am in the same situation: I found that Postgis 24 depends on gdal30-libs.x86_64 0:3.0.4-2. But this installation creates an error : dbname=# create extension postgis; ERROR: could not load library "/usr/pgsql-11/lib/rtpostgis-2.4.so": /usr/gdal30/lib/libgdal.so.26: undefi

Merge sort/postgis performance tweaking?

I have the following query: SELECT read_date, to_char(read_date,'-MM-DD') as text_date, CASE WHEN lat_2>lat_1 THEN ns_dist*-1 ELSE ns_dist END as ns_dist, CASE WHEN lon_2>lon_1 THEN ew_dist*-1

will postgresql-12-postgis-2.5 become available in the postgres repository?

Hello Everyone I installed Postgresql 11 using the Postgresql apt repository listed below deb http://apt.postgresql.org/pub/repos/apt/ buster-pgdg main and I was also able to install postgresql-11-postgis-2.5 I have now installed Postgresql 12, but no package named postgresql-12-postgis-2.5

Re: How to set up PostGIS to support ArcGIS, MapInfo and QGIS desktop users?

This is probably the wrong place to ask. Have a look at the POSTGis support options <https://postgis.net/support/> page. Stack Exchange has a lot of info. Also go to the particular products that you are interested in, they should have their requirements listed. You will likely also want

How to set up PostGIS to support ArcGIS, MapInfo and QGIS desktop users?

Hi, I should be grateful if anyone can offer insight into how to set up PostGIS to support ArcGIS, MapInfo and QGIS desktop users. Looking forward to hearing from you. Regards, Shao

  1   2   >