Hi Regina,
We do have plans to upgrade both Postgres and PostGIS to higher versions
but currently we are focusing on OS upgrade to RHEL8
Do you think being on PostGIS 3.1.2 will impact OS upgrade? Are there any
known issues
Thanks,
Nikhil
On Wed, 23 Aug 2023 at 23:41, Regina Obe wrote:
>
On Wed, Aug 23, 2023 at 20:26 Mike Taves wrote:
> On Thu, 24 Aug 2023 at 13:08, Bo Guo wrote:
> > But we ran into severe (15 times) performance degradation when making CS
> transformation calls such as st_transform (geom, proj4, 4326)
>
> Note the docs say the geometry ST_Transform(geometry
On Thu, 24 Aug 2023 at 13:08, Bo Guo wrote:
> But we ran into severe (15 times) performance degradation when making CS
> transformation calls such as st_transform (geom, proj4, 4326)
Note the docs say the geometry ST_Transform(geometry geom, text
from_proj, text to_proj) is not optimized.
Are
Hi there,
One of our Postgresql Servers was recently upgraded
from
POSTGIS="3.2.1 5fae8e5" [EXTENSION] PGSQL="130" (procs need upgrade for use
with PostgreSQL "140") GEOS="3.7.1-CAPI-1.11.1 27a5e771" PROJ="Rel. 4.9.3,
15 August 2016" LIBXML="2.9.4" LIBJSON="0.12.1" LIBPROTOBUF="1.2.1"
Sandro Santilli writes:
> On Wed, Aug 16, 2023 at 08:46:08AM +0200, Paolo Cavallini wrote:
>> Dear admin,
>> the list, as many @osgeo were, is misconfigured for its DMARC. I suggest to
>> change one of the settings.
>
> Hi Paolo, thanks for the heads up.
> I've followed Markus Neteler's recipe
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
Hi Team,
We want to know if there are any open/known issues that we may face
post-migration of the Postgres database instance with PostGIS enabled
from centos7/RHEL7/OEL7 to RHEL8.
We came across one issue regarding collation(
https://wiki.postgresql.org/wiki/Locale_data_changes), the solution
On Wed, Aug 23, 2023 at 10:08:23AM +, atanga MARCELIUS wrote:
> x=# ALTER EXTENSION postgis UPDATE TO '2.5.5';
> ERROR: extension "postgis" does not exist
The above message means that database "x" does not contain
the "postgis extension". This does not necessarely mean it doesn't
Hi WangDapeng,
On Wed, Aug 23, 2023 at 02:00:31PM +0800, Light wrote:
> I see that the Chinese translation of the documentation is missing and I
> want to contribute. We submit 3-4 files per week.
There's some simplified chinese translation on weblate:
On Wed, Aug 23, 2023 at 12:36:58PM +0200, Nicolas Ribot wrote:
> (OpenJump is a GIS software that can display such views/tables
> containing heterogeneous geometry types, as QGIS does not like them)
I believe recent QGIS versions do support views with heterogeneous
geometries, not in the same
On Wed, Aug 16, 2023 at 08:46:08AM +0200, Paolo Cavallini wrote:
> Dear admin,
> the list, as many @osgeo were, is misconfigured for its DMARC. I suggest to
> change one of the settings.
Hi Paolo, thanks for the heads up.
I've followed Markus Neteler's recipe here:
Hello,
Yes you can by creating a view using UNION ALL (or UNION if you want to
filter out duplicate lines) between tables you want to use, for instance:
create or replace view myview as
select suivi_dossier as suivi_dossier, commune as commune, geom
from table1 UNION ALL
select
Hello Everyone,we am trying to upgrade postgresql9.6 to postgresql 14 and
postgis with below steps followingthe postgis compartibility with postgis.
postgres 9.6( postgis 2.3) -> postgres 10 ( postgis 2.3) ( postgres upgrade)
postgres 10 (postgis 2.3) -> postgres 10 (postgis 2.5) ( postgis
Good morning,
I have 5 postgis tables which have different types of geometries (1 point,
1 linear, 3 polygon). And also different field structures. These tables
share fields that provide the same information (project_monitoring,
municipality, etc.). Although the name of these fields is not always
Hello everyone,
I see that the Chinese translation of the documentation is missing and I
want to contribute. We submit 3-4 files per week.
Which branch should I use?
I saw KDE, any more detailed instructions?
Thanks.
WangDapeng.
___
postgis-users
15 matches
Mail list logo