RE: Segmentation fault restoring data to Azure VM

are running with 3.11.1. In theory that shouldn't be an issue since 3.10.2 is upward compatible with 3.11. Everything else at a glance looks to be in shape. Hope that helps, Regina From: Jeffrey Durrence Sent: Tuesday, April 23, 2024 1:21 PM To: Regina Obe ; postgis-users

RE: Segmentation fault restoring data to Azure VM

What does SELECT postgis_full_version(); Run on your current setup vs. your Azure VM setup. Might thinking is it might be a dependent library crashing. Usually the issues are with postgis_raster extension since that drags in GDAL which drags in several more libraries. Could

RE: need help

I'd check to make sure hibernate has usage rights and execute for all functions. I recall they changed that in PG 15 I think it was. From: Bekir Niyaz Sent: Wednesday, April 3, 2024 4:52 AM To: postgis-users@lists.osgeo.org Subject: need help Hello again I updated postgis from 3.0 to

RE: Buildbot

Should be back up now. From: Gandalf the Gray Sent: Thursday, April 4, 2024 4:32 AM To: PostGIS Users Discussion Subject: Buildbot Hi guys. It seems Winnie is down again. Pieter

RE: Continuing on clustering queries

> [... deleting for the sake of brevity ...] > > >> This SQL variant does not return errors, but it isn't visible in my > >> QGIS > > project > >> (it's an ongoing project with about twenty layers built with PostGIS). > >> > >> Any advice? > >> > >> Should I direct this inquiry to the QGIS list?

RE: Continuing on clustering queries

> The reason is that it doesn't seem that QGIS can work w TEMP tables. > TEMP tables are only visible to the session that created them, so not a huge surprise QGIS can't work with them. I use them mostly to store intermediary results before dumping to another table. > From this, I want to

RE: Continuing on clustering queries

> Thank you again; results are starting to come in. > > Apologies for starting a new thread; but the other one was getting messy. > > Here are the queries that I am testing: > SELECT city, state, ST_ClusterDBScan( ST_Transform(geom,2163), eps := > 0.3048*5000, minpoints :=1) OVER () AS

RE: Running clustering queries

> Depends where you got the data, but generally if they give you longitude > latitude Columns, then 4326 is a safe assumption and looks like you created > the geometry right too. > > To Gary's point, 4326 is degree based, so no wonder you aren't getting any > meaningful answers since 1000 would

RE: Running clustering queries

> On Thu, 28 Mar 2024, Gary Turner wrote: > > > > > On 28/03/2024 12:32 pm, Max Pyziur wrote: > >> On Wed, 27 Mar 2024, Regina Obe wrote: > >> > >>> That's the function I would have suggested. > >>> > >>> What query are you

RE: Running clustering queries

That's the function I would have suggested. What query are you trying to run and what is the spatial reference system id for your data. I'm guessing the issue might be your units of measure. If you want to do 500 ft you'd be best using a meter or mile based spatial reference system. >

RE: How to properly rotate a raster

to raster. On Tuesday, March 19th, 2024 at 14:58, Regina Obe mailto:l...@pcorp.us> > wrote: An easier way to compare what is happening is to look at the ST_Polygon output of the two. https://postgis.net/docs/en/RT_ST_Polygon.html I’m thinking the confusion (which I had t

RE: Determining postgis version from pg_dump

I don’t think so. As I recall when you do a pg_dump, it just stores the CREATE EXTENSION … line without a VERSION so you can’t tell. I could be mistaken though. From: B H Sent: Friday, March 22, 2024 2:50 PM To: PostGIS Users Discussion Subject: Determining postgis version from

RE: How to properly rotate a raster

1000 | 1000 | 0.09481479675190897 Cheers, Eloi On Monday, March 18th, 2024 at 14:01, Regina Obe mailto:l...@pcorp.us> > wrote: By size, what do you mean exactly? It would change the width and height. What are you expecting rotation to do. Perhaps you can give example out o

RE: How to properly rotate a raster

By size, what do you mean exactly? It would change the width and height. What are you expecting rotation to do. Perhaps you can give example out of the below and some sample ST_Width, ST_Height, ST_SkewX before and after and what you were expecting.

RE: Is there a guide on what and how to do with PostGIS configuration to speed up operations like interecting

There isn’t a single guide I can think of. Generally the key factors I can think of for speeding intersects, are make sure you have spatial indexes in place, parallelization, and memory. Here is one that details how to config params for parallelization

RE: PostGIS performance issue

And the query? From: Shaozhong SHI Sent: Monday, March 18, 2024 7:57 AM To: Regina Obe Cc: PostGIS Users Discussion Subject: Re: PostGIS performance issue product_assurance=# SELECT version(), postgis_full_version(); version

RE: Database crash when creating raster_in function

Sent: Sunday, March 17, 2024 9:49 AM To: Regina Obe Cc: PostGIS Users Discussion Subject: Re: Database crash when creating raster_in function I am are using raster extension The creation of raster_in function breaks on PG15 as well, JFYI, I have created package for 3.3.5 on rhel7

RE: Database crash when creating raster_in function

Yap that was fixed in PostGIS 3.3.3. The change there was to support a change in PG16, so you shouldn’t need it for upgrading from PG13 to PG15. Are you using postgis_raster or you just have it installed? If you don’t need postgis_raster, I would suggest uninstalling it before

RE: Error during gdal 3.5.3 Installation dependency libarmadillo

> Hi, > > On Tue, 2024-03-12 at 15:12 +0530, Nikhil Shetty wrote: > > I have a requirement to go with v3.3.3 for RHEL8 as of now. > > What forces you to install and old and buggy version? > Yah PostGIS 3.3.6 is latest for 3.3 minor and 3.3 is not the latest stable minor. I would push back on

RE: Error when parsing GML with st_geomfromgml

You are missing double-quotes, on the xmlns schemes, but even putting those in, I still get an ERROR: invalid GML representation I haven't tried ST_GeomFromGML with curved geometries before or added namespaces, so it's possible curves are not supported since there is no mention on the page

RE: The intersect function does not utilize indexes

1:05 AM To: Regina Obe Cc: PostGIS Users Discussion Subject: Re: The intersect function does not utilize indexes I am very happy to have found the reason. The client's development database is based on pg12. They modified the nodes.h file and added two enumerations above

RE: Options to rollback PostGIS upgrade

to hack the version checks in postgis_extensions_upgrade(). From: Nikhil Shetty Sent: Monday, February 26, 2024 11:20 AM To: Regina Obe Cc: PostGIS Users Discussion Subject: Re: Options to rollback PostGIS upgrade Hi Regina, We are upgrading from 3.1.2 to 3.3.3. So, after we run

RE: Options to rollback PostGIS upgrade

Which version of PostGIS are you coming from again? In theory, as long as your old is running a newish PostGIS 3+, it should be safe enough to just NOT run SELECT postgis_extensions_upgrade(); If you don’t run that, then your database is just running with a newer lib file, but old

RE: PostGIS 3.3 latest releases unavailable for rhel7

yum.postgresql.org has already discontinued support for rhel-7 so I would presume so. From: Nikhil Shetty Sent: Monday, February 26, 2024 6:27 AM To: PostGIS Users Discussion Subject: PostGIS 3.3 latest releases unavailable for rhel7 Hi Team, I was not able to find the rpm

RE: The intersect function does not utilize indexes

: Dapeng Wang Sent: Sunday, February 25, 2024 9:09 AM To: Regina Obe Cc: PostGIS Users Discussion Subject: Re: The intersect function does not utilize indexes The version installed is 3.4.1, which is already the latest version. I'll navigate upwards from the "Cache Lookup Error"

RE: The intersect function does not utilize indexes

postgis_full_version(); Doesn’t say you need updates. If it does make sure to run SELECT postgis_extensions_upgrade(); From: Dapeng Wang Sent: Friday, February 23, 2024 8:25 PM To: Regina Obe Cc: PostGIS Users Discussion Subject: Re: The intersect function does not utilize indexes

RE: The intersect function does not utilize indexes

You have an example query where you are seeing this behavior? From: Dapeng Wang Sent: Thursday, February 22, 2024 8:57 PM To: PostGIS Users Discussion Subject: The intersect function does not utilize indexes Hello everyone, I have a client with a database developed on PostgreSQL 12,

RE: PostGIS performance issue

Possible or one of the dependencies is different, or planner differences such as the CTE changes that came in PostgreSQL 12, but hard to tell given the information you have provided Or you didn’t reindex your data after the upgrade to a newer version of PostgreSQL and such a reindex was

RE: GDAL dependencies during PostGIS upgrade

: Tuesday, February 20, 2024 11:33 PM To: Regina Obe Cc: PostGIS Users Discussion Subject: Re: GDAL dependencies during PostGIS upgrade Hi, I tired installing the single package but still the same error yum install -y postgis33_15-client-3.3.5-1PGDG.rhel8.x86_64.rpm Last metadata

RE: GDAL dependencies during PostGIS upgrade

, so you only need one of them. Alternatively just remove the postgis_33_13_client From: Nikhil Shetty Sent: Tuesday, February 20, 2024 12:07 PM To: Regina Obe Cc: PostGIS Users Discussion Subject: Re: GDAL dependencies during PostGIS upgrade Hi Regina, I upgraded the existing

RE: GDAL dependencies during PostGIS upgrade

Nikhil, Which version of PostgreSQL are you upgrading from. I forget if pg_upgrade checks the old .so to see if it can still load it or if it only checks if the new .so it is expecting in the new cluster is still available. If it doesn’t check the old to try to load the lib, dropping

RE: pgr_alphashape is returning a geometry collection?

Can you give us an example you are getting this for? It should be returning a polygon. From: Alexandre Neto Sent: Monday, February 5, 2024 7:14 AM To: PostGIS Users Discussion Subject: pgr_alphashape is returning a geometry collection? I am trying to use pgr_alphashape to convert a

RE: Postgres segfaults on raster query

> This seems… odd to me? In what context is putting postgis into the preload a > requirement? > > P > > > On Jan 18, 2024, at 8:20 PM, Scott wrote: > > > > Bam! > > > > That was it. Thanks Regina, you rock! > > > > O

RE: Postgres segfaults on raster query

> Here's what's happening: > > psql -d mydb > > select rid from rastertable where rid = 1; > > Psql connection drops, postgres segfaults and restarts. > > BUT, if I do a query such as this FIRST: > > select postgis_full_version(); > > Then do other raster queries, it works fine. I suspect I

RE: Current postgis builds broken???

Looks like you might be missing epel-release Did you already do dnf -y install epel-release as detailed here - https://postgis.net/documentation/getting_started/install_red_hat/ You might get more answers on the https://www.postgresql.org/list/pgsql-pkg-yum/ mailing list.

[postgis-users] OSGeo Discourse - Mirroring of the mailing lists and eventual move to discourse

As some of you may have noticed, we have set up discourse on OSGeo infra. https://discourse.osgeo.org/ The initial plan is just import the lists and mirror the mailing lists, so we have a more searchable archive of results (similar to what the now defunct Nabble provided which many people

Re: [postgis-users] Operator does not exist: <<#>>

See answers below. No trouble at all. Thanks for catching all these loose ends in the docs. Much appreciated, Regina From: Dapeng Wang Sent: Tuesday, December 26, 2023 10:26 PM To: Regina Obe Cc: PostGIS Users Discussion Subject: Re: [postgis-users] Operator does not exist

Re: [postgis-users] Operator does not exist: <<#>>

be true distance e.g SELECT ST_GeomFromText('MULTIPOINT(1 3 2, 0 0 0)') <<->> ST_GeomFromText('LINESTRING(1 1 1, 5 5 5)') returns 1.4142135623730951 Which is the same answer as SELECT ST_3DDistance(ST_GeomFromText('MULTIPOINT(1 3 2, 0 0 0)'), ST_GeomFromText('LINESTRING(0

Re: [postgis-users] Operator does not exist: <<#>>

I concur doesn’t seem to exist. I’m trying to think how that would ever have been different from <#>. I recall there was a time before we had true KNN for geometry that one was for bounding box distance and one was for the centroid bounding box distance. Anyway I’ll remove from the

Re: [postgis-users] Sample SQL statement showing error

I’ve ticketed the issue here https://trac.osgeo.org/postgis/ticket/5645 From: Regina Obe Sent: Friday, December 15, 2023 5:47 PM To: 'PostGIS Users Discussion' ; 'Sandro Santilli' Cc: 'Dapeng Wang' Subject: RE: [postgis-users] Sample SQL statement showing error Ah sorry about

Re: [postgis-users] Sample SQL statement showing error

Ah sorry about that. At @Sandro Santilli I think this is caused by the logic we have maybe to try to do something with XML entities I had put in the PostgreSQL touched => true To allow setting defaults while skipping other defaults. It seems for the

Re: [postgis-users] out db: not able to query the raster

Yah the data directory is less likely to have screwed up permissions that the postgres account can’t access. So I would go with Jorge’s idea. That said I would think that having permission with r r r should do the trick and the fact you can get a directory listing suggests the postgres

Re: [postgis-users] out db: not able to query the raster

Are you running postgres inside the docker container or are you using your own? I wasn’t clear if you are just using the raster2pgsql from docker or you are using the postgresql as well. It’s possible inside the container it doesn’t know the path as such. Try this query in your

Re: [postgis-users] raster2pgsql gives me segmentation fault

than in-db. If we can isolate it down a bit more to being an out-db or permission issue that would help. From: andy Sent: Monday, December 4, 2023 10:08 AM To: Regina Obe Cc: PostGIS Users Discussion Subject: Re: [postgis-users] raster2pgsql gives me segmentation fault Thank

Re: [postgis-users] raster2pgsql gives me segmentation fault

Which version of PostGIS and PostgreSQL are you running? SELECT postgis_full_version(), version(); Also is the data publicly accessible so we can test it out? If you can try it with https://github.com/postgis/docker-postgis as Imre suggested, that would be great too. I also assume

Re: [postgis-users] ST_DWithin slow if query is joined to another table, but fast if ST_DWithin cast to an integer

. From: Cameron McCloud Sent: Tuesday, November 28, 2023 9:45 AM To: Regina Obe Subject: Re: [postgis-users] ST_DWithin slow if query is joined to another table, but fast if ST_DWithin cast to an integer This is what I get from that query: IMMUTABLE PARALLEL SAFE STRICT COST 1

Re: [postgis-users] ST_DWithin slow if query is joined to another table, but fast if ST_DWithin cast to an integer

idth=4) (actual time=0.007..0.931 rows=16000 loops=1) Planning Time: 0.132 ms JIT: Functions: 12 Options: Inlining false, Optimization false, Expressions true, Deforming true Timing: Generation 0.311 ms, Inlining 0.000 ms, Optimization 0.184 ms, Emission 4.085 ms, Total 4.580 ms E

[postgis-users] PostGIS 3.4.1 Windows Bundle for PostGIS 3.4.1 for PostgreSQL 12-16

The PostGIS 3.4.1 bundle windows installers and binaries are available now on Application Stackbuilder as well as osgeo downloads. Details at: https://postgis.net/documentation/getting_started/install_windows/released_v ersions/ Key highlights since PostGIS 3.4.1 1) pgRouting updated from 3.5.0

[postgis-users] Patch releases available for 3.4.1, 3.3.5, 3.2.6, 3.1.10, and 3.0.10

Patch releases available for 3.4.1, 3.3.5, 3.2.6, 3.1.10, and 3.0.10 Details and download links can be found at: https://postgis.net/2023/11/PostGIS-Patch-Releases/ Thanks, PostGIS Development Team ___ postgis-users mailing list

Re: [postgis-users] Windows compile instructions

-> Spatial Extensions. Thanks, Regina From: Gandalf the Gray Sent: Sunday, November 19, 2023 9:53 AM To: Regina Obe Subject: Re: Windows compile instructions Hi Regina There is actually a newer repository: https://github.com/postgrespro/pgsphere On Sat, Nov 18, 2

Re: [postgis-users] Generating new random points throughout an update

: Saturday, November 18, 2023 4:35 PM To: Regina Obe ; PostGIS Users Discussion Subject: Re: [postgis-users] Generating new random points throughout an update Thanks for your time & advice Regina, I appreciate it. I still can't get this to work as I think it should, so have incl

Re: [postgis-users] Generating new random points throughout an update

, random()::integer) then that would explain why you got much less than random results with ST_GeneratePoints. From: Brent Wood Sent: Saturday, November 18, 2023 1:29 AM To: Regina Obe ; PostGIS Users Discussion Subject: Re: [postgis-users] Generating new random points throughout an update

Re: [postgis-users] Generating new random points throughout an update

If you want the answer different each time, you don’t want to feed a seed to ST_GeneratePoints. The seed argument was added because some people wanted to generate the same answer for each run. https://postgis.net/docs/ST_GeneratePoints.html (note the sentence: The optional seed is used

Re: [postgis-users] Extracting variable information from netcdf, imported as raster to a table

are running into From: Regina Obe Sent: Thursday, November 16, 2023 9:46 PM To: 'Manaswini Ganjam' Cc: 'PostGIS Users Discussion' Subject: RE: [postgis-users] Extracting variable information from netcdf, imported as raster to a table I don’t know much about netCDF but I would

Re: [postgis-users] Extracting variable information from netcdf, imported as raster to a table

FROM ST_PixelAsCentroids(raster_record.clipped_raster, band_number, true) AS sc; From: Manaswini Ganjam Sent: Thursday, November 16, 2023 1:19 PM To: Regina Obe Cc: PostGIS Users Discussion Subject: Re: [postgis-users] Extracting variable information from netcdf, imported

Re: [postgis-users] Extracting variable information from netcdf, imported as raster to a table

ogr_fdw So do CREATE EXTENSION ogr_fdw; The list of supported formats you can see with this query: SELECT name FROM unnest(ogr_fdw_drivers()) AS f(name) ORDER BY name; Which for osgeolive 16, I see netCDF listed From: Regina Obe Sent: Wednesday, November 15

Re: [postgis-users] Extracting variable information from netcdf, imported as raster to a table

Just confirming some stuff, since I’m not completely following: Raster_record.rast column is of type raster correct? IF so ST_X and ST_Y won’t work since those are for geometry types. Also ST_Value(raster_record.rast, band_number), won’t work either since that expects as input a

Re: [postgis-users] par_psql code for queries

use. From: Regina Obe Sent: Tuesday, November 14, 2023 11:07 PM To: 'PostGIS Users Discussion' Cc: 'Manaswini Ganjam' Subject: RE: [postgis-users] par_psql code for queries I’m guessing your intention is to run this in separate connections cause otherwise sad to say you can’

Re: [postgis-users] par_psql code for queries

I’m guessing your intention is to run this in separate connections cause otherwise sad to say you can’t do this in parallel without having some sort of background processor. Something also seems incorrectly shuffled in your query. First of all, you want a COMMIT before your end LOOP

Re: [postgis-users] Grouping points based on distance

Use https://postgis.net/docs/ST_ClusterDBSCAN.html From: postgis-users On Behalf Of liglio.pessoal--- via postgis-users Sent: Monday, November 13, 2023 2:38 PM To: postgis-users@lists.osgeo.org Cc: liglio.pess...@nexxa.com.br Subject: [postgis-users] Grouping points based on distance

Re: [postgis-users] How to migrate to new server when PostGIS generations differ

> Troels, > > > I am working on getting rid of an old CentOS 7 server which runs > > Postgres > > 10+PostGIS 2.4.8, installed from the yum repository at > > https://download.postgresql.org/pub/repos/yum/ > > > > The server's databases are to be moved to a new Ubuntu 22 server > > running Postgres

Re: [postgis-users] How to migrate to new server when PostGIS generations differ

Troels, > I am working on getting rid of an old CentOS 7 server which runs Postgres > 10+PostGIS 2.4.8, installed from the yum repository at > https://download.postgresql.org/pub/repos/yum/ > > The server's databases are to be moved to a new Ubuntu 22 server running > Postgres 15+PostGIS 3.4,

Re: [postgis-users] ST_DWithin slow if query is joined to another table, but fast if ST_DWithin cast to an integer

First of all is that really your join clause? You seem to be missing an ON from building b join customer c Also please output EXPLAIN And the EXPLAIN ANALYZE of each query From: postgis-users On Behalf Of Cameron McCloud via postgis-users Sent: Wednesday, November

Re: [postgis-users] postgis_raster undefined symbol error

This problem usually happens if for some reason you have two versions of GEOS installed and the older one is being loaded. Might be a packaging issue. I’ve cc’d the pgsql-yum mailing list for guidance. Thanks, Regina From: postgis-users On Behalf Of Andy Knight via postgis-users

Re: [postgis-users] Rocky 9 - libhull missing errors

Are you using yum.postgresql.org. If you are best to ask the question on https://www.postgresql.org/list/pgsql-pkg-yum/ I know there have been some issues recently with gdal/geos as you can see - https://www.postgresql.org/list/pgsql-pkg-yum/2023-09/ Though I thought most had been resolved

Re: [postgis-users] Purge of old released notes

Are you talking about changelog or NEWS? The changelog was just a rehash of the git log. If you badly wanted to look at all the history, you can generate one yourself or just search thru the commit log here: https://git.osgeo.org/gitea/postgis/postgis/commits/branch/master The NEWS

[postgis-users] FOSS4GNA 2023 Baltimore Maryland USA, Oct 23rd - 25th

The Free and Open Source 4 Geospatial North American conference will be taking place in a little over a month in Baltimore, MD USA https://foss4gna.org/ There will be 15 workshops happening on the Oct 23rd each is 3 hrs long https://foss4gna.org/schedule.html#schedule There will be some

Re: [postgis-users] JSONC compilation issues (Regina Obe)

as I do SQLite etc. From: postgis-users On Behalf Of Light via postgis-users Sent: Thursday, September 21, 2023 7:18 PM To: postgis-users@lists.osgeo.org Cc: Light Subject: Re: [postgis-users] JSONC compilation issues (Regina Obe) Regina, Environment variables are a great way

Re: [postgis-users] JSONC compilation issues

Have you tried using pkg config instead. I don’t have mine in lib64 issue but I think using pkg-config should fix it export PKG_CONFIG_PATH=/usr/local/json-c-0.15//lib64/pkgconfig:${PKG_CONFIG_PATH} From: postgis-users On Behalf Of Light Sent: Thursday, September 21, 2023 5:24 AM To:

[postgis-users] pgRouting Code Sprint 2023 in Boston October 27th - October 29th

The pgRouting Code Sprint is going to be held in Person in Boston from October 27th through October 29th If you'd like to attend or Sponsor, please add you name / Company to the list on the Wiki page https://wiki.osgeo.org/wiki/PgRouting_Code_Sprint_2023_Boston#In_Person Thanks, Regina Obe

Re: [postgis-users] ArcGIS Online without ArcGIS server

it can't talk directly to a database server. It *might* be able to talk to a non-AGOL web service (probably using OGC protocols)? On Fri, Sep 15, 2023 at 8:26 AM Regina Obe mailto:l...@pcorp.us> > wrote: This may be a question to just people using ArcGIS Online or at least familiar

[postgis-users] ArcGIS Online without ArcGIS server

This may be a question to just people using ArcGIS Online or at least familiar with it. Is it possible to have an ArcGIS online connect to a PostGIS enabled database (assuming you have the port open etc), without an ArcGIS Server license? If so are their limitations in terms of what features you

Re: [postgis-users] generate a geometry column of random point, line and polygon

min(gs) , max(gs), st_optimalalphashape(st_collect(S... ^ HINT: No function matches the given name and argument types. You might need to add explicit type casts. SQL state: 42883 Character: 28 On Mon, 11 Sept 2023 at 08:31, Regina Obe mailto:l...@pcorp.us> > wrote: You are using the

Re: [postgis-users] generate a geometry column of random point, line and polygon

) <https://postgis.net/docs/en/ST_OptimalAlphaShape.html> Regards, David On Fri, 8 Sept 2023 at 16:16, Regina Obe mailto:l...@pcorp.us> > wrote: David, The example query in the docs, is as simple as it gets. It’s a self-contained example you can just run, but it

Re: [postgis-users] generate a geometry column of random point, line and polygon

, Regina Obe mailto:l...@pcorp.us> > wrote: David, For this are you needing to generate random points from a line or polygon or are you trying to generate random polygons, lines, and points? If you need to generate random points from a polygon: Use ST_GeneratePoints: https://postg

Re: [postgis-users] generate a geometry column of random point, line and polygon

David, For this are you needing to generate random points from a line or polygon or are you trying to generate random polygons, lines, and points? If you need to generate random points from a polygon: Use ST_GeneratePoints: https://postgis.net/docs/en/ST_GeneratePoints.html Note

Re: [postgis-users] Is there a simple way to generate polygon from random points?

David, There are some examples in the manual. There is a ST_ConcaveHull function and an ST_AlphaShape. Both do essentially the same thing but use different engines. Part of postgis extension, uses GEOS under the hood https://postgis.net/docs/en/ST_ConcaveHull.html Part of

Re: [postgis-users] Postgis_full_version(): WAGYU="0.5.0 (Internal)" (core procs from "3.3.4 3.3.4" need upgrade)

I don’t think the complain is about WAGYU. That version info just happens to sit next to the message. Have you tried doing SELECT postgis_extensions_upgrade(); Already and what does it say? From: postgis-users On Behalf Of Bo Guo Sent: Thursday, September 7, 2023 4:52 PM To:

Re: [postgis-users] ERROR: extension "postgis" has no update path from version "3.2.1" to version "3.2.0"

So it appeared that the installation did not bring postgis to the 3.2.1 or above. Please let me know alternative ways to install higher version. Cheers, Bo On Mon, Sep 4, 2023 at 5:06 PM Regina Obe mailto:l...@pcorp.us> > wrote: Bo, At a glance, it looks like maybe your P

Re: [postgis-users] ERROR: extension "postgis" has no update path from version "3.2.1" to version "3.2.0"

all higher version. Cheers, Bo On Mon, Sep 4, 2023 at 5:06 PM Regina Obe mailto:l...@pcorp.us> > wrote: Bo, At a glance, it looks like maybe your PostgreSQL 13 had a 3.2.1 installed and your PostgreSQL 14 has 3.2.0 installed (or at least the postgis.control file proba

Re: [postgis-users] ERROR: extension "postgis" has no update path from version "3.2.1" to version "3.2.0"

Bo, At a glance, it looks like maybe your PostgreSQL 13 had a 3.2.1 installed and your PostgreSQL 14 has 3.2.0 installed (or at least the postgis.control file probably has 3.2.0 instead of 3.2.1). I’d double check to make sure you did install 3.2.1 on your PostgreSQL 14. Downgrades are

Re: [postgis-users] Weblate closed registration

Weblate.osgeo.org requires an osgeo account. Which you can get here: https://id.osgeo.org/ldap/create I sent you the mantra code offlist so you don’t need to fill in the top form. We don’t publicize the mantra because we’ve gotten a lot of spam bots in the past signup and that

Re: [postgis-users] PostGIS verse those in Azure Cloud

Imre, Wow that’s a great summary covers Azure whole Geospatial space  David, I think Imre has provided you with a good starting point to ask your questions and to Greg’s point, many of these questions you’ll want to ask on Azure social systems. We just happened to be a much nicer

Re: [postgis-users] Stuck with upgrade from postgresql 9.6 to postgresql 14 due to postgis2.3

Marcelius, So you installed PostGIS from scripts right? I think your best bet is to upgrade your PostgreSQL 9.6 using scripts 1) Get a PostGIS 3.0 or higher for PostgreSQL 9.6 (it can be from a yum repo or compiled yourself). Preferable a PostGIS 3.1 (I think 3.1 is the last version

Re: [postgis-users] PostGIS verse those in Azure Cloud

Are you right about what? I still think you need to focus on what exactly you are trying to compare and for who. You are trying to compare apples and oranges is all I see. I don’t think you will find any single review about Azure cloud geospatial offerings, cause it’s a huge

Re: [postgis-users] PostGIS verse those in Azure Cloud

I'm not sure this is considered Azure Cloud, but one more interesting tidbit in the Microsoft Geospatial space and this I know because many people in OSGeo seem to be obsessed by it. This whole STAC and Earth Science wave dominating the market

Re: [postgis-users] PostGIS verse those in Azure Cloud

> Shaozhong SHI writes: > > > Geospatial capability has varied maturity in different systems, > > particular of interest is those in Azure Cloud as compared to PostGIS. > > > > Is there any publication on this topic? > > Postgis lives firmly in the open source world so I suspect you are getting

Re: [postgis-users] [postgis-devel] PostGIS Known Issues : OEL7 to RHEL8 Upgrade

supported by that minor Thanks, Regina From: Nikhil Shetty Sent: Tuesday, August 29, 2023 8:56 AM To: Regina Obe Cc: PostGIS Users Discussion Subject: Re: [postgis-devel] [postgis-users] PostGIS Known Issues : OEL7 to RHEL8 Upgrade Hi Regina, One quick question, as per doc regd

Re: [postgis-users] [postgis-devel] PostGIS Known Issues : OEL7 to RHEL8 Upgrade

at 23:41, Regina Obe mailto:l...@pcorp.us> > wrote: 3.1.2 is not the latest stable release for 3.1, so you really shouldn’t be using that. The 3.1.2 is before the PostgreSQL security vulnerability patches for example and numerous bugs have been fixed since then. Latest 3.1 is

Re: [postgis-users] [postgis-devel] PostGIS Known Issues : OEL7 to RHEL8 Upgrade

3.1.2 is not the latest stable release for 3.1, so you really shouldn’t be using that. The 3.1.2 is before the PostgreSQL security vulnerability patches for example and numerous bugs have been fixed since then. Latest 3.1 is 3.1.9

Re: [postgis-users] Help with Upgrade using YUM

From: atanga MARCELIUS [mailto:marx...@yahoo.ca] Sent: Sunday, August 20, 2023 8:49 AM To: PostGIS Users Discussion ; Regina Obe Cc: 'PostGIS Development Discussion' ; 'pgRouting users mailing list' ; 'pgRouting developers mailing list' ; mobilitydb-us...@lists.osgeo.org Subject: Re

[postgis-users] PostGIS 3.4.0 binaries and Installers for Windows PostgreSQL 12-16

I've published the installers for PostGIS 3.4.0 bundle for Windows PostgreSQL 12, 13, 14, 15, and 16 Details on this page: https://postgis.net/documentation/getting_started/install_windows/released_v ersions/ Extensions included are: PostGIS

[postgis-users] PostGIS 3.4.0 released

The PostGIS Development team is happy to release PostGIS 3.4.0 release. Details at: https://postgis.net/2023/08/PostGIS-3.4.0/ Happy testing, PostGIS Development Team ___ postgis-users mailing list postgis-users@lists.osgeo.org

Re: [postgis-users] Windows installer for 3.3.4

1) I do packaging for windows on my free time so it gets done when I have time to get it done. If you want to contribute to my PostGIS packaging efforts, you can fund the PostGIS project Here: https://postgis.net/community/support/ or you can fund me directly: https://www.patreon.com/reginaobe

Re: [postgis-users] PostGIS 3.4 on PG 16 observations

...@lists.osgeo.org] On Behalf Of Gandalf the Gray Sent: Monday, August 14, 2023 10:12 AM To: PostGIS Users Discussion Subject: Re: [postgis-users] PostGIS 3.4 on PG 16 observations Hi, Yes, I mean CREATE EXTENSION On Mon, Aug 14, 2023 at 4:09 PM Regina Obe mailto:l...@pcorp.us> >

Re: [postgis-users] PostGIS 3.4 on PG 16 observations

Command line. You mean CREATE EXTENSION? Just making sure. I see it in my extension drop down but could be a refresh issue or something I’m missing cause I’m using a slightly earlier build. H3_postgis ah yes I get the same error. I’ll let you know once fixed. Thanks, Regina

Re: [postgis-users] PostGIS 3.4 on PG 16 observations

It’s a PostGIS/Proj invention. The reason is ST_Transform behaves differently with some transformations or doesn’t work at all of those settings for network enabled off. I haven’t tried turning network on on windows and just realized I don’t think I’m packaging the proj.ini or some such thing

Re: [postgis-users] PgPointcloud for PG 16 Windows

for the archive in Winnie. I will see if it works. On a side note, are there any problems with osm2pgrouting binaries, or do you still have to build it? On Sun, Aug 13, 2023 at 7:11 PM Regina Obe mailto:l...@pcorp.us> > wrote: Nope, pgPointcloud doesn’t build cleanly against PG

Re: [postgis-users] PgPointcloud for PG 16 Windows

Nope, pgPointcloud doesn’t build cleanly against PG16 yet. See https://github.com/pgpointcloud/pointcloud/issues/338 I’ll get a patch for this (assuming someone doesn’t beat me to it) and submit and urge them to push out a tagged version. Thanks, Regina From: postgis-users

Re: [postgis-users] Winnie/Buildbot for Windows not available

Should be back now. Thanks, Regina From: postgis-users [mailto:postgis-users-boun...@lists.osgeo.org] On Behalf Of Gandalf the Gray Sent: Thursday, August 10, 2023 4:27 AM To: postgis-users@lists.osgeo.org Subject: [postgis-users] Winnie/Buildbot for Windows not available Hi guys

  1   2   3   4   5   6   7   >