Re: [OSGeo-Discuss] Creating a Mailing List

[Regina Obe]

I concur with strk's excitement.

Thanks,
Regina

-Original Message-
From: Discuss [mailto:discuss-boun...@lists.osgeo.org] On Behalf Of Sandro 
Santilli
Sent: Friday, February 12, 2016 1:19 PM
To: Jody Garnett 
Cc: OSGeo Discussions 
Subject: Re: [OSGeo-Discuss] Creating a Mailing List

On Fri, Feb 12, 2016 at 08:17:24AM -0800, Jody Garnett wrote:

> (The board is also laying down the 2016 budget - which includes a 
> guess at a budget for SAC)

This is great news! Looking forward for details.

--strk;
___
Discuss mailing list
Discuss@lists.osgeo.org
http://lists.osgeo.org/mailman/listinfo/discuss


___
Discuss mailing list
Discuss@lists.osgeo.org
http://lists.osgeo.org/mailman/listinfo/discuss

Re: [OSGeo-Discuss] who would be interested in a sponsorship benefits hangout?

[Regina Obe]

Me too.

 

From: Discuss [mailto:discuss-boun...@lists.osgeo.org] On Behalf Of Guido Stein
Sent: Monday, January 30, 2017 6:10 PM
To: Jody Garnett ; OSGeo Discussions 

Subject: Re: [OSGeo-Discuss] who would be interested in a sponsorship benefits 
hangout?

 

Happy to help if i can.

 

On Mon, Jan 30, 2017, 17:36 Jody Garnett  > wrote:

I have been fielding questions from potential sponsors around the benefits 
associated with sponsoring OSGeo (foundation/local chapters / events/ 
initiatives ).

 

Who is available interested/available for a hangout with potential sponsors? (I 
would like to have rep from foss4g and foss4g-e attend if they are available).

--

Jody Garnett

___
Discuss mailing list
Discuss@lists.osgeo.org  
https://lists.osgeo.org/mailman/listinfo/discuss


This e-mail message and any attachments may contain confidential or legally 
privileged information. If you are not an intended recipient or otherwise 
authorized to receive this message, you should not use, copy, distribute, 
disclose or take any action based on the information contained in this e-mail 
or any attachments. If you have received this message and material in error, 
please advise the sender immediately by reply e-mail and delete this message. 
Thank you on behalf of Applied Geographics, Inc. (AppGeo).

___
Discuss mailing list
Discuss@lists.osgeo.org
https://lists.osgeo.org/mailman/listinfo/discuss

[OSGeo-Discuss] PostGIS 2.3.2 is released

[Regina Obe]

The PostGIS development team is pleased to announce the release of PostGIS
2.3.2 
As befits a patch release, the focus is on bugs and breakages.
Best served with PostgreSQL 9.6.1+
https://www.postgresql.org/about/news/1712/
and pgRouting 2.3.2
https://lists.osgeo.org/pipermail/pgrouting-users/2017-January/002304.html 

You can download source and documentation from the following links:

Source: http://download.osgeo.org/postgis/source/postgis-2.2.5.tar.gz
HTML docs: http://download.osgeo.org/postgis/docs/doc-html-2.2.5.tar.gz
PDF Docs: http://download.osgeo.org/postgis/docs/postgis-2.2.5.pdf
EPUB Docs: http://download.osgeo.org/postgis/docs/postgis-2.2.5.epub
ChangeLog: https://svn.osgeo.org/postgis/tags/2.2.5/ChangeLog


Please http://postgis.net/support report bugs that you find in this release

Bug Fixes and Improvements

3418, KNN recheck in 9.5+ fails with index returned tuples in wrong order 
https://trac.osgeo.org/postgis/ticket/3418

3675, Relationship functions not using an index in some cases
https://trac.osgeo.org/postgis/ticket/3675

3680, PostGIS upgrade scripts missing GRANT for views  
https://trac.osgeo.org/postgis/ticket/3680

3683, Unable to update postgis after postgres pg_upgrade going from < 9.5 to
pg > 9.4
https://trac.osgeo.org/postgis/ticket/3683

3688, ST_AsLatLonText: round minutes
https://trac.osgeo.org/postgis/ticket/3688


Warm regards,
PostGIS Development Team

___
Discuss mailing list
Discuss@lists.osgeo.org
https://lists.osgeo.org/mailman/listinfo/discuss

[OSGeo-Discuss] PostGIS 2.2.5 is released

[Regina Obe]

The PostGIS development team is pleased to announce the release of PostGIS
2.2.5 
As befits a patch release, the focus is on bugs and breakages.

You can download source and documentation from the following links:

Source: http://download.osgeo.org/postgis/source/postgis-2.2.5.tar.gz
HTML docs: http://download.osgeo.org/postgis/docs/doc-html-2.2.5.tar.gz
PDF Docs: http://download.osgeo.org/postgis/docs/postgis-2.2.5.pdf
EPUB Docs: http://download.osgeo.org/postgis/docs/postgis-2.2.5.epub
ChangeLog: https://svn.osgeo.org/postgis/tags/2.2.5/ChangeLog


Please http://postgis.net/support report bugs that you find in this release

Bug Fixes and Improvements

3418, KNN recheck in 9.5+ fails with index returned tuples in wrong order 
https://trac.osgeo.org/postgis/ticket/3418

3680, PostGIS upgrade scripts missing GRANT for views  
https://trac.osgeo.org/postgis/ticket/3680


PostGIS 2.3.2 will be coming out in the next day or 2.

Warm regards,
PostGIS Development Team




___
Discuss mailing list
Discuss@lists.osgeo.org
https://lists.osgeo.org/mailman/listinfo/discuss

[OSGeo-Discuss] PostGIS 2.3.0beta1 release

[Regina Obe]

The PostGIS development team is proud to release PostGIS 2.3.0beta1.

PostGIS 2.3 is feature complete, so we're looking for testing and feedback! 
Best served with PostgreSQL 9.6.

Please give this beta a try and report back any issues you encounter.  

Download -
http://download.osgeo.org/postgis/source/postgis-2.3.0beta1.tar.gz
HMTL docs -
http://download.osgeo.org/postgis/docs/doc-html-2.3.0beta1.tar.gz
PDF docs - http://download.osgeo.org/postgis/docs/postgis-2.3.0beta1.pdf


* Important / Breaking Changes *

  - #3466, Casting from box3d to geometry now returns a 3D
   geometry (Julien Rouhaud of Dalibo)

  - #3604, pgcommon/Makefile.in orders 
   CFLAGS incorrectly leading to wrong liblwgeom.h
   (Greg Troxel)

* New Features *

-- new functions can be found here -
http://postgis.net/docs/manual-dev/PostGIS_Special_Functions_Index.html#NewF
unctions_2_3

  - Add support for custom TOC in postgis_restore.pl
(Christoph Moench-Tegeder)
  - Add support for negative indexing in ST_PointN and ST_SetPoint
(Rémi Cura)
  - Add parameters for geography ST_Buffer (Thomas Bonfort)
  - TopoGeom_addElement, TopoGeom_remElement (Sandro Santilli)
  - populate_topology_layer (Sandro Santilli)
  - #454,  ST_WrapX and lwgeom_wrapx (Sandro Santilli)
  - #1758, ST_Normalize (Sandro Santilli)
  - #2236, shp2pgsql -d now emits "DROP TABLE IF EXISTS"
  - #2259, ST_Voronoi* (Dan Baston)
  - #2991, Enable ST_Transform to use PROJ.4 text (Mike Toews)
  - #3059, Allow passing per-dimension parameters in ST_Expand (Dan Baston)
  - #3339, ST_GeneratePoints (Paul Ramsey)
  - #3362, ST_ClusterDBSCAN (Dan Baston)
  - #3364, ST_GeometricMedian (Dan Baston)
  - #3391, Add table inheritance support in ST_EstimatedExtent
   (Alessandro Pasotti)
  - #3424, ST_MinimumClearance (Dan Baston)
  - #3428, ST_Points (Dan Baston)
  - #3465, ST_ClusterKMeans (Paul Ramsey)
  - #3469, ST_MakeLine with MULTIPOINTs (Paul Norman)
  - #3549, Support PgSQL 9.6 parallel query mode, as far as possible
(Paul Ramsey, Regina Obe)
  - #3557, Geometry function costs based on query stats (Paul Norman)
  - #3591, Add support for BRIN indexes. PostgreSQL 9.4+ required.
  (Giuseppe Broccolo of 2nd Quadrant, Julien Rouhaud and
Ronan Dunklau of Dalibo)
  - #3496, Make postgis non-relocateable (for extension install), 
schema qualify calls in functions (Regina Obe)
Should resolve once and for all for extensions #3494, #3486,
#3076 

  - #3547, Update tiger geocoder to support TIGER 2016
   and to support both http and ftp. (Regina Obe)

 * Performance Enhancements *

  - #75, Enhancement to PIP short circuit (Dan Baston)
  - #3383, Avoid deserializing small geometries during index operations
(Dan Baston)
  - #3400, Minor optimization of PIP routines (Dan Baston)
  - Make adding a line to topology interruptible (Sandro Santilli)
  - #3613, Segmentize geography using equal length segments, (Hugo Mercier
of Oslandia)


On Behalf of all the PostGIS Development Team,
We wish you all a joyous testing experience

Thanks,
Regina

___
Discuss mailing list
Discuss@lists.osgeo.org
http://lists.osgeo.org/mailman/listinfo/discuss

[OSGeo-Discuss] PostGIS 2.2.3 is released

[Regina Obe]

The PostGIS development team is pleased to announce the release of PostGIS
2.2.3.
As befits a patch release, the focus is on bugs and breakages.

Source download:
http://download.osgeo.org/postgis/source/postgis-2.2.3.tar.gz
HTML Doc download:
http://download.osgeo.org/postgis/docs/doc-html-2.2.3.tar.gz
PDF doc download: http://download.osgeo.org/postgis/docs/postgis-2.2.3.pdf
ChangeLog: https://svn.osgeo.org/postgis/tags/2.2.3/ChangeLog

Bug Fixes and Improvements

3615, Fix schema support in RT_CreateOveriew (Cait Smith)
3628, Fix lack of support for capitalized-Y in SwapOrdinates
3524, Add interruptibility to geography brute-force distance calculation
3522, Handle POINT and MULTIPOINT correctly in ST_Subdivide
3565, ST_SetPoint can crash backend
3571, Install desktop file and application icons for shp2pgsql-gui
(Sebastiaan Couwenberg)
3573, Operator <<->> incorrectly calculates m distance
3579, Crash in LWGEOM2GEOS
3515, tiger_data not being backed up
3569, Incorrect coordinates returned by ST_CollectionHomogenize (Dan
Baston)
3602, perl as found by configure is not used in tiger extension,
postgis_sfcgal, address_standardizer
3604, pgcommon/Makefile.in orders CFLAGS leads to installed liblwgeom.h
(Greg Troxel)
3607, Fix inconsistency with multilinestring in
ST_LocateBetweenElevations (Artur Zakirov)
3608, Fix crash passing -W UTF-8 to shp2pgsql (Matt Amos)
3624, [raster] load_outdb related tests fail for 2.2.2 & 2.3.0-beta1 on
Debian unstable perl @INC fix (Sebastiaan Couwenberg)
3627, Encoded polyline functions ignore precision parameter (Christian
Quest / Dan Baston)
3501, use ST_Union instead of ST_Collect to compute raster max extent
constraint
3640, Interpolate_from_address sometimes results in "" invalid for
numeric
3641, Tiger normalize, pagc_normalize integer out of range
3644, Deadlock on interrupt
3542, Crash on Geometry(MultiCurve())
Numerous documentation corrections from ruvyn
3652,  Segmentation fault during operations on GEOMETRYCOLLECTION with
MULTICURVE geometry inside

Thanks,

PostGIS Development Team

___
Discuss mailing list
Discuss@lists.osgeo.org
http://lists.osgeo.org/mailman/listinfo/discuss

[OSGeo-Discuss] PostGIS 2.3.0rc1 Bundle package (includes pgRouting) binaries and installers for Windows users

[Regina Obe]

For those who'd like a chance to test out pgRouting 2.3.0rc1 and PostGIS
2.3.0rc1 before final release, 
We've created installers and binary packages for PostgreSQL 9.6:

These are here and start with prefix - postgis-pg96-bundle

http://winnie.postgis.net/download/windows/pg96/buildbot/

Make sure to use the appropriate package for your PostgresQL (32/64-bit)
version.
While we don't have installers for 9.5 and 9.4 yet for PostGIS 2.3.0rc1
Bundle, you can find binary zip
In respective folders:

http://postgis.net/windows_downloads/

(these will start with postgis-pg(versionnum)-bundle-2.3.0rc1*  (the w64 is
for 64bit PostgreSQL and the w32 is for 32-bit PostgreSQL).

The bundles contain the following goodies:

PostGIS 2.3.0rc1 (with SFCGAL 1.3.0, GDAL 2.1.1, GEOS 3.5.0, proj 4.9.1, all
PostGIS packaged extensions)
pgRouting 2.3.0-rc1
osm2pgrouting 2.1.0
ogrfdw 1.0.2 (with GDAL 2.1.1 support)
pointcloud 1.1.0dev

Let me know if you run into any issues with these.

Thanks,
Regina
http://www.paragoncorporation.com
http://www.postgis.us
http://postgis.net



___
Discuss mailing list
Discuss@lists.osgeo.org
http://lists.osgeo.org/mailman/listinfo/discuss

[OSGeo-Discuss] PostGIS 2.3.0rc1 release just footsteps after pgRouting 2.3.0-rc1 release

[Regina Obe]

PostGIS 2.3.0rc1 is feature complete, so we’re looking for testing and
feedback! 
Best served with PostgreSQL 9.6rc1 and pgRouting 2.3.0-rc1.

Please give this release candidate a try and report back any issues you
encounter.

Download -
http://download.osgeo.org/postgis/source/postgis-2.3.0rc1.tar.gz
HMTL docs -
http://download.osgeo.org/postgis/docs/doc-html-2.3.0rc1.tar.gz
PDF docs - http://download.osgeo.org/postgis/docs/postgis-2.3.0rc1.pdf

Important / Breaking Changes

3466, Casting from box3d to geometry now returns a 3D geometry (Julien
Rouhaud of Dalibo)

3604, pgcommon/Makefile.in orders CFLAGS incorrectly leading to wrong
liblwgeom.h (Greg Troxel)

3396, ST_EstimatedExtent, now throws WARNING instead of ERROR (Regina
Obe)

New Features and Performance Enhancements

Add support for custom TOC in postgis_restore.pl (Christoph
Moench-Tegeder)
Add support for negative indexing in ST_PointN and ST_SetPoint (Rémi
Cura)

Numerous new function additions and enhancements: New Functions and
Enhancements

3549, Support PgSQL 9.6 parallel query mode, as far as possible (Paul
Ramsey, Regina Obe)
3557, Geometry function costs based on query stats (Paul Norman)
3591, Add support for BRIN indexes (Giuseppe Broccolo of 2nd Quadrant,
Julien Rouhaud and Ronan Dunklau of Dalibo)

3496, Make postgis non-relocateable (for extension install), schema
qualify calls in functions (Regina Obe) 
Should resolve once and for all for extensions #3494, #3486, #3076

3547, Update tiger geocoder to support TIGER 2016 and use http or ftp
(Regina Obe)

On Behalf of all the PostGIS Development Team,
We wish you all a joyous testing experience

Thanks,
Regina

___
Discuss mailing list
Discuss@lists.osgeo.org
http://lists.osgeo.org/mailman/listinfo/discuss

[OSGeo-Discuss] PostGIS 2.3.1 released

[Regina Obe]

The PostGIS development team is happy to release PostGIS 2.3.1.
This is best served with pgRouting 2.3.1 (which was released last week:
https://github.com/pgRouting/pgrouting/releases/tag/v2.3.1 )
As befits a patch release, the focus is on bugs and breakages.

Source: http://download.osgeo.org/postgis/source/postgis-2.3.1.tar.gz

Docs PDF:  http://download.osgeo.org/postgis/docs/postgis-2.3.1.pdf

Doc Html: http://download.osgeo.org/postgis/docs/doc-html-2.3.1.tar.gz

Details of what got fixed, improved:

  - #1973, st_concavehull() returns sometimes empty geometry collection
   Fix from gde
  - #3501, add raster constraint max extent exceeds array size limit
for large tables
  - #3643, PostGIS not building on latest OSX XCode
  - #3644, Deadlock on interrupt
  - #3650, Mark ST_Extent, ST_3DExtent and ST_Mem* 
agg functions as parallel safe so they can be parallelized
  - #3652, Crash on Collection(MultiCurve())
  - #3656, Fix upgrade of aggregates from 2.2 or lower version
  - #3659, Crash caused by raster GUC define after CREATE EXTENSION
 using wrong memory context. (manaeem)
  - #3665, Index corruption and memory leak in BRIN indexes
patch from Julien Rouhaud (Dalibo)
  - #3667, geography ST_Segmentize bug
patch from Hugo Mercier (Oslandia)

Thanks,

PostGIS development Team

___
Discuss mailing list
Discuss@lists.osgeo.org
http://lists.osgeo.org/mailman/listinfo/discuss

[OSGeo-Discuss] PostGIS 2.3.3 released

[Regina Obe]

The PostGIS development team is pleased to announce the release of PostGIS
2.3.3.
As befits a patch release, the focus is on bugs and breakages. Best served
with PostgreSQL 9.6.3+ and pgRouting 2.4.1.

Source: http://download.osgeo.org/postgis/source/postgis-2.3.3.tar.gz

html doc: http://download.osgeo.org/postgis/docs/doc-html-2.3.3.tar.gz
pdf doc:  http://download.osgeo.org/postgis/docs/postgis-2.3.3.pdf
epub doc: http://download.osgeo.org/postgis/docs/postgis-2.3.3.epub

ChangeLog:
https://git.osgeo.org/gogs/postgis/postgis/raw/2.3.3/ChangeLog


Please report bugs that you find in this release:
http://postgis.net/support/

Bug Fixes

3777, GROUP BY anomaly with empty geometries
3711, Azimuth error upon adding 2.5D edges to topology
3726, PDF manual from dblatex renders fancy quotes for programlisting
(Mike Toews)
3738, raster: Using -s without -Y in raster2pgsql transforms raster data
instead of setting srid
3744, ST_Subdivide loses subparts of inverted geometries (Darafei
Praliaskouski Komzpa)
3750, @ and ~ operator not always schema qualified in geometry and
raster functions. Causes restore issues. (Shane StClair of Axiom Data
Science)
3682, Strange fieldlength for boolean in result of pgsql2shp
3701, Escape double quotes issue in pgsql2shp
3704, ST_AsX3D crashes on empty geometry
3730, Change ST_Clip from Error to Notice when ST_Clip can't compute a
band


See the full list of changes in the news file and please report bugs that
you find in the release. Binary packages will appear in repositories over
the coming weeks as packagers roll out builds.

View all closed tickets for 2.3.3:
http://trac.osgeo.org/postgis/query?status=closed=1=priority
=PostGIS+2.3.3=priority


Warm Regards,
PostGIS Development Team

___
Discuss mailing list
Discuss@lists.osgeo.org
https://lists.osgeo.org/mailman/listinfo/discuss

Re: [OSGeo-Discuss] [Live-demo] OSGeo-Live Press Release 78: OSGeo-Live 11.0 - Need help translating and testing

[Regina Obe]

Is there a link to the published beta documentation so project folks can 
translators can check to see how it will look when published?

 

The live.osgeo.org just has 10.5.

 

Thanks,

Regina

 

-
From: Astrid Emde (OSGeo)  
>
Date: Tue, Jul 4, 2017 at 7:45 AM



Hello,

we're looking for help testing OSGeo-Live 11.0 beta1 and translating docs.

In particular, we need help:

1. Testing. Run Quickstarts and verify they work. Join us on 
irc://freenode.net#osgeolive   this weekend, 8 & 
9 July 2017, for our testing sprint.

2. Check if any new features need to be added to Project Overviews [2]

3. Update review status in our spreadsheet [4]. (It really helps us know if an 
application has been reviewed, and by who).

4. Translate docs that have been updated. (Note, our spreadsheet [4] lists a 
number of retired projects which need updating in the overview.rst contents 
page and metrics.rst page.) You find the documentation at [2]. Read how to get 
the documentation fom github and how to make pull request [3].


OSGeo-Live is scheduled to be the default installation at FOSS4G 2017 
workshops. We strongly urge all workshop leaders to test OSGeo-Live now and 
provide feedback, while there is still time to tweak anything required for the 
workshop.

[1] Download: http://osprey.ucdavis.edu/downloads/osgeo/gisvm/gisvm/11.0/ 
Mirror: http://aiolos.survey.ntua.gr/gisvm/11.0/

[2] https://github.com/OSGeo/OSGeoLive-Doc

[3] https://wiki.osgeo.org/wiki/Live_GIS_Disc#Git_migration

[4] 
https://docs.google.com/spreadsheets/d/1Q5BaEgQtgw4O1bXyeWMlM8XtAOhUgcjZ7Y2O0FZc2H0/edit?hl=en_GB#gid=2014800150
Key Milestones

19-Jun-2017 OSGeo-Live delivered to UAT (final application versions 
installed)
15-Jul-2017 OSGeo-Live translation finished
24-Jul-2017 OSGeo-Live Final ISO
14-Aug-2017 FOSS4G 2017 Boston

... full schedule 
http://spreadsheets.google.com/ccc?key=0Al9zh8DjmU_RdE1SYUN3YWJ2N1NpSUczbW9IRWZNclE
 

 =en_GB

About OSGeo-Live
OSGeo-Live (http://live.osgeo.org) is a Lubuntu (http://lubuntu.net) based 
distribution of Geospatial Open Source Software, available via a Live DVD, 
Virtual Machine and USB. You can use OSGeo-Live to try a wide variety of open 
source geospatial software without installing anything.


You find this press release at: 
https://wiki.osgeo.org/wiki/Live_GIS_Disc_Press_Release_78
___
Live-demo mailing list
live-d...@lists.osgeo.org  
https://lists.osgeo.org/mailman/listinfo/live-demo
http://live.osgeo.org
http://wiki.osgeo.org/wiki/Live_GIS_Disc




-- 

Georepublic UG (haftungsbeschränkt)
Salzmannstraße 44, 
81739 München, Germany
 
Vicky Vergara
Operations Research
 
eMail: vi...@georepublic.de  
Web: https://georepublic.info
 
Tel: +49 (089) 4161 7698-1
Fax: +49 (089) 4161 7698-9
 
Commercial register: Amtsgericht München, HRB 181428
CEO: Daniel Kastl
 
___
Discuss mailing list
Discuss@lists.osgeo.org
https://lists.osgeo.org/mailman/listinfo/discuss

[OSGeo-Discuss] PostGIS 2.4.0 alpha is released

[Regina Obe]

The PostGIS development team is pleased to announce the release of PostGIS
2.4.0alpha 
This is the first version to support PostgreSQL 10.
Best served with [PostgreSQL
10beta2](https://www.postgresql.org/docs/10/static/index.html) 
See the full list of changes in the [news
file](https://git.osgeo.org/gogs/postgis/postgis/raw/2.4.0alpha/NEWS) 


* [Source
Download](http://download.osgeo.org/postgis/source/postgis-2.4.0alpha.tar.gz
)
* [html doc
download](http://download.osgeo.org/postgis/docs/doc-html-2.4.0alpha.tar.gz)
(this version includes Japanese translation postgis-ja.html)
* [pdf doc
download](http://download.osgeo.org/postgis/docs/postgis-2.4.0alpha.pdf)
* [epub doc
download](http://download.osgeo.org/postgis/docs/postgis-2.4.0alpha.epub)
*
[ChangeLog](https://git.osgeo.org/gogs/postgis/postgis/raw/2.4.0alpha/Change
Log)

Please [report bugs](http://postgis.net/support/) that you find in this
release.

View all [closed tickets for 2.4.0][1].
 
[1]:http://trac.osgeo.org/postgis/query?status=closed=1=prio
rity=PostGIS+2.4.0=priority


Thanks,
PostGIS development team

___
Discuss mailing list
Discuss@lists.osgeo.org
https://lists.osgeo.org/mailman/listinfo/discuss

[OSGeo-Discuss] FOSS4G 2017 Code Sprint Head count

[Regina Obe]

If you are planning to attend the FOSS4G 2017 Code Sprint in Boston on
Saturday August 19th, 2017, please add your name to the list:

https://wiki.osgeo.org/wiki/FOSS4G_2017_Code_Sprint#Registered_Attendees

Note: Attending the conference is not required to attend to Code sprint.

If you are unable to edit the wiki, either create an account (and I'll try
to be quick to approve), or send me an email with your name, email, and
project you are interested in and I'll add you to the list.

We'd like to get a reasonable head-count so we can start making catering
decisions by end this week.

If you'd like to stay informed about the conference and code sprint, signup
for the FOSS4G2017 mailing list:

https://lists.osgeo.org/mailman/listinfo/foss4g2017


Thanks,
Regina Obe
FOSS4G 2017 LOC member
PostGIS PSC member





___
Discuss mailing list
Discuss@lists.osgeo.org
https://lists.osgeo.org/mailman/listinfo/discuss

[OSGeo-Discuss] PostGIS 2.4.0rc1 is released

[Regina Obe]

The PostGIS development team is pleased to announce the release of PostGIS
2.4.0rc1.
Best served with [PostgreSQL 10beta4 or rc1 which is coming
soon](https://www.postgresql.org/docs/10/static/index.html)

and   pgRouting 2.5.0.  pgRouting 2.5.0 release is eminent watch this space:
https://github.com/pgRouting/pgrouting/releases

See the full list of changes in the
https://git.osgeo.org/gogs/postgis/postgis/raw/2.4.0rc1/NEWS

* Source:  http://download.osgeo.org/postgis/source/postgis-2.4.0rc1.tar.gz
* html docs: http://download.osgeo.org/postgis/docs/doc-html-2.4.0rc1.tar.gz
(this version includes Japanese translation postgis-ja.html)
* pdf: http://download.osgeo.org/postgis/docs/postgis-2.4.0rc1.pdf
* epub: http://download.osgeo.org/postgis/docs/postgis-2.4.0rc1.epub
* ChangeLog:
https://git.osgeo.org/gogs/postgis/postgis/raw/2.4.0rc1/ChangeLog


If you are upgrading from an existing PostGIS install, make sure after
installing PostGIS 2.4.0rc1 binaries to do.

ALTER EXTENSION postgis UPDATE;

-- if you have additional postgishy extensions below upgrade them too

ALTER EXTENSION postgis_sfcgal UPDATE;
ALTER EXTENSION postgis_topology UPDATE;
ALTER EXTENSION postgis_tiger_geocoder UPDATE;

--pgRouting 2.5.0 is imminent
ALTER EXTENSION pgrouting UPDATE; 


View all closed tickets for 2.4.0rc1.
 
http://trac.osgeo.org/postgis/query?status=closed=1=priority
=PostGIS+2.4.0=priority

Love,
PostGIS Development Team

___
Discuss mailing list
Discuss@lists.osgeo.org
https://lists.osgeo.org/mailman/listinfo/discuss

[OSGeo-Discuss] PostGIS 2.4.0 is released

[Regina Obe]

The PostGIS development team is pleased to announce the release of PostGIS
2.4.0.
Best served with [PostgreSQL 10RC1 
(https://www.postgresql.org/docs/10/static/index.html)

and   pgRouting 2.5.0 :
https://github.com/pgRouting/pgrouting/releases/tag/v2.5.0


See the full list of changes in the
https://git.osgeo.org/gogs/postgis/postgis/raw/2.4.0/NEWS


* Source:  http://download.osgeo.org/postgis/source/postgis-2.4.0.tar.gz
* html docs: http://download.osgeo.org/postgis/docs/doc-html-2.4.0.tar.gz
(this version includes Japanese, German, Portuguese and Korean single html
files)
* pdf: http://download.osgeo.org/postgis/docs/postgis-2.4.0.pdf
* epub: http://download.osgeo.org/postgis/docs/postgis-2.4.0.epub



Please report: http://postgis.net/support/ that you find in this release.

**New Features**

* 3822, Have postgis_full_version() also show and check version of
PostgreSQL the scripts were built against (Sandro Santilli)
* 2411, curves support in ST_Reverse (Sandro Santilli)
* 2951, ST_Centroid for geography (Danny Götte)
* 3788, Allow postgis_restore.pl to work on directory-style (-Fd) dumps
(Roger Crew)
* 3772, Direction agnostic ST_CurveToLine output (Sandro Santilli / KKGeo)
* 2464, ST_CurveToLine with MaxError tolerance (Sandro Santilli / KKGeo)
* 3599, Geobuf output support via ST_AsGeobuf (Björn Harrtell)
* 3661, Mapbox vector tile output support via ST_AsMVT (Björn Harrtell /
Carto)
* 3689, Add orientation checking and forcing functions (Dan Baston)
* 3753, Gist penalty speed improvements for 2d and nd points
(Darafei Praliaskouski)
* 3677, ST_FrechetDistance (Shinichi Sugiyama)
- Most aggregates (raster and geometry),
and all stable / immutable (raster and geometry) marked as parallel safe
* 2249, ST_MakeEmptyCoverage for raster (David Zwarg, ainomieli)
* 3709, Allow signed distance for ST_Project (Darafei Praliaskouski)
* 524, Covers support for Polygon-on-polygon, line on line,
point on line for geography (Danny Götte)

**Enhancements**

* Support for PostgreSQL 10
* 3645, Avoid loading logically deleted records from shapefiles
* 3747, Add zip4 and address_alphanumeric as attributes
 to norm_addy tiger_geocoder type.
* 3748, address_standardizer lookup tables update
 so pagc_normalize_address better standardizes abbreviations
* 3647, better handling of noding in ST_Node using GEOSNode
(Wouter Geraedts)
* 3684, Update to EPSG register v9
(Even Rouault)
* 3830, Fix initialization of incompatible type (>=9.6) address_standardizer
* 3662, Make shp2pgsql work in debug mode by sending debug to stderr
* 3405, Fixed memory leak in lwgeom_to_points
* 3832, Support wide integer fields as int8 in shp2pgsql
* 3841, Deterministic sorting support for empty geometries in btree
geography
* 3844, Make = operator a strict equality test, and < > to rough "spatial
sorting"
* 3855, ST_AsTWKB memory and speed improvements

**Breaking Changes**

* Dropped support for PostgreSQL 9.2.
* 3810, GEOS 3.4.0 or above minimum required to compile
* Most aggregates now marked as parallel safe,
  which means most aggs have to be dropped / recreated.
  If you have views that utilize PostGIS aggs,
  you'll need to drop before upgrade and recreate after upgrade

* B-Tree index operators < = > changed to provide better spatial locality on
sorting
and have expected behavior on GROUP BY. It now works on exact geometry
instead of bounding box.
If you have btree index for geometry or geography, you need to REINDEX it,
or review
if it was created by accident and needs to be replaced with GiST index.
If your code relies on old left-to-right box compare ordering,
update it to use << >> operators.

* `_ST_DumpPoints` removed, was no longer needed after PostGIS 2.1.0
when ST_DumpPoints got reimplemented in C.

Thanks,
PostGIS Development Team

___
Discuss mailing list
Discuss@lists.osgeo.org
https://lists.osgeo.org/mailman/listinfo/discuss

[OSGeo-Discuss] PostGIS 2.5.0 alpha released

[Regina Obe]

The PostGIS development team is pleased to release PostGIS 2.5.0alpha.

This release is a work in progress, and some features are still slated to be
added. Although this release will work for PostgreSQL 9.4 and above, to take
full advantage of what PostGIS 2.5 will offer, 
you should be running PostgreSQL 11beta+.

Best served with PostgreSQL 11beta which was recently released.

View all closed tickets for 2.5.0.

* [source download](
https://download.osgeo.org/postgis/source/postgis-2.5.0alpha.tar.gz )
* [pdf doc download](
https://download.osgeo.org/postgis/docs/postgis-2.5.0alpa.pdf )
* [html doc download](
https://download.osgeo.org/postgis/docs/doc-html-2.5.0alpha.tar.gz )
* [epub doc download](
https://download.osgeo.org/postgis/docs/postgis-2.5.0alpha.epub )
* [Changelog](https://svn.osgeo.org/postgis/tags/2.5.0alpha/ChangeLog )

Please test these new features.  Report bugs with details as noted in:
http://postgis.net/support/

--- NEWS WORTHY ITEMS ---

* New Features *
  - #4056, ST_FilterByM (Nicklas Avén)
  - #4050, ST_ChaikinSmoothing (Nicklas Avén)
  - #3989, ST_Buffer single sided option (Stephen Knox)
  - #3876, ST_Angle function (Rémi Cura)
  - #3564, ST_LineInterpolatePoints (Dan Baston)
  - #3896, PostGIS_Extensions_Upgrade() (Regina Obe)
  - #3913, Upgrade when creating extension from unpackaged (Sandro Santilli)
  - #2256, _postgis_index_extent() for extent from index (Paul Ramsey)
  - #3176, Add ST_OrientedEnvelope (Dan Baston)
  - #4029, Add ST_QuantizeCoordinates (Dan Baston)
  - #4063, Optional false origin point for ST_Scale (Paul Ramsey)
  - #4082, Add ST_BandFileSize and ST_BandFileTimestamp,
   extend ST_BandMetadata (Even Rouault)
  - #2597, Add ST_Grayscale (Bborie Park)
  - #4007, Add ST_SetBandPath (Bborie Park)
  - #4008, Add ST_SetBandIndex (Bborie Park)

* Breaking Changes *
  - #4054, ST_SimplifyVW changed from > tolerance to >= tolerance
  - #3885, version number removed from address_standardize lib file
  (Regina Obe)
  - #3893, raster support functions can only be loaded in the same schema
   with core PostGIS functions.
  - #4035, remove dummy pgis_abs type from aggregate/collect routines.
  - #4069, drop support for GEOS < 3.5 and PostgreSQL < 9.4 (Regina Obe)
  - #4082, ST_BandMetaData extended to include filesize, timestamp (Even
Rouault)

* Enhancements and Fixes*
  - #3944, Update to EPSG register v9.2 (Even Rouault)
  - #3927, Parallel implementation of ST_AsMVT
  - #3925, Simplify geometry using map grid cell size before generating MVT
  - #3899, BTree sort order is now defined on collections of EMPTY and
   same-prefix geometries (Darafei Praliaskouski)
  - #3864, Performance improvement for sorting POINT geometries
   (Darafei Praliaskouski)
  - #3900, GCC warnings fixed, make -j is now working (Darafei
Praliaskouski)
  - TopoGeo_addLinestring robustness improvements (Sandro Santilli)
#1855, #1946, #3718, #3838
  - #3234, Do not accept EMPTY points as topology nodes (Sandro Santilli)
  - #1014, Hashable geometry, allowing direct use in CTE signatures (Paul
Ramsey)
  - #3097, Really allow MULTILINESTRING blades in ST_Split() (Paul Ramsey)
  - #3942, geojson: Do not include private header for json-c >= 0.13 (Björn
Esser)
  - #3954, ST_GeometricMedian now supports point weights (Darafei
Praliaskouski)
  - #3965, ST_ClusterKMeans used to lose some clusters on initialization
   (Darafei Praliaskouski)
  - #3971, ST_ClusterKMeans now uses better initial seed (Darafei
Praliaskouski)
  - #3977, ST_ClusterKMeans is now faster and simpler (Darafei
Praliaskouski)
  - #3982, ST_AsEncodedPolyline supports LINESTRING EMPTY and MULTIPOINT
EMPTY
   (Darafei Praliaskouski)
  - #3986, ST_AsText now has second argument to limit decimal digits
   (Marc Ducobu, Darafei Praliaskouski)
  - #4020, Casting from box3d to geometry now returns correctly connected
   PolyhedralSurface (Matthias Bay)
  - #2508, ST_OffsetCurve now works with collections (Darafei Praliaskouski)
  - #4006, ST_GeomFromGeoJSON support for json and jsonb as input
   (Paul Ramsey, Regina Obe)
  - #4037, Invalid input geometry is fixed with MakeValid for GEOS
exceptions in
   ST_Intersection, ST_Union, ST_Difference, ST_SymDifference
(Darafei
   Praliaskouski)
  - #4038, ST_Subdivide now selects pivot for geometry split that reuses
input
   vertices. ST_ClipByBox2D is stubbed with ST_Intersection because
of
   robustness issues. (Darafei Praliaskouski)
  - #4025, #4032 Fixed precision issue in ST_ClosestPointOfApproach,
   ST_DistanceCPA, and ST_CPAWithin (Paul Ramsey, Darafei
Praliaskouski)
  - #4071, ST_ClusterKMeans crash on NULL/EMPTY fixed (Darafei
Praliaskouski)
  - #4076, Reduce use of GEOS in topology implementation (Björn Harrtell)
  - #4080, Add external raster band index to ST_BandMetaData
  - Add Raster Tips section to Documentation for information about

[OSGeo-Discuss] PostGIS 2.5.0beta1 is released

[Regina Obe]

The PostGIS development team is pleased to release PostGIS 2.5.0beta1.

This release is a work in progress. No more api changes will be made from
this point on before 2.5.0 release. Remaining time will be focused on bug
fixes and documentation for the new functionality and performance
enhancements under the covers. Although this release will work for
PostgreSQL 9.4 and above, to take full advantage of what PostGIS 2.5 will
offer, you should be running PostgreSQL 11beta2+ and GEOS 3.7.0beta1 which
were released recently.

Best served with PostgreSQL 11beta2 which was recently released -
https://www.postgresql.org/about/news/1867/

New Feature since alpha release:

- #1847, spgist 2d and 3d support for PG 11+
(Esteban Zimányi and Arthur Lesuisse from Université Libre de Bruxelles
(ULB),
  Darafei Praliaskouski)

-

* [source download]
https://download.osgeo.org/postgis/source/postgis-2.5.0beta1.tar.gz 

* [pdf doc download]
https://download.osgeo.org/postgis/docs/postgis-2.5.0alpa.pdf 

* [html doc download]
https://download.osgeo.org/postgis/docs/doc-html-2.5.0beta1.tar.gz 

* [epub doc download](
https://download.osgeo.org/postgis/docs/postgis-2.5.0beta1.epub 

* [Changelog] https://svn.osgeo.org/postgis/tags/2.5.0beta1/ChangeLog 


Other items:

https://git.osgeo.org/gitea/postgis/postgis/raw/tag/2.5.0beta1/NEWS


Please test these new features.  Report bugs with details as noted in:

http://postgis.net/support/


Love,
PostGIS Development Team

___
Discuss mailing list
Discuss@lists.osgeo.org
https://lists.osgeo.org/mailman/listinfo/discuss

[OSGeo-Discuss] PostGIS 2.5.0beta2 release

[Regina Obe]

The PostGIS Development team is pleased to release PostGIS 2.5.0beta2

Source:
https://downloads.osgeo.org/postgis/source/postgis-2.5.0beta2.tar.gz
Docs: 
PDF - https://downloads.osgeo.org/postgis/docs/postgis-2.5.0beta2.pdf
HTML - https://downloads.osgeo.org/postgis/docs/doc-html-2.5.0beta2.tar.gz
EPUB- https://downloads.osgeo.org/postgis/docs/postgis-2.5.0beta1.epub

Changes since 2.5.0beta1 are as follows:

* 4115, Fix a bug that created MVTs with incorrect property values under
parallel plans (Raúl Marín).
* 4120, ST_AsMVTGeom: Clip using tile coordinates (Raúl Marín).
* 4132, ST_Intersection on Raster now works without throwing
TopologyException
(Vinícius A.B. Schmidt, Darafei Praliaskouski)
* 4109, Fix WKT parser accepting and interpreting numbers with
multiple dots (Raúl Marín, Paul Ramsey)
* 4140, Use user-provided CFLAGS in address standardizer and the
topology module (Raúl Marín)
* 4143, Fix backend crash when ST_OffsetCurve fails (Dan Baston)
* 4145, Speedup MVT column parsing (Raúl Marín)


Please test and report any bugs to our ticket tracker or mailing list

http://postgis.net/support/


Thanks,
PostGIS Development Team

___
Discuss mailing list
Discuss@lists.osgeo.org
https://lists.osgeo.org/mailman/listinfo/discuss

[OSGeo-Discuss] GEOS 3.7.0beta2 and 3.6.3 released

[Regina Obe]

The GEOS development team is pleased to release the 3.7.0beta2 version.

https://download.osgeo.org/geos/geos-3.7.0beta2.tar.bz2

Change Log: https://trac.osgeo.org/geos/browser/git/NEWS?rev=3.7.0beta2

We are planning to have GEOS 3.7.0 out before September.


And GEOS 3.6.3

https://download.osgeo.org/geos/geos-3.6.3.tar.bz2

Change Log: https://trac.osgeo.org/geos/browser/git/NEWS?rev=3.6.3


We hope to have GEOS 3.5.2 out later this week.

Please test and report any issues.  

Thanks,
GEOS Development Team


___
Discuss mailing list
Discuss@lists.osgeo.org
https://lists.osgeo.org/mailman/listinfo/discuss

[OSGeo-Discuss] GEOS 3.7.0 is released

[Regina Obe]

The GEOS development team is proud to finally release GEOS 3.7.0.
After many years of soul searching, we finally got out a release.
Note this is the first release to require a C++11 compiler to compile.

Source code can be downloaded from:
https://download.osgeo.org/geos/geos-3.7.0.tar.bz2

3.7.0 changes
2018-09-10
- New things:
  - CAPI: GEOSDistanceIndexed (#795, Dan Baston)
  - CAPI: GEOSCoordSeq_isCCW (#870, Dan Baston)
  - CAPI: GEOSGeom_getXMin, GEOSGeom_getXMax,
  GEOSGeom_getYMin, GEOSGeom_getYMax (#871, Dan Baston)
  - CAPI: GEOSFrechetDistance (#797, Shinichi SUGIYAMA)
  - CAPI: GEOSReverse (#872, Dan Baston)
  - CAPI: GEOSGeomGetZ (#581, J Smith)

- Improvements
  - Interruptible snap operation (Paul Ramsey)
  - Numerous packaging, doc, and build changes
(Debian group: Bas Couwenberg, Francesco Paolo Lovergine)
(NetBSD: Greg Troxel)
  - Allow static library with C API for CMake builds (#878, Dakota Hawkins)

- C++ API changes:
  - Require defining USE_UNSTABLE_GEOS_CPP_API for use without
warnings.
  - Make C++11 required (Mateusz Loskot)
  - Use C++11 unique_ptr, nullptr, and override constructs
(Mateusz Loskot)
  - C++11 standard delete on noncopyable
(#851, Vicky Vergara)
  - Fix CommonBits::getBit to correctly handle i >= 32
(#834, Kurt Schwehr)

Thanks,
GEOS Development Team

___
Discuss mailing list
Discuss@lists.osgeo.org
https://lists.osgeo.org/mailman/listinfo/discuss

[OSGeo-Discuss] PostGIS Patch Releases for 2.2.7, 2.3.7, and 2.4.4

[Regina Obe]

The PostGIS development team is pleased to provide bug fix release 2.2.7,
2.3.7 and 2.4.4 for the 2.2, 2.3, and 2.4 stable branches.

Please note that PostGIS 2.2 is reaching end-of-life and there will be one
more patch release later in the year for it. 
If you have not upgraded to at least PostGIS 2.3, we encourage you do so
before we discontinue support for PostGIS 2.2.

http://postgis.net/2018/04/06/postgis-patches/


After installing the binaries or after running pg_upgrade, make sure to do:

ALTER EXTENSION postgis UPDATE;

- if you use the other extensions packaged with postgis - make sure to
upgrade those as well

ALTER EXTENSION postgis_sfcgal UPDATE;
ALTER EXTENSION postgis_topology UPDATE;
ALTER EXTENSION postgis_tiger_geocoder UPDATE;

If you use legacy.sql or legacy_minimal.sql, make sure to rerun the version
packaged with these releases.

2.2.7

Source: https://download.osgeo.org/postgis/source/postgis-2.2.7.tar.gz
NEWS:  https://svn.osgeo.org/postgis/tags/2.2.7/NEWS
PDF:  https://download.osgeo.org/postgis/docs/postgis-2.2.7.pdf

2.3.7

Source: https://download.osgeo.org/postgis/source/postgis-2.3.7.tar.gz
NEWS:  https://svn.osgeo.org/postgis/tags/23.7/NEWS
PDF:  https://download.osgeo.org/postgis/docs/postgis-2.3.7.pdf

2.4.4

Source: https://download.osgeo.org/postgis/source/postgis-2.4.4.tar.gz
NEWS:  https://svn.osgeo.org/postgis/tags/2.4.7/NEWS
PDF:  https://download.osgeo.org/postgis/docs/postgis-2.4.4.pdf

Report any issues to our bug tracker with details as noted in
http://postgis.net/support/

Thanks,
PostGIS Development Team

___
Discuss mailing list
Discuss@lists.osgeo.org
https://lists.osgeo.org/mailman/listinfo/discuss

[OSGeo-Discuss] PostGIS 2.5.0 released

[Regina Obe]

The PostGIS development team is pleased to release PostGIS 2.5.0.

Blog: http://postgis.net/2018/09/23/postgis-2.5.0/


Although this release will work for PostgreSQL 9.4 and above, 
to take full advantage of
what PostGIS 2.5 offers, you should be running PostgreSQL 11beta4+ and GEOS
3.7.0.

Best served with PostgreSQL 11beta4+ and pgRouting 2.6.1

WARNING: If compiling with PostgreSQL+JIT, LLVM >= 6 is required
Supported PostgreSQL versions for this release are:
PostgreSQL 9.4 - PostgreSQL 12 (in development)
GEOS >= 3.5

Source: https://download.osgeo.org/postgis/source/postgis-2.5.0.tar.gz

Documentation PDF: English:
https://download.osgeo.org/postgis/docs/postgis-2.5.0.pdf

German:
https://download.osgeo.org/postgis/docs/https://postgis.net/stuff/postgis-2.
5.0-de.pdf

Html Documentation:
https://download.osgeo.org/postgis/docs/doc-html-2.5.0.tar.gz


pgsql help files for non-english languages: 
 German:
https://download.osgeo.org/postgis/docs/pgsql-help-2.5-de.tar.gz

 Japanese:
https://download.osgeo.org/postgis/docs/pgsql-help-2.5-ja.tar.gz

 Korean:
https://download.osgeo.org/postgis/docs/pgsql-help-2.5-kr.tar.gz

 Portuguese:
https://download.osgeo.org/postgis/docs/pgsql-help-2.5-br.tar.gz 

 Spanish:
https://download.osgeo.org/postgis/docs/pgsql-help-2.5-es.tar.gz


Change Log: https://svn.osgeo.org/postgis/tags/2.5.0/ChangeLog


**New Features**
* 1847, spgist 2d and 3d support for PG 11+
(Esteban Zimányi and Arthur Lesuisse from Université Libre de Bruxelles
(ULB),
  Darafei Praliaskouski)
* 4056, ST_FilterByM (Nicklas Avén)
* 4050, ST_ChaikinSmoothing (Nicklas Avén)
* 3989, ST_Buffer single sided option (Stephen Knox)
* 3876, ST_Angle function (Rémi Cura)
* 3564, ST_LineInterpolatePoints (Dan Baston)
* 3896, PostGIS_Extensions_Upgrade() (Regina Obe)
* 3913, Upgrade when creating extension from unpackaged (Sandro Santilli)
* 2256, _postgis_index_extent() for extent from index (Paul Ramsey)
* 3176, Add ST_OrientedEnvelope (Dan Baston)
* 4029, Add ST_QuantizeCoordinates (Dan Baston)
* 4063, Optional false origin point for ST_Scale (Paul Ramsey)
* 4082, Add ST_BandFileSize and ST_BandFileTimestamp,
   extend ST_BandMetadata (Even Rouault)
* 2597, Add ST_Grayscale (Bborie Park)
* 4007, Add ST_SetBandPath (Bborie Park)
* 4008, Add ST_SetBandIndex (Bborie Park)

**Breaking Changes**
* 4054, ST_SimplifyVW changed from > tolerance to >= tolerance
* 3885, version number removed from address_standardize lib file
      (Regina Obe)
* 3893, raster support functions can only be loaded in the same schema
   with core PostGIS functions. (Sandro Santilli)
* 4035, remove dummy pgis_abs type from aggregate/collect routines.
   (Paul Ramsey)
* 4069, drop support for GEOS < 3.5 and PostgreSQL < 9.4 (Regina Obe)
* 4082, ST_BandMetaData extended to include filesize, timestamp (Even
Rouault)

**Enhancements and Fixes**
  - Upgrade scripts from multiple old versions are now all symlinks
to a single upgrade script (Sandro Santilli)
* 3944, Update to EPSG register v9.2 (Even Rouault)
* 3927, Parallel implementation of ST_AsMVT
* 3925, Simplify geometry using map grid cell size before generating MVT
* 3899, BTree sort order is now defined on collections of EMPTY and
   same-prefix geometries (Darafei Praliaskouski)
* 3864, Performance improvement for sorting POINT geometries
   (Darafei Praliaskouski)
* 3900, GCC warnings fixed, make -j is now working (Darafei Praliaskouski)
  - TopoGeo_addLinestring robustness improvements (Sandro Santilli)
#1855, #1946, #3718, #3838
* 3234, Do not accept EMPTY points as topology nodes (Sandro Santilli)
* 1014, Hashable geometry, allowing direct use in CTE signatures (Paul
Ramsey)
* 3097, Really allow MULTILINESTRING blades in ST_Split() (Paul Ramsey)
* 3942, geojson: Do not include private header for json-c >= 0.13 (Björn
Esser)
* 3954, ST_GeometricMedian now supports point weights (Darafei
Praliaskouski)
* 3965, #3971, #3977, #4071 ST_ClusterKMeans rewritten: better
initialization,
   faster convergence, K=2 even faster (Darafei Praliaskouski)
* 3982, ST_AsEncodedPolyline supports LINESTRING EMPTY and MULTIPOINT EMPTY
   (Darafei Praliaskouski)
* 3986, ST_AsText now has second argument to limit decimal digits
   (Marc Ducobu, Darafei Praliaskouski)
* 4020, Casting from box3d to geometry now returns correctly connected
   PolyhedralSurface (Matthias Bay)
* 2508, ST_OffsetCurve now works with collections (Darafei Praliaskouski)
* 4006, ST_GeomFromGeoJSON support for json and jsonb as input
   (Paul Ramsey, Regina Obe)
* 4038, ST_Subdivide now selects pivot for geometry split that reuses input
   vertices. (Darafei Praliaskouski)
* 4025, #4032 Fixed precision issue in ST_ClosestPointOfApproach,
   ST_DistanceCPA, and ST_CPAWithin (Paul Ramsey, Darafei
Praliaskouski)
* 4076, Reduce use of GEOS in topology implementation (Björn 

Re: [OSGeo-Discuss] PostGIS 2.5.0 released

[Regina Obe]

Well they just released PostgreSQL 11 Beta4.  I expect RC1 will follow.

I heard they are planning for Mid-Late October.

 

 

 

From: Jody Garnett [mailto:jody.garn...@gmail.com] 
Sent: Sunday, September 23, 2018 6:37 PM
To: Regina Obe 
Cc: David Fetter ; PostGIS Development Discussion 
; PostGIS Users Discussion 
; discuss@lists.osgeo.org; 
pgsql-annou...@postgresql.org
Subject: Re: [OSGeo-Discuss] PostGIS 2.5.0 released

 

Congrats! When is PostgreSQL 11 expected?

 

On Sun, Sep 23, 2018 at 3:27 PM Regina Obe mailto:l...@pcorp.us> > wrote:

The PostGIS development team is pleased to release PostGIS 2.5.0.

Blog: http://postgis.net/2018/09/23/postgis-2.5.0/


Although this release will work for PostgreSQL 9.4 and above, 
to take full advantage of
what PostGIS 2.5 offers, you should be running PostgreSQL 11beta4+ and GEOS
3.7.0.

Best served with PostgreSQL 11beta4+ and pgRouting 2.6.1

WARNING: If compiling with PostgreSQL+JIT, LLVM >= 6 is required
Supported PostgreSQL versions for this release are:
PostgreSQL 9.4 - PostgreSQL 12 (in development)
GEOS >= 3.5

Source: https://download.osgeo.org/postgis/source/postgis-2.5.0.tar.gz

Documentation PDF: English:
https://download.osgeo.org/postgis/docs/postgis-2.5.0.pdf

German:
https://download.osgeo.org/postgis/docs/https://postgis.net/stuff/postgis-2. 
<https://download.osgeo.org/postgis/docs/https:/postgis.net/stuff/postgis-2.5.0-de.pdf>
 
5.0-de.pdf

Html Documentation:
https://download.osgeo.org/postgis/docs/doc-html-2.5.0.tar.gz


pgsql help files for non-english languages: 
 German:
https://download.osgeo.org/postgis/docs/pgsql-help-2.5-de.tar.gz

 Japanese:
https://download.osgeo.org/postgis/docs/pgsql-help-2.5-ja.tar.gz

 Korean:
https://download.osgeo.org/postgis/docs/pgsql-help-2.5-kr.tar.gz

 Portuguese:
https://download.osgeo.org/postgis/docs/pgsql-help-2.5-br.tar.gz 

 Spanish:
https://download.osgeo.org/postgis/docs/pgsql-help-2.5-es.tar.gz


Change Log: https://svn.osgeo.org/postgis/tags/2.5.0/ChangeLog


**New Features**
* 1847, spgist 2d and 3d support for PG 11+
(Esteban Zimányi and Arthur Lesuisse from Université Libre de Bruxelles
(ULB),
  Darafei Praliaskouski)
* 4056, ST_FilterByM (Nicklas Avén)
* 4050, ST_ChaikinSmoothing (Nicklas Avén)
* 3989, ST_Buffer single sided option (Stephen Knox)
* 3876, ST_Angle function (Rémi Cura)
* 3564, ST_LineInterpolatePoints (Dan Baston)
* 3896, PostGIS_Extensions_Upgrade() (Regina Obe)
* 3913, Upgrade when creating extension from unpackaged (Sandro Santilli)
* 2256, _postgis_index_extent() for extent from index (Paul Ramsey)
* 3176, Add ST_OrientedEnvelope (Dan Baston)
* 4029, Add ST_QuantizeCoordinates (Dan Baston)
* 4063, Optional false origin point for ST_Scale (Paul Ramsey)
* 4082, Add ST_BandFileSize and ST_BandFileTimestamp,
   extend ST_BandMetadata (Even Rouault)
* 2597, Add ST_Grayscale (Bborie Park)
* 4007, Add ST_SetBandPath (Bborie Park)
* 4008, Add ST_SetBandIndex (Bborie Park)

**Breaking Changes**
* 4054, ST_SimplifyVW changed from > tolerance to >= tolerance
* 3885, version number removed from address_standardize lib file
  (Regina Obe)
* 3893, raster support functions can only be loaded in the same schema
   with core PostGIS functions. (Sandro Santilli)
* 4035, remove dummy pgis_abs type from aggregate/collect routines.
   (Paul Ramsey)
* 4069, drop support for GEOS < 3.5 and PostgreSQL < 9.4 (Regina Obe)
* 4082, ST_BandMetaData extended to include filesize, timestamp (Even
Rouault)

**Enhancements and Fixes**
  - Upgrade scripts from multiple old versions are now all symlinks
to a single upgrade script (Sandro Santilli)
* 3944, Update to EPSG register v9.2 (Even Rouault)
* 3927, Parallel implementation of ST_AsMVT
* 3925, Simplify geometry using map grid cell size before generating MVT
* 3899, BTree sort order is now defined on collections of EMPTY and
   same-prefix geometries (Darafei Praliaskouski)
* 3864, Performance improvement for sorting POINT geometries
   (Darafei Praliaskouski)
* 3900, GCC warnings fixed, make -j is now working (Darafei Praliaskouski)
  - TopoGeo_addLinestring robustness improvements (Sandro Santilli)
#1855, #1946, #3718, #3838
* 3234, Do not accept EMPTY points as topology nodes (Sandro Santilli)
* 1014, Hashable geometry, allowing direct use in CTE signatures (Paul
Ramsey)
* 3097, Really allow MULTILINESTRING blades in ST_Split() (Paul Ramsey)
* 3942, geojson: Do not include private header for json-c >= 0.13 (Björn
Esser)
* 3954, ST_GeometricMedian now supports point weights (Darafei
Praliaskouski)
* 3965, #3971, #3977, #4071 ST_ClusterKMeans rewritten: better
initialization,
   faster convergence, K=2 even faster (Darafei Praliaskouski)
* 3982, ST_AsEncodedPolyline supports LINESTRING EMPTY and MULTIPOINT EMPTY
   (Darafei Praliaskouski)
* 3986, ST_AsText now has second argument to limit decimal digits
   (M

[OSGeo-Discuss] PostGIS 2.4.6 and 2.3.8 Patch release

[Regina Obe]

The PostGIS development team is pleased to provide
bug fix releases 2.3.8 and 2.4.6 for the 2.3 and 2.4 stable branches.


**2.4.6**
This release supports PostgreSQL 9.3-10.

* source:  https://downloads.osgeo.org/postgis/source/postgis-2.4.6.tar.gz
* NEWS: https://git.osgeo.org/gitea/postgis/postgis/raw/tag/2.4.6/NEWS
* PDF docs: https://downloads.osgeo.org/postgis/docs/postgis-2.4.6.pdf
* html doc download:
https://downloads.osgeo.org/postgis/docs/doc-html-2.4.6.tar.gz
* html online:  https://postgis.net/docs/manual-2.4
* epub doc download:
https://downloads.osgeo.org/postgis/docs/postgis-2.4.6.epub
* Changelog: https://svn.osgeo.org/postgis/tags/2.4.6/ChangeLog

**2.3.8**

This release supports PostgreSQL 9.2-10.

* source: https://downloads.osgeo.org/postgis/source/postgis-2.3.8.tar.gz
* NEWS: https://git.osgeo.org/gitea/postgis/postgis/raw/tag/2.3.8/NEWS
* PDF docs en: https://downloads.osgeo.org/postgis/docs/postgis-2.3.8.pdf
* html doc download:
https://downloads.osgeo.org/postgis/docs/doc-html-2.3.8.tar.gz
* html online: https://postgis.net/docs/manual-2.3
* epub doc download:
https://downloads.osgeo.org/postgis/docs/postgis-2.3.8.epub
* Changelog: https://svn.osgeo.org/postgis/tags/2.3.8/ChangeLog

___
Discuss mailing list
Discuss@lists.osgeo.org
https://lists.osgeo.org/mailman/listinfo/discuss

[OSGeo-Discuss] PostGIS 2.5.1 is released

[Regina Obe]

The PostGIS development team is pleased to provide bug fix 2.5.1 for the 2.5
stable branch.

Full details are listed on website -
https://postgis.net/2018/11/18/postgis-2.5.1/

Source: https://download.osgeo.org/postgis/source/postgis-2.5.1.tar.gz
PDF: https://download.osgeo.org/postgis/docs/postgis-2.5.1.pdf
HTML: https://download.osgeo.org/postgis/docs/doc-html-2.5.1.tar.gz

We plan to release 2.4.6,  2.3.8, and final release of 2.2 (2.2.8) later
this week.

Happy Post Post Post GIS day,

PostGIS Development Team

___
Discuss mailing list
Discuss@lists.osgeo.org
https://lists.osgeo.org/mailman/listinfo/discuss

[OSGeo-Discuss] PostGIS 2.5.0rc2 release

[Regina Obe]

The PostGIS development team is pleased to release PostGIS 2.5.0rc2.

Blog: http://postgis.net/2018/09/16/postgis-2.5.0rc2/

Although this release will work for PostgreSQL 9.4 and above, to take full
advantage of
what PostGIS 2.5 offers, you should be running PostgreSQL 11beta3+ and GEOS
3.7.0.

Source: https://download.osgeo.org/postgis/source/postgis-2.5.0rc2.tar.gz
Documentation PDF: English:
https://download.osgeo.org/postgis/docs/postgis-2.5.0rc2.pdf 
 German:
https://download.osgeo.org/postgis/docs/https://postgis.net/stuff/postgis-2.
5.0rc2-de.pdf
Html Documentation:
https://download.osgeo.org/postgis/docs/doc-html-2.5.0rc2.tar.gz

pgsql help files for non-english languages: 
 German:
https://download.osgeo.org/postgis/docs/pgsql-help-2.5-de.tar.gz ,
 Japanese:
https://download.osgeo.org/postgis/docs/pgsql-help-2.5-ja.tar.gz
 Korean:
https://download.osgeo.org/postgis/docs/pgsql-help-2.5-kr.tar.gz 
 Portuguese:
https://download.osgeo.org/postgis/docs/pgsql-help-2.5-br.tar.gz 
 Spanish:
https://download.osgeo.org/postgis/docs/pgsql-help-2.5-es.tar.gz

Change Log: https://svn.osgeo.org/postgis/tags/2.5.0rc2/ChangeLog

WARNING: If compiling with PostgreSQL 11++JIT, LLVM >= 6 is required

Changes since PostGIS 2.5.0rc1 release are as follows:

4162, ST_DWithin documentation examples for storing geometry and radius
in table (Darafei Praliaskouski, github user Boscop).
4163, MVT: Fix resource leak when the first geometry is NULL (Raúl
Marín)
4172, Fix memory leak in lwgeom_offsetcurve (Raúl Marín)
4164, Parse error on incorrectly nested GeoJSON input (Paul Ramsey)
4176, ST_Intersects supports GEOMETRYCOLLECTION (Darafei Praliaskouski)
4177, Postgres 12 disallows variable length arrays in C (Laurenz Albe)
4160, Use qualified names in topology extension install (Raúl Marín)
4180, installed liblwgeom includes sometimes getting used instead of
source ones (Regina Obe)


We hope this will be the last RC before final release.  Please help us test.

Thanks,
PostGIS Development Team

___
Discuss mailing list
Discuss@lists.osgeo.org
https://lists.osgeo.org/mailman/listinfo/discuss

Re: [OSGeo-Discuss] [SAC] Flickr FOSS4G and OSGeo photo history deadline Feb 5th

[Regina Obe]

See my comments below

 

As covered on discuss a couple months ago, And covered in the board meeting on 
Monday:

 

Our OSGeo, FOSS4G and FOSS4G-NA photos on flicker may be reduced on Feb 5th as 
some photos are removed. 

 

Since these photos were shared with our groups we do not really know which ones 
will be removed. Photographers are asked to subscribe with a monthly fee (or 
have a limit of 1000 photos).

 

It is not really possible for us as a group to do much, which is a shame for 
the internet as Flickr has a wide range of CC images (since they did a good job 
of explaining open licenses and making them easily to use.)

 

Q: Can we throw the images on OSGeo next cloud?

[Regina Obe] Yes – We have 16terabytes of space (of I think 8 TB is usable if 
it's in a RAID config of some sort) 

want me to create a folder for said purpose?  I think it's possible to also 
share subfolders within that and display as gallery.

Nextcloud I think uses imagemagick to create thumbs and resized versions 
automatically. So I'd be interested in testing that out.  Last I tried if I 
thru a bunch of pictures in a folder on nextcloud, the pictures would show in 
the gallery widget and start out as small and then get larger as you went 
deeper.

 

It's also possible to attach like an FTP as a folder in nextcloud so we can 
investigate that too.

 

Q: Should we only copy the CC images? Or should we copy everything and try and 
reach authors before sharing?

[Regina Obe] Is it easy to separate the sets out?  I haven't used flickr so 
don't know.  I would think if they are in OSGeo shared gallery regardless of if 
authors mark them as CC, we could copy to another folder and have the authors 
sort them out.  It's better than losing them.

 

Aside: Many participants missed the CC license step - which is too bad as it is 
a good “first time” experience at contributing open content.  

 

Q: Anyone know of an API we could use to grab our images?[Regina Obe]   Have we 
checked if we can use Flickr's API or are their limits?  I've seen some scripts 
around that pull images using flickr's api

 

Thanks,

Regina

___
Discuss mailing list
Discuss@lists.osgeo.org
https://lists.osgeo.org/mailman/listinfo/discuss

[OSGeo-Discuss] PostGIS 2.5.2, PostGIS 2.4.7, PostGIS 2.3.9 released

[Regina Obe]

PostGIS Development team is proud to release a patch release for 2.5.2,
2.4.7, and 2.3.9

These are the first stable versions that can compile against the recently
released Proj 6.0.0

Full details in the release announcement -
https://postgis.net/2019/03/11/postgis-patches/

Thanks,
PostGIS Development Team



___
Discuss mailing list
Discuss@lists.osgeo.org
https://lists.osgeo.org/mailman/listinfo/discuss

[OSGeo-Discuss] PostGIS 3.0.0alpha1 released

[Regina Obe]

The PostGIS development team is pleased to release PostGIS 3.0.0alpha1.

This release works with PostgreSQL 9.5-12beta1  and GEOS >= 3.6

Best served with PostgreSQL 12beta1.

Details at: https://postgis.net/2019/05/26/postgis-3.0.0alpha1/

 

 

Source: https://download.osgeo.org/postgis/source/postgis-3.0.0alpha1.tar.gz

Docs PDF: https://download.osgeo.org/postgis/docs/postgis-3.0.0alpha1.pdf

Docs HTML:
https://download.osgeo.org/postgis/docs/doc-html-3.0.0alpha1.tar.gz

NEWS: https://git.osgeo.org/gitea/postgis/postgis/raw/tag/3.0.0alpha1/NEWS

 

Aside from the added functions and enhancements detailed in the news

The major changes that make PostGIS 3.0 different from prior versions

 

1)  The raster support has been broken out into its own extension so
from PostGIS 3 and moving forward to get raster support you need to install
the raster extension as follows:

 

CREATE EXTENSION postgis;

CREATE EXTENSION postgis_raster;

 

This was to satisfy non-raster users wanting fewer functions in their
postgis install and also to allow those folks 

who can't build with GDAL support to still be able to use PostgreSQL
extension plumbing for installing postgis

 

 

2)  The Lib minor has been removed by default from the lib file.

This was done to ease future pg_upgrade.

So from now  for each PostGIS 3 minor that follows

e.g. 3.1, 3.2 etc

 

the lib files will remain the same with extension -3 instead of -3.1, -3.2
and so forth.

Any removals of functions we do from now on will be stubbed with an error so
that pg_upgrade can be  done smoothly from prior PostgreSQL installs.

 

 

3)  This one is specifically designed for PostgreSQL 12 - PostgreSQL 12
is the first version to no longer rely on SQL inlining.

For more than 10 years - PostGIS has been relying on what is called - SQL
inlining - which allows us to define the function  ST_Intersects and many
others as a combination of  && and _ST_Intersects  because && was the only
piece that could use the index and the planner would peak into the function
and break them apart into separate steps.

 

This has prevented us from properly costing our functions because if they
are costed right, then inlining  breaks and the index never kicks in.

It also would just for whatever reason on occasion when the planner decided
not to inline the function, result in very slow queries.

People have complained on the list on occasion of cases where the index did
not kick in as a result.

 

PostgreSQL 12 introduced support functions in operator definition that
PostGIS 3 uses for ST_Intersects and family so that the function can
natively use the index without any inlining tricks.  This means we can now
start properly costing things and also result in better plans since the
planner won't accidentally not use an index because it decided not to
inline.

 

4)  For those running Proj6+ PostGIS 3.0 is first version to leverage
Proj6 features - refer to -
http://blog.cleverelephant.ca/2019/02/proj4-postgis.html

5)  postgis.backend GUC has been removed.  The main reason for its
existence was to allow same named SFCGAL functions to take over the
behavior.

The 3D functions in postgis like ST_3DIntersects that couldn't support TINS
or solid 3D geometries have been augmented to support these so no longer
need SFCGAL to achieve the same functionality and same named functions were
from from postgis_sfcgal extension.

 

 

Please test in particular the above features (more itemized in the NEWs) and
report back if anything does not behave as you would expect.

 

Happy spatial querying,

PostGIS Development Team

 

 

___
Discuss mailing list
Discuss@lists.osgeo.org
https://lists.osgeo.org/mailman/listinfo/discuss

[OSGeo-Discuss] PostGIS 3.0.0 alpha2 released

[Regina Obe]

The PostGIS development team is pleased to release PostGIS 3.0.0alpha2.

This release works with PostgreSQL 9.5-12beta1  and GEOS >= 3.6

Best served with PostgreSQL 12beta1.

Details at: https://postgis.net/2019/06/02/postgis-3.0.0alpha2/


Source: https://download.osgeo.org/postgis/source/postgis-3.0.0alpha2.tar.gz

Docs PDF: https://download.osgeo.org/postgis/docs/postgis-3.0.0alpha2.pdf

Docs HTML:
https://download.osgeo.org/postgis/docs/doc-html-3.0.0alpha2.tar.gz

NEWS: https://git.osgeo.org/gitea/postgis/postgis/raw/tag/3.0.0alpha2/NEWS

Key changes since the 3.0.0alpha2 are as follows:

#4044: Fix selectivity issue with support functions. (Paul Ramsey)
This resulted in significant improvement in leveraging parallelism for
PostgreSQL 12
NOTE: You need to be running PostgreSQL 12beta1 to take advantage of this.

#4311: Make wagyu the default option to validate polygons. 
This option requires a C++11 compiler and will use CXXFLAGS (not CFLAGS). 
It is only enabled if built with MVT support (protobuf) and should speed up
mvt tile generation
Add --without-wagyu to disable this option and keep the behavior from 2.5
(Raúl Marín)

4198, Add ST_ConstrainedDelaunayTriangles SFCGAL function (Darafei
Praliaskouski)
Note you need to do: CREATE EXTENSION postgis_sfcgal;
To have the new function available.

Please test and report back with any issues.

Thank you,
PostGIS Development Team







___
Discuss mailing list
Discuss@lists.osgeo.org
https://lists.osgeo.org/mailman/listinfo/discuss

[OSGeo-Discuss] Adhoc has been moved

[Regina Obe]

FYI adhoc.osgeo.osuosl.org has been moved (I also added an adhoc.osgeo.org
so it's more controllable by us, but kept the osuosl.org for backward
compatibility)
If you had stuff running on it:

https://wiki.osgeo.org/wiki/AdhocVM

Please confirm your stuff is still working and if not, send me an email. If
I have not talked to you, your stuff is probably broken.
Send me an email to confirm you are still using it and I can resuscitate it.

If you need to get into the new one, you have one of two options:

Option 1 - the preferred is to go thru download.osgeo.org (note this only
works if you installed your ssh key in download.osgeo.org before I shut off
password access).

You can do something like:

add this to your ~/.ssh/config

Host old-adhoc.lxd
 User your_ldap_name
 ProxyJump your_ldap_n...@download.osgeo.org


Option 2 - which I'd like to get rid of in the near future is to use port
50024

ssh your_ldap_n...@adhoc.osgeo.org -p 50024


I'd like to get rid of option 2 to reduce our surface exposure.


Thanks,
Regina




___
Discuss mailing list
Discuss@lists.osgeo.org
https://lists.osgeo.org/mailman/listinfo/discuss

[OSGeo-Discuss] Download server has moved and requires SSH key access to upload

[Regina Obe]

Just and FYI, I moved the download.osgeo.org, upload.osgeo.org to a new home
yesterday.
It is now on a debian 9, running nginx (instead of Apache)

And most importantly the thing that tripped up a lot of people is I have
blocked password access.

If you did not have your ssh public keys installed on the old server, it
means you will not be able to upload your project artifacts.  

A couple of people have had issues with this of which I have resolved by
putting their public key in their home folders.

If you are having issues, please put in a SAC ticket.

https://trac.osgeo.org/osgeo/newticket

and one of us will address.

Thanks,
Regina




___
Discuss mailing list
Discuss@lists.osgeo.org
https://lists.osgeo.org/mailman/listinfo/discuss

[OSGeo-Discuss] PostGIS 3.0.0alpha3 released

[Regina Obe]

The PostGIS development team is pleased to release PostGIS 3.0.0alpha3.

 

http://www.postgis.net/2019/07/01/postgis-3.0.0alpha3/

 

This release works with PostgreSQL 9.5-12beta2  and GEOS >= 3.6

 

Best served with [PostgreSQL 12beta2]
https://www.postgresql.org/developer/beta/

 

 

**3.0.0alpha3**

 

* [source
download]https://download.osgeo.org/postgis/source/postgis-3.0.0alpha3.tar.g
z

* [NEWS]
https://git.osgeo.org/gitea/postgis/postgis/raw/tag/3.0.0alpha3/NEWS

* PDF docs [en]
https://download.osgeo.org/postgis/docs/postgis-3.0.0alpha3.pdf

* [html doc download]
https://download.osgeo.org/postgis/docs/doc-html-3.0.0alpha3.tar.gz

* [epub doc download]
https://download.osgeo.org/postgis/docs/postgis-3.0.0alpha3.epub

* [Changelog]https://svn.osgeo.org/postgis/tags/3.0.0alpha3/ChangeLog

 

View all [closed tickets for 3.0.0]
https://trac.osgeo.org/postgis/query?status=closed=fixed
e=PostGIS+3.0.0=id=summary=milestone=status=type=pri
ority=component=priority

 

 

Main changes since PostGIS 3.0.0alpha2 release are as follows:

 

* 4438, Update serialization to support extended flags area (Paul Ramsey)

* 3437, Speed up ST_Intersects with Points (Raúl Marín)

* 4352, Use CREATE OR REPLACE AGGREGATE for PG12+ (Raúl Marín)

* 4441, Make GiST penalty friendly to multi-column indexes and build
single-column

 ones faster. (Darafei Praliaskouski)

* 4372, PROJ6: Speed improvements (Raúl Marín)

* 4414, Include version number in address_standardizer lib (Raúl Marín)

* 4334, Fix upgrade issues related to renamed parameters (Raúl Marín)

* 4388, AddRasterConstraints: Ignore NULLs when generating constraints (Raúl
Marín)

* 4327, Avoid pfree'ing the result of getenv (Raúl Marín)

* 4406, Throw on invalid characters when decoding geohash (Raúl Marín)

* 4429, Avoid resource leaks with PROJ6 (Raúl Marín)

* 4443, Fix wagyu configure dropping CPPFLAGS (Raúl Marín)

* 4440, Type lookups in FDW fail (Paul Ramsey)

* 4442, raster2pgsql now skips NODATA tiles. Use -k option if you still want

 them in database for some reason. (Darafei Praliaskouski)

 

 

Happy Testing,

PostGIS Development Team

___
Discuss mailing list
Discuss@lists.osgeo.org
https://lists.osgeo.org/mailman/listinfo/discuss

[OSGeo-Discuss] PostGIS 3.0.0alpha4, 2.5.3, 2.4.8, 2.3.10 patch releases

[Regina Obe]

The PostGIS Development team is happy to release bug fix release for stable
branches and feature updates for PostGIS 3.0

 

Details here:

https://postgis.net/2019/08/11/postgis-patches/

 

Thanks,

PostGIS Development Team

___
Discuss mailing list
Discuss@lists.osgeo.org
https://lists.osgeo.org/mailman/listinfo/discuss

Re: [OSGeo-Discuss] [SAC] www.osgeo.org moved to osgeo7 server

[Regina Obe]

Sorry I had forgotten to send this to discuss.

 

FYI that www.osgeo.org <http://www.osgeo.org>  has moved to our own servers and 
we made some recent adjustments that should hopefully clear up the speed issues 
people were complaining about.

The main change was disabling libavatar replace plugin which was causing a bulk 
of the slowness.

Please checkout to make sure all works for you.

 

Thanks,

Regina

 

From: Sac [mailto:sac-boun...@lists.osgeo.org] On Behalf Of Jody Garnett
Sent: Wednesday, September 4, 2019 12:51 AM
To: System Administration Committee Discussion/OSGeo 
Cc: proje...@lists.osgeo.org; OSGeo-Board 
Subject: Re: [SAC] www.osgeo.org moved to osgeo7 server

 

Thanks! I hope this will help with performance issues :)

 

You may wish to also send to discuss as many folks have access (for local 
chapters, geoforall labs, news announcements and events).


--

Jody Garnett

 

 

On Tue, 3 Sep 2019 at 16:24, Regina Obe mailto:l...@pcorp.us> > 
wrote:

We had planned sometime to move www.osgeo.org <http://www.osgeo.org>  back to 
our own servers once we had enough server resources.

Before we were using a VM provided by OSUOSL.

 

I moved www.osgeo.org <http://www.osgeo.org>  to osgeo7 about 20-30 minutes 
ago.  Please refrain from making any changes for the next 24 hours to allow DNS 
change to propagate.

 

If you run into issues, please let me know.

 

I’m hoping that this resolves some of our speed issues we’ve had for the past 2 
months.

 

If you run into any issues, please post a ticket at  
https://trac.osgeo.org/osgeo/newticket

 

Thanks,

Regina

___
Sac mailing list
s...@lists.osgeo.org <mailto:s...@lists.osgeo.org> 
https://lists.osgeo.org/mailman/listinfo/sac

___
Discuss mailing list
Discuss@lists.osgeo.org
https://lists.osgeo.org/mailman/listinfo/discuss

[OSGeo-Discuss] PostGIS 3.0.0beta1 is released

[Regina Obe]

The PostGIS Development team is pleased to release PostGIS 3.0.0beta1.

More details here: https://postgis.net/2019/09/28/postgis-3.0.0beta1/ 

 

Source tar ball:
https://download.osgeo.org/postgis/source/postgis-3.0.0beta1.tar.gz

 

Note that PostGIS 3.0 takes advantage of 

 

1)  Performance improvements in GEOS 3.8.0beta1 which was released
yesterday:
https://lists.osgeo.org/pipermail/geos-devel/2019-September/009267.html

2)  Features and performance enhancements for  PostgreSQL 12RC1 released
a couple of days ago - https://www.postgresql.org/developer/beta/

 

We encourage you to test with this family of products even if you are using
lower versions of these.  We are most interested in any upgrade (including
pg_upgrade)  issues people are facing going from a PostGIS 2.something to
PostGIS 3.0

 

Please report back with any issues at the PostGIS Users / PostGIS
development lists or in our bug tracker - 

https://postgis.net/support/

 

 

Thanks,

PostGIS Development Team

 

 

___
Discuss mailing list
Discuss@lists.osgeo.org
https://lists.osgeo.org/mailman/listinfo/discuss

[OSGeo-Discuss] trac.osgeo.org, svn.osgeo.org, git.osgeo.org DNS moved to pointed to OSGeo7

[Regina Obe]

I have moved the DNS for trac.osgeo.org, svn.osgeo.org, git.osgeo.org to
OSGeo7.

 

Note that this just means the sites will be proxied thru NGINX but is still
pointing at tracsvn.osgeo.osuosl.org.

 

This first step is to make sure no unforeseen issues with proxying the
traffick and to have 0 DNS transition downtime when I do the final server
move next week.

 

I don't expect there to be any issues, but if you run into any - please
reply back to this email or report on our ticket tracker.

 

https://trac.osgeo.org/osgeo

 

Of course if you are having issues, you might not be able to get to our
ticket tracker.

 

Next weekend when I do the official server move, I expect there to be 1-2 hr
downtime as I need to shut off the services and transfer the VM.

 

I'll send a note when I start that and put a note on all the sites that they
are under maintenance.

 

Thanks,

Regina

___
Discuss mailing list
Discuss@lists.osgeo.org
https://lists.osgeo.org/mailman/listinfo/discuss

[OSGeo-Discuss] old.www.osgeo.org has been moved to osgeo7

[Regina Obe]

The web.osuosl.osgeo.org VM on osgeo3  I think the last thing I had running
on it was the old.www.osgeo.org and some of the rewrites.

 

I haven't moved over all the rewrites, but I feel a lot of them might be
obsolete.

 

I've shut down the apache on the old VM to see what breaks and will keep it
like that for a while and then shut it off for good.

 

If you run into any issues with things not working please let me know either
by responding to this email or a trac ticket.

 

https://trac.osgeo.org/osgeo

 

Thanks,

Regina

___
Discuss mailing list
Discuss@lists.osgeo.org
https://lists.osgeo.org/mailman/listinfo/discuss

[OSGeo-Discuss] PostGIS 3.0.0 released

[Regina Obe]

The PostGIS development Team is happy to finally release PostGIS 3.0.0

after many alphas, betas, and rcs.

 

A special thank you  to all the testers and package managers who tried our
pre-release releases and reported issues.

 

Details in the news link below including links to the documentation

 

(including English, German, Korean, and Japanese)

 

https://postgis.net/2019/10/20/postgis-3.0.0/  

 

Source Tarball:

 

https://download.osgeo.org/postgis/source/postgis-3.0.0.tar.gz

 

NEWS: https://git.osgeo.org/gitea/postgis/postgis/raw/tag/3.0.0/NEWS

 

 

Please test and report back issues either on the mailing list or our bug
tracker:

 

https://postgis.net/support/

 

Happy spatializing

 

PostGIS Development Team

___
Discuss mailing list
Discuss@lists.osgeo.org
https://lists.osgeo.org/mailman/listinfo/discuss

[OSGeo-Discuss] OSGeo Gitea upgraded to 1.9.4

[Regina Obe]

OSGeo Gitea instance - https://git.osgeo.org/gitea/

Has been upgraded to latest version 1.9.4.
Please report any issues you find on https://trac.osgeo.org/osgeo


Key features from the release we were using:

Pull request review/approval and comment on code​
 Compare branches, commits and tags with each other
 Show git-notes (#6984)
Pull request conflict files detection (#5951)
Add commit statuses reports on pull request view (#6845)
Add push webhook support for mirrored repositories (#4127)
Add csv file render support defaultly (#4105)
Disable merging a WIP Pull request (#4529)

Others:
 Content API for Creating, Updating, Deleting Files (#6314)
Fixes #2738 - Adds the /git/tags API endpoint (#7138)
Show Pull Request button or status of latest PR in branch list (#6990)
Repository avatars (#6986)
Number of commits ahead/behind in branch overview (#6695)
Add CLI commands to manage LDAP authentication source (#6681)
Add support for MS Teams webhooks (#6632)
OAuth2 Grant UI (#6625)
Add SUBJECT_PREFIX mailer config option (#6605)
Include custom configuration file in dump (#6516)
Add API for manipulating Git hooks (#6436)
Improve migrations to support migrating 
milestones/labels/issues/comments/pullrequests (#6290) 
Add option to blame files (#5721)
Implement Default Webhooks (#4299)
Telegram webhook (#4227)

Add regenerate secret feature for oauth2 (#6291)
Expose issue stopwatch toggling via API (#5970)
Add other session providers (#5963)
Integrate OAuth2 Provider (#5378)
Implement “conversation lock” for issue comments (#5073)
Archive repos (#5009)
Discord Oauth2 support (#4476)
Allow to set organization visibility (public, internal, private) (#1763)
Added URL mapping for Release attachments like on github.com (#1707)

Implement git refs API for listing references (branches, tags and other) (#5354)
Approvals at Branch Protection (#5350)
Add raw blob endpoint to get objects by SHA ID (#5334)
Add api for user to create org (#5268)
Create AuthorizedKeysCommand (#5236)
User action heatmap (#5131)
Refactor heatmap to vue component (#5401)
Add command for migrating database (#4954)
Search keyword by splitting provided values by , (#4939)
Create Progressive Web App (#4730)
Give user a link to create PR after push (#4716)
Add rebase with merge commit merge style (#3844) (#4052)
Webhook for Pull Request approval/rejection (#5027)

Add comment replies (#5147) (#5104)
Pull request review/approval and comment on code (#3748)
Added dependencies for issues (#2196) (#2531)
Add the ability to have built in themes in Gitea and provide dark theme 
arc-green (#4198)
Add sudo functionality to the API (#4809)
Add oauth providers via cli (#4591)
Force user to change password (#4489)
Add letsencrypt to Gitea (#4189)
Add Recaptcha functionality to Gitea (#4044)

Thanks,
Regina

___
Discuss mailing list
Discuss@lists.osgeo.org
https://lists.osgeo.org/mailman/listinfo/discuss

[OSGeo-Discuss] OSUOSL mirror link on download page

[Regina Obe]

We never got around to load balancing our download.osgeo.org with the osuosl
ftp one.

Part of me is thinking maybe it's not worth it to do so especially since the
osuosl one is not real time - could lag by hours.

 

So instead, I just put the link to their mirror on our download page.

 

https://download.osgeo.org/  in cases where we may need extra bandwidth e.g.
QGIS downloads.

 

the other benefit to theirs is it does support the ftp protocol in addition
to http.

 

Let me know if anyone has issues with this change.

 

Thanks,

Regina

 

 

 

 

 

 

___
Discuss mailing list
Discuss@lists.osgeo.org
https://lists.osgeo.org/mailman/listinfo/discuss

[OSGeo-Discuss] Going to be taking trac down soon

[Regina Obe]

I'm going to be taking trac down in a bit probably about 15-30 minutes and
should hopefully have it back up in an hour or two after.

 

I'll send note when it's back up.

 

Thanks,

Regina

OSGeo System Admin

___
Discuss mailing list
Discuss@lists.osgeo.org
https://lists.osgeo.org/mailman/listinfo/discuss

Re: [OSGeo-Discuss] Going to be taking trac down soon

[Regina Obe]

Sorry forgot to mention in last email.  This will affect the following sites

 

trac.osgeo.org

svn.osgeo.org

git.osgeo.org

 

From: Regina Obe [mailto:l...@pcorp.us] 
Sent: Friday, October 11, 2019 11:41 PM
To: 'System Administration Committee Discussion/OSGeo' 
Cc: 'OSGeo Discussions' ;
'proje...@lists.osgeo.org' 
Subject: Going to be taking trac down soon

 

I'm going to be taking trac down in a bit probably about 15-30 minutes and
should hopefully have it back up in an hour or two after.

 

I'll send note when it's back up.

 

Thanks,

Regina

OSGeo System Admin

___
Discuss mailing list
Discuss@lists.osgeo.org
https://lists.osgeo.org/mailman/listinfo/discuss

Re: [OSGeo-Discuss] Going to be taking trac down soon

[Regina Obe]

TracSVN has been moved to osgeo7 as container named tracsvn.

I will shut down the old VM on osgeo3 in a couple of days.

Please let me know if you run into issues using

 

https://trac.osgeo.org

https://svn.osgeo.org

https://git.osgeo.org/gitea

 

For those who need to ssh to the server - you can do so following
instructions here:

 

https://wiki.osgeo.org/wiki/SAC_Service_Status#Accessing_osgeo7_containers_v
ia_ssh

 

Thanks,

Regina

 

From: Regina Obe [mailto:l...@pcorp.us] 
Sent: Friday, October 11, 2019 11:43 PM
To: 'System Administration Committee Discussion/OSGeo' 
Cc: 'OSGeo Discussions' ;
'proje...@lists.osgeo.org' 
Subject: RE: Going to be taking trac down soon

 

Sorry forgot to mention in last email.  This will affect the following sites

 

trac.osgeo.org

svn.osgeo.org

git.osgeo.org

 

From: Regina Obe [mailto:l...@pcorp.us] 
Sent: Friday, October 11, 2019 11:41 PM
To: 'System Administration Committee Discussion/OSGeo' mailto:s...@lists.osgeo.org> >
Cc: 'OSGeo Discussions' mailto:discuss@lists.osgeo.org> >; 'proje...@lists.osgeo.org'
mailto:proje...@lists.osgeo.org> >
Subject: Going to be taking trac down soon

 

I'm going to be taking trac down in a bit probably about 15-30 minutes and
should hopefully have it back up in an hour or two after.

 

I'll send note when it's back up.

 

Thanks,

Regina

OSGeo System Admin

___
Discuss mailing list
Discuss@lists.osgeo.org
https://lists.osgeo.org/mailman/listinfo/discuss

[OSGeo-Discuss] PostGIS 3.0.0rc2 released

[Regina Obe]

The PostGIS development Team is happy to release PostGIS 3.0.0rc2.

This is the final rc before we release - expected next week.

Details in the news link below including links to the  documentation

(including English, German, Korean, and Japanese)

https://postgis.net/2019/10/13/postgis-3.0.0rc2/  

 

 

Source Tarball:

https://download.osgeo.org/postgis/source/postgis-3.0.0rc2.tar.gz

 

NEWS: https://git.osgeo.org/gitea/postgis/postgis/raw/tag/3.0.0rc2/NEWS

 

 

This release also includes translations for German, Korean, and Japanese.

 

Please test and report back issues either on the mailing list or our bug

tracker:

https://postgis.net/support/

 

Thanks,

PostGIS Development Team

___
Discuss mailing list
Discuss@lists.osgeo.org
https://lists.osgeo.org/mailman/listinfo/discuss

[OSGeo-Discuss] webextra.osgeo.osuosl.org is now old-webextra on osgeo7

[Regina Obe]

I created a replica of webextra.osgeo.osuosl.org and moved a ton of sites
from it to osgeo7.

 

I have shutoff the webservice on webextra.osgeo.osuosl.org.  I plan to
shutoff the server completely this coming week to see if anything breaks.

This I think is the VM on osgeo3 to go, so once a grace period of week after
shut-off is done, I plan to have it reformatted so it can be used for
production containers

 

For those who used this server, can you verify you can connect to the new
home on osgeo7 

 

Using instructions here:

https://wiki.osgeo.org/wiki/SAC_Service_Status#osgeo_7

 

So the login would be

 

ssh your_ldap_user_name@osgeo7-old-webextra

 

 

Key notable things that were on that server that I moved

 

1)  live.osgeo.org - I'm not sure how this is updated, so whoever is n
charge of this should verify they can update using new setup

2)  planet.osgeo.org

3)  Various foss4g archives including video.foss4g.org

4)  Munin (not resetup but plan to setup a new container for it)

5)  journal.osgeo.org (Not sure what this is tempted to just kill it)

 

 

Thanks,

Regina

___
Discuss mailing list
Discuss@lists.osgeo.org
https://lists.osgeo.org/mailman/listinfo/discuss

[OSGeo-Discuss] OSGeo7 patch updates later today

[Regina Obe]

I'm planning to do some patch updates to OSGeo7 host in a couple of hours.

This will cause some period of downtime on 

Main website: www.osgeo.org
Download.osgeo.org
Trac.osgeo.org
Git.osgeo.org

And other things listed on this page:
https://wiki.osgeo.org/wiki/SAC_Service_Status#osgeo_7


I don't expect the downtime to be more than 1/2 hr.  I will send another
notice just before and just after.

If you have an issue with this feel free to respond.

Thanks,
Regina

___
Discuss mailing list
Discuss@lists.osgeo.org
https://lists.osgeo.org/mailman/listinfo/discuss

Re: [OSGeo-Discuss] OSGeo7 patch updates later today

[Regina Obe]

Patch update on osgeo7 completed.

> -Original Message-
> From: Regina Obe [mailto:l...@pcorp.us]
> Sent: Friday, February 28, 2020 10:58 PM
> To: 'OSGeo Discussions' 
> Cc: 'proje...@lists.osgeo.org' ; 'System
> Administration Committee Discussion/OSGeo' 
> Subject: RE: OSGeo7 patch updates later today
> 
> I'll be starting patch updates soon and will send another notice once I'm
> finished.
> 
> Thanks,
> Regina
> 
> > -Original Message-
> > From: Regina Obe [mailto:l...@pcorp.us]
> > Sent: Friday, February 28, 2020 4:51 PM
> > To: 'OSGeo Discussions' 
> > Cc: 'proje...@lists.osgeo.org' ; 'System
> > Administration Committee Discussion/OSGeo' 
> > Subject: OSGeo7 patch updates later today
> >
> > I'm planning to do some patch updates to OSGeo7 host in a couple of
> hours.
> >
> > This will cause some period of downtime on
> >
> > Main website: www.osgeo.org
> > Download.osgeo.org
> > Trac.osgeo.org
> > Git.osgeo.org
> >
> > And other things listed on this page:
> > https://wiki.osgeo.org/wiki/SAC_Service_Status#osgeo_7
> >
> >
> > I don't expect the downtime to be more than 1/2 hr.  I will send
> > another notice just before and just after.
> >
> > If you have an issue with this feel free to respond.
> >
> > Thanks,
> > Regina

___
Discuss mailing list
Discuss@lists.osgeo.org
https://lists.osgeo.org/mailman/listinfo/discuss

Re: [OSGeo-Discuss] OSGeo7 patch updates later today

[Regina Obe]

I'll be starting patch updates soon and will send another notice once I'm
finished.  

Thanks,
Regina

> -Original Message-
> From: Regina Obe [mailto:l...@pcorp.us]
> Sent: Friday, February 28, 2020 4:51 PM
> To: 'OSGeo Discussions' 
> Cc: 'proje...@lists.osgeo.org' ; 'System
> Administration Committee Discussion/OSGeo' 
> Subject: OSGeo7 patch updates later today
> 
> I'm planning to do some patch updates to OSGeo7 host in a couple of hours.
> 
> This will cause some period of downtime on
> 
> Main website: www.osgeo.org
> Download.osgeo.org
> Trac.osgeo.org
> Git.osgeo.org
> 
> And other things listed on this page:
> https://wiki.osgeo.org/wiki/SAC_Service_Status#osgeo_7
> 
> 
> I don't expect the downtime to be more than 1/2 hr.  I will send another
> notice just before and just after.
> 
> If you have an issue with this feel free to respond.
> 
> Thanks,
> Regina

___
Discuss mailing list
Discuss@lists.osgeo.org
https://lists.osgeo.org/mailman/listinfo/discuss

Re: [OSGeo-Discuss] Nextcloud.osgeo.org will be upgraded in the next 24 hrs - COMPLETED

[Regina Obe]

Upgrade is complete

> -Original Message-
> From: Regina Obe [mailto:l...@pcorp.us]
> Sent: Thursday, April 9, 2020 11:37 AM
> To: 'discuss@lists.osgeo.org' ;
> 'proje...@lists.osgeo.org' 
> Cc: 's...@lists.osgeo.org' 
> Subject: RE: Nextcloud.osgeo.org will be upgraded in the next 24 hrs
> 
> Nextcloud going down in about 10 - 15 minutes from now.
> 
> > -Original Message-
> > From: Regina Obe [mailto:l...@pcorp.us]
> > Sent: Wednesday, April 8, 2020 11:55 PM
> > To: 'discuss@lists.osgeo.org' ;
> > 'proje...@lists.osgeo.org' 
> > Cc: 's...@lists.osgeo.org' 
> > Subject: Nextcloud.osgeo.org will be upgraded in the next 24 hrs
> >
> > I plan to upgrade https://nextcloud.osgeo.org to 18.0.3 later today.
> > Plans detailed here - https://trac.osgeo.org/osgeo/ticket/2243
> >
> > I don't expect there to be more than 1 hr downtime during the process.
> >
> > I will send out another notice just before I start the upgrade.
> >
> > Email me if this poses a problem for you.
> >
> > Thanks,
> > Regina

___
Discuss mailing list
Discuss@lists.osgeo.org
https://lists.osgeo.org/mailman/listinfo/discuss

[OSGeo-Discuss] Nextcloud.osgeo.org will be upgraded in the next 24 hrs

[Regina Obe]

I plan to upgrade https://nextcloud.osgeo.org to 18.0.3 later today.  Plans
detailed here - https://trac.osgeo.org/osgeo/ticket/2243 

I don't expect there to be more than 1 hr downtime during the process.

I will send out another notice just before I start the upgrade.

Email me if this poses a problem for you.

Thanks,
Regina

___
Discuss mailing list
Discuss@lists.osgeo.org
https://lists.osgeo.org/mailman/listinfo/discuss

[OSGeo-Discuss] OSGeo7 going down for routine maintenance

[Regina Obe]

OSGeo7 will be going down in about 0-2 hrs for routine maintenance.

Servers affected are

ldap.osgeo,org  (which affects a lot of things),  trac.osgeo.org,
git.osgeo.org, wiki.osgeo.org, download.osgeo.org, nextcloud.osgeo.org
staging.grass.osgeo.org, osgeo.org, www.osgeo.org, old-webextra, old-adhoc,
old-projects

I'll send a note once maintenance is complete.

Thanks,
Regina

___
Discuss mailing list
Discuss@lists.osgeo.org
https://lists.osgeo.org/mailman/listinfo/discuss

Re: [OSGeo-Discuss] OSGeo7 going down for routine maintenance - COMPLETED

[Regina Obe]

OSGeo7 is now back up.

> -Original Message-
> From: Regina Obe [mailto:l...@pcorp.us]
> Sent: Saturday, April 18, 2020 11:33 PM
> To: 'discuss@lists.osgeo.org' ;
> 'proje...@lists.osgeo.org' 
> Cc: 's...@lists.osgeo.org' 
> Subject: OSGeo7 going down for routine maintenance
> 
> OSGeo7 will be going down in about 0-2 hrs for routine maintenance.
> 
> Servers affected are
> 
> ldap.osgeo,org  (which affects a lot of things),  trac.osgeo.org,
> git.osgeo.org, wiki.osgeo.org, download.osgeo.org, nextcloud.osgeo.org
> staging.grass.osgeo.org, osgeo.org, www.osgeo.org, old-webextra, old-
> adhoc, old-projects
> 
> I'll send a note once maintenance is complete.
> 
> Thanks,
> Regina

___
Discuss mailing list
Discuss@lists.osgeo.org
https://lists.osgeo.org/mailman/listinfo/discuss

Re: [OSGeo-Discuss] Nextcloud.osgeo.org will be upgraded in the next 24 hrs

[Regina Obe]

Nextcloud going down in about 10 - 15 minutes from now.

> -Original Message-
> From: Regina Obe [mailto:l...@pcorp.us]
> Sent: Wednesday, April 8, 2020 11:55 PM
> To: 'discuss@lists.osgeo.org' ;
> 'proje...@lists.osgeo.org' 
> Cc: 's...@lists.osgeo.org' 
> Subject: Nextcloud.osgeo.org will be upgraded in the next 24 hrs
> 
> I plan to upgrade https://nextcloud.osgeo.org to 18.0.3 later today.
Plans
> detailed here - https://trac.osgeo.org/osgeo/ticket/2243
> 
> I don't expect there to be more than 1 hr downtime during the process.
> 
> I will send out another notice just before I start the upgrade.
> 
> Email me if this poses a problem for you.
> 
> Thanks,
> Regina

___
Discuss mailing list
Discuss@lists.osgeo.org
https://lists.osgeo.org/mailman/listinfo/discuss

[OSGeo-Discuss] OSGeo 7 host updates

[Regina Obe]

I'm going to be installing some updates on OSGeo 7 server and will require a
reboot of the host.

I don't expect more than 30 minutes - 1 hr downtime.
I'll notify once things are back to normal.

Services that will be impacted are listed on this page:
https://wiki.osgeo.org/wiki/SAC_Service_Status#osgeo_7

Given that wiki will be affected, I will repeat the most critical ones
ldap.osgeo.org  (which pretty much affects everything)
osgeo.org, www.osgeo.org
download.osgeo.org, bottles.download.osgeo.org
trac.osgeo.org, git.osgeo.org, wiki.osgeo.org 

Thanks,
Regina





___
Discuss mailing list
Discuss@lists.osgeo.org
https://lists.osgeo.org/mailman/listinfo/discuss

Re: [OSGeo-Discuss] OSGeo 7 host updates

[Regina Obe]

Updates complete.  All systems should be back to normal.
Please reply back to this or reopen https://trac.osgeo.org/osgeo/ticket/2424

If you see any issues.

> -Original Message-
> From: Regina Obe [mailto:l...@pcorp.us]
> Sent: Friday, March 20, 2020 10:00 PM
> To: 'proje...@lists.osgeo.org' ; 'OSGeo
Discussions'
> 
> Cc: 'System Administration Committee Discussion/OSGeo'
> 
> Subject: OSGeo 7 host updates
> 
> I'm going to be installing some updates on OSGeo 7 server and will require
a
> reboot of the host.
> 
> I don't expect more than 30 minutes - 1 hr downtime.
> I'll notify once things are back to normal.
> 
> Services that will be impacted are listed on this page:
> https://wiki.osgeo.org/wiki/SAC_Service_Status#osgeo_7
> 
> Given that wiki will be affected, I will repeat the most critical ones
> ldap.osgeo.org  (which pretty much affects everything) osgeo.org,
> www.osgeo.org download.osgeo.org, bottles.download.osgeo.org
> trac.osgeo.org, git.osgeo.org, wiki.osgeo.org
> 
> Thanks,
> Regina
> 
> 
> 


___
Discuss mailing list
Discuss@lists.osgeo.org
https://lists.osgeo.org/mailman/listinfo/discuss

Re: [OSGeo-Discuss] [Projects] Status report for April - System Contract I 2020

[Regina Obe]

> Subject: Re: [OSGeo-Discuss] [Projects] Status report for April - System
> Contract I 2020
> 
> On Mon, May 04, 2020 at 09:56:21PM -0700, Jody Garnett wrote:
> 
> > > Grafana is running on OSGeo3 monitor container ->
> > > https://monitor.osgeo.org
> >
> > Thanks, I eventually managed to start a dashboard so I could find
> > osgeo3 again quickly.
> 
> Can you check if Dashboards can be shared with other users ?
> Because I keep having NO dashboards in the "home" page for dashboards
> and only see some of them in the "manage" page, were every dashboard
> seems to be attached to exactly one of the hosts. I guess it must be
possible
> to have a single dashboard showing "health" of all OSGeo services instead
?
> 
> --strk;

I think every one that is logged in has access to view all the dashboards
and admins can edit them.  So it's just the navigation that is a bit screwy.
I usually just favorite the ones I like and then they show on my home page.

You want to volunteer to help me figure out the UI stuff.  I'm more focused
on making sure we are collecting the metrics we need and there are a ton
more we can be collecting that would probably be useful.

In the ldap config there is also a way to segregate people based on LDAP
group and then do a finer grain control of the dashboards viewed.

The Prometheus queries are all written in some special time series focused
language https://prometheus.io/docs/prometheus/latest/querying/examples/

I don't have time to learn all that so I've just been installing dashboards
from Grafana for Prometheus that look useful and that query the metrics we
are currently collecting. https://grafana.com/grafana/dashboards  We can
study some of the queries and merge together the ones we like into a single
dashboard I think will satisfy your need for an all-encompassing dashboard.
If you look under the hood of the json of the dashboards you'll see the data
sources specified (corresponding to each of the Prometheus servers) and the
job node etc.


Thanks,
Regina

___
Discuss mailing list
Discuss@lists.osgeo.org
https://lists.osgeo.org/mailman/listinfo/discuss

[OSGeo-Discuss] Wiki upgrade happening Friday

[Regina Obe]

I'm planning to do the old-wiki  ->  new wiki (Debian 10 latest Media Wiki
install and MariaDb)  this Friday.
Sometime late night US ET time.

Let me know if this poses a problem for you.

The domain once complete will still be https://wiki.osgeo.org

But I will take it down during the migration.

I don't expect more than 2 hrs downtime.  Hopefully only one hour.

Thanks,
Regina

___
Discuss mailing list
Discuss@lists.osgeo.org
https://lists.osgeo.org/mailman/listinfo/discuss

[OSGeo-Discuss] Status report for April - System Contract I 2020

[Regina Obe]

Below is list of things I've been involed with in April revolving around
core infrastructure

1) Rebuilding Wiki.  I built a new debian 10 container with latest
Wikimedia, PHP, apache installed  -- but still exploring the db and stuff to
create a script to chuck bad user accounts.
I also need to retest the data restore script I have setup and revisit some
plugins that did not come thru (no upgrade path for them).

https://wiki.new.osgeo.org  (this is running on OSGeo3)

I'm hoping to do the final migration sometime late May.

Once this is done we can setup a dev of this new version to do the LDAP
integration.  This we can contract out -- we have two proposals from outside
contractors for LDAP work.

The below services are new/updated ones that use OSGeo LDAP for
authentication

2) Server Monitoring -- To replace the old munin monitoring, I put in place
Prometheus / Grafana  (https://prometheus.io/docs/visualization/grafana/  )
(this is so I can address recent complaints about speed etc and know when a
container needs more resources)

https://prometheus.io/  - Prometheus is a monitoring tool with already a lot
of what they call "Exporters" available for it, most of the exporters are
written in Go. Some are specifically geared for specific applications and
seems like perhaps not much effort to write our own if needed.  Since Go is
statically compiled these work on old servers as well and can be installed
by just copying the binaries and setting up the service script.

Exporters run as services on each Container / VM.  I haven't installed any
of these on osgeo6 or osgeo5, but have many installed on the new LXD
containers
Exporter service scripts I have committed to this repo -
https://git.osgeo.org/gitea/sac/prometheus-config  (and have collected the
node exporter (for OS monitoring) and nginx exporter (for nginx monitoring)

The nginx monitoring is installed on all the nginx proxies (OSGeo7, OSGeo3,
OSGeo4) and download container

There are 3 prometheus servers  (I have 3 instead of 1 to ease network
management since the Prometheus servers are all on the same private network
of the containers they pull metrics from they don't need any additional
whitelisting)
OSGeo7 - nginx (collects all the metrics from the OSGeo7 container
exporters)
OSGeo3 -  monitor (also runs Grafana and collects all metrics from OSGeo3
containers)
OSGeo4 - osgeo4-nginx (collects metrics from OSGeo4 containers)

Grafana is running on OSGeo3 monitor container -> https://monitor.osgeo.org
(all OSGeo LDAP users can log in to see the metrics).
I whitelisted it on OSGeo7 and OSGeo4 so it can query the Prometheus servers
for monitor stats.


3) https://repo.osgeo.org -- Jody Garnett spear-headed this effort.  The
Repo service is running Nexus repository management.
Feel free to login and check it out and if you want to use it in some way
for your projects -- Please put in a trac ticket -
https://trac.osgeo.org/osgeo/ 
Nexus supports the following kinds of repos - Maven, Docker Registry, Apt,
Yum, Nuget, R CPAN, RubyGems, npm (and some other stuff I've never heard of)

At the moment the following projects are using it (GeoTools, GeoServer,
GeoNetwork -- for their maven repo), (PostGIS / GEOS to manage docker
containers we use for drone bot regression testing)

4) https://matrix.osgeo.org -- container running Matrix (synapse server
https://matrix.org/docs/guides/installing-synapse )  bridges with our
existing IRC channels and can be used for private chat rooms like GSoc ones
for example
Requires an OSGeo LDAP account to use.  Talk to Sandro Santilli if you have
questions about how to use it.

5) nextcloud.osgeo.org - upgraded to 18.03  (Hub) (from 15)
https://nextcloud.com/hub/ .  There was some discussion about coediting
documents being slow from I think QGIS group.  Our version is running
Collabora for (Libre Office / MS Office online document editing)
  I am debating if we should switch to the Community server version which
uses  OnlyOffice for document editing / collaboration (which I have
installed on experimental https://nextcloud.gallery.osgeo.org )
Waiting for feedback from QGIS PSC group to see if it's worthwhile to
switch. From a cursory play with both, the OnlyOffice seems faster (but I
have no one to collaborate with to test the group editing features). 
As far as editing goes
Collabora seems to be better for LibreOffice , I had issues trying to
upgrade it though in that the PDF export no longer worked so had to revert
back.
OnlyOffice seems to be better for Microsoft documents (Word, Excel,
Powerpoint)  (it screwed up one of my libre .odt docs, and also doesn't have
ability to view LibreOffice drawings from what I can tell)

Thanks,
Regina




___
Discuss mailing list
Discuss@lists.osgeo.org
https://lists.osgeo.org/mailman/listinfo/discuss

[OSGeo-Discuss] PostGIS 3.0.2, 2.5.5, and 2.4.9 released

[Regina Obe]

The PostGIS development team is pleased to provide
bug fix and performance enhancements
 3.0.2, 2.5.5, 2.4.9 for the 3.0, 2.5, and 2.4 stable branches.

Details at -  https://postgis.net/2020/08/15/postgis-patches/

PostGIS 3.0.2
Source:  https://download.osgeo.org/postgis/source/postgis-3.0.2.tar.gz
News:  https://git.osgeo.org/gitea/postgis/postgis/raw/tag/3.0.2/NEWS
Docs PDF:  https://download.osgeo.org/postgis/docs/postgis-3.0.2.pdf
Docs HTML: https://download.osgeo.org/postgis/docs/doc-html-3.0.2.tar.gz

PostGIS 2.5.5

Source:  https://download.osgeo.org/postgis/source/postgis-2.5.5.tar.gz
News:  https://git.osgeo.org/gitea/postgis/postgis/raw/tag/2.5.5/NEWS
Docs PDF:  https://download.osgeo.org/postgis/docs/postgis-2.5.5.pdf
Docs HTML: https://download.osgeo.org/postgis/docs/doc-html-2.5.5.tar.gz

PostGIS 2.4.9

Source:  https://download.osgeo.org/postgis/source/postgis-2.4.9.tar.gz
News:  https://git.osgeo.org/gitea/postgis/postgis/raw/tag/2.4.9/NEWS
Docs PDF:  https://download.osgeo.org/postgis/docs/postgis-2.4.9.pdf
Docs HTML: https://download.osgeo.org/postgis/docs/doc-html-2.4.9.tar.gz


Thanks,
PostGIS Development Team


___
Discuss mailing list
Discuss@lists.osgeo.org
https://lists.osgeo.org/mailman/listinfo/discuss

[OSGeo-Discuss] PostGIS 2.3.11 released - last release for 2.3 - EOL

[Regina Obe]

The PostGIS Team is pleased to release PostGIS 2.3.11. This is the last bug
fix release of the PostGIS 2.3 series. 
https://postgis.net/2020/05/31/postgis-2.3.11/

source - https://download.osgeo.org/postgis/source/postgis-2.3.11.tar.gz
PDF docs (en) - https://download.osgeo.org/postgis/docs/postgis-2.3.11.pdf

Please upgrade to 2.4 or higher if you want to continue receiving bug fixes.

If you come across any issues, feel free to report via our ticket tracker 
https://trac.osgeo.org/postgis  or mailing list with details as described
here. For security issues, send reports to secur...@postgis.net.

Bug Fixes and Enchantments

4475, Avoid reading into empty ptarray (Paul Ramsey)
4518, Fix geometry_columns and raster views to not use pg_constraints.consrc
which was removed in PG 12 (Regina Obe)
4492, Fix ST_Simplify ignoring the value of the 3rd parameter (Raúl Marín)
4494, Fix ST_Simplify output having an outdated bbox (Raúl Marín)
4493, Fix ST_RemoveRepeatedPoints output having an outdated bbox (Raúl
Marín)
4495, Fix ST_SnapToGrid output having an outdated bbox (Raúl Marín)
4498, Restrict build for PgSQL <= 9.6
4519, Fix getSRIDbySRS crash (Raúl Marín)
4534, Fix leak in lwcurvepoly_from_wkb_state (Raúl Marín)
4536, Fix leak in lwcollection_from_wkb_state (Raúl Marín)
4537, Fix leak in WKT collection parser (Raúl Marín)
4547, Fix AddRasterConstraints handling of empty tables (Sandro Santilli)
4549, Fix schema qualification of internal types (Raúl Marín)
4546, Fix PLPGSQL functions missing the schema qualification (Raúl Marín)
4621, Prevent stack overflow when parsing WKB (Raúl Marín)
4652, Fix several memory related bugs in ST_GeomFromGML (Raúl Marín)

Thanks,
PostGIS Development Team

___
Discuss mailing list
Discuss@lists.osgeo.org
https://lists.osgeo.org/mailman/listinfo/discuss

[OSGeo-Discuss] wiki move starting now

[Regina Obe]

I'm going to start the migration now.  After it's done wiki.osgeo.org will
be back on osgeo3 host.  

The name of the new container will be: wiki

I will then shut down old-wiki on osgeo7.

I'll send another email once the migration is complete.

Thanks,
Regina

___
Discuss mailing list
Discuss@lists.osgeo.org
https://lists.osgeo.org/mailman/listinfo/discuss

[OSGeo-Discuss] Wiki migration completed

[Regina Obe]

It might take a bit for DNS to propage.

If you see a message about the server under maintenance, then your DNS has
not changed yet.

Please report if you see any issues on our ticket system

https://trac.osgeo.org/osgeo/



___
Discuss mailing list
Discuss@lists.osgeo.org
https://lists.osgeo.org/mailman/listinfo/discuss

[OSGeo-Discuss] PostGIS 3.1.0alpha2 is released

[Regina Obe]

The PostGIS Team is pleased to release the second alpha of upcoming PostGIS
3.1.0 release.

Best served with

PostgreSQL 13beta2, GEOS 3.7 or higher is recommended.

ST_MaximumInscribedCircle requires compilation with GEOS 3.9.0 (currently
in development) to be enabled.

pgRouting 3.1.0 which will be released soon.


PostGIS 3.1.0alpha2 links

SOURCE: https://download.osgeo.org/postgis/source/postgis-3.1.0alpha2.tar.gz
NEWS: https://git.osgeo.org/gitea/postgis/postgis/raw/tag/3.1.0alpha2/NEWS
PDF: https://download.osgeo.org/postgis/docs/postgis-3.1.0alpha2.pdf (EN)
https://download.osgeo.org/postgis/docs/postgis-3.1.0alpha2-de.pdf
(DE)

Happy Testing,
PostGIS Development Team



___
Discuss mailing list
Discuss@lists.osgeo.org
https://lists.osgeo.org/mailman/listinfo/discuss

[OSGeo-Discuss] OSGeo SAC Meeting highlights

[Regina Obe]

We had a meeting today - sadly only wildintellect, robe, and jef
contributed, but I feel we got a lot accomplished.

Discussions were

1. How to deal with OSGeo4W and other (Windows / Mac build ) needs -- I
think more research needs to be done here.
I started a page as to my understanding of needs and what research needs to
be done to push forward.

Feel free to add to this page
https://wiki.osgeo.org/wiki/SAC_Shared_Building_Services

2. How to convert wiki authentication to use our LDAP so it's like the other
services we offer?
Now that wiki has been migrated to latest version and Latest Debian OS - we
are ready to start work on this.

I sent a note to the most promising contractor proposal we received and he
said he can do it.  I'll let you know once we find out more details about
this.

So the general plan is as follows:
1. Do some trial tests in dev environment I setup (that is a backup of
production wiki and secure (our ldap) )
2. Then push changes to production once we are comfortable we have the work
flow right

Workflow:

Users log in with their current wiki user and then log in again with their
LDAP credentials.  
Information about their LDAP user would be added to their wiki account and,
in the future, they could use their LDAP credentials to log into their wiki
user account.
We ideally will not allow any new wiki accounts to be created (outside of
LDAP).
Eventually after some grace period we would then retire the original wiki
login method in favor of LDAP.


Thanks,
Regina

___
Discuss mailing list
Discuss@lists.osgeo.org
https://lists.osgeo.org/mailman/listinfo/discuss

[OSGeo-Discuss] PostGIS 3.0.3 is released

[Regina Obe]

The PostGIS development team is pleased to release PostGIS 3.0.3.

This is a bug fix only release.

Details here - 

https://postgis.net/2020/11/20/postgis-3.0.3/

Source: https://download.osgeo.org/postgis/source/postgis-3.0.3.tar.gz
NEWS: https://git.osgeo.org/gitea/postgis/postgis/raw/tag/3.0.3/NEWS
Docs: https://download.osgeo.org/postgis/docs/postgis-3.0.3.pdf
https://download.osgeo.org/postgis/docs/doc-html-3.0.3.tar.gz


Thanks,
PostGIS Development Team

___
Discuss mailing list
Discuss@lists.osgeo.org
https://lists.osgeo.org/mailman/listinfo/discuss

[OSGeo-Discuss] FW: [postgis-users] Virtual PostGIS Day event

[Regina Obe]

 

 

From: postgis-users [mailto:postgis-users-boun...@lists.osgeo.org] On Behalf Of 
Martin Davis
Sent: Friday, November 13, 2020 12:43 PM
To: PostGIS Users Discussion 
Subject: [postgis-users] Virtual PostGIS Day event

 

Crunchy Data is hosting a virtual PostGIS Day event, with a series of 
presentations about using PostGIS.   
 Register 
here:

 

https://info.crunchydata.com/en/postgis-day-2020-crunchy-data

___
postgis-users mailing list
postgis-us...@lists.osgeo.org
https://lists.osgeo.org/mailman/listinfo/postgis-users___
Discuss mailing list
Discuss@lists.osgeo.org
https://lists.osgeo.org/mailman/listinfo/discuss

[OSGeo-Discuss] PostGIS 3.1.0alpha3 is released

[Regina Obe]

PostGIS development team is happy to release PostGIS 3.1.0alpha3 as part of
the celebration of this Post GIS day.

Details at:

http://postgis.net/2020/11/19/postgis-3.1.0alpha3/

source: https://download.osgeo.org/postgis/source/postgis-3.1.0alpha3.tar.gz
news: https://git.osgeo.org/gitea/postgis/postgis/raw/tag/3.1.0alpha3/NEWS
docs: https://download.osgeo.org/postgis/docs/postgis-3.1.0alpha3.pdf
https://download.osgeo.org/postgis/docs/doc-html-3.1.0alpha3.tar.gz
https://download.osgeo.org/postgis/docs/postgis-3.1.0alpha3.epub

Thanks,
PostGIS Development Team

___
Discuss mailing list
Discuss@lists.osgeo.org
https://lists.osgeo.org/mailman/listinfo/discuss

[OSGeo-Discuss] OSGeo7 will be going down shortly for routine updates

[Regina Obe]

Note anything on OSGeo7 will be down for a brief period while OSGeo reboots.

I will notify once the updates are complete.

https://wiki.osgeo.org/wiki/SAC_Service_Status#osgeo_7

Thanks,
Regina

___
Discuss mailing list
Discuss@lists.osgeo.org
https://lists.osgeo.org/mailman/listinfo/discuss

Re: [OSGeo-Discuss] OSGeo7 will be going down shortly for routine updates

[Regina Obe]

> -Original Message-
> From: Regina Obe [mailto:l...@pcorp.us]
> Sent: Friday, January 1, 2021 5:58 PM
> To: 'proje...@lists.osgeo.org' ;
> 'discuss@lists.osgeo.org' 
> Subject: OSGeo7 will be going down shortly for routine updates
> 
> Note anything on OSGeo7 will be down for a brief period while OSGeo
> reboots.
> 
> I will notify once the updates are complete.
> 
> https://wiki.osgeo.org/wiki/SAC_Service_Status#osgeo_7
> 
> Thanks,
> Regina

OSGEO7 is back up.  I will be doing patch updates on wordpress and wiki
servers so the osgeo.org and wiki site maybe be off for a couple of minutes
while I do that.

Thanks,
Regina

___
Discuss mailing list
Discuss@lists.osgeo.org
https://lists.osgeo.org/mailman/listinfo/discuss

[OSGeo-Discuss] Wiki edit rights issue

[Regina Obe]

After the change in Wiki to change to LDAP authentication, a number of
people are having issues editing pages.

This is because they are not being removed from certain groups that
designated for users in process of merging.
We are working on fixing that moving forward.  In the meantime, those with
this issue can do one of the following:

Just put a note on this ticket with your name -
https://trac.osgeo.org/osgeo/ticket/2599

Alternatively if you have a wiki admin/bureaucrat readily handy who has
already been successfully merged, you can ask them to fix your account.

To Administrators/Bureaucrats (thanks to all who have already stepped in)
-

There are generally two causes.  I'm going to tell you how to fix the more
general and easier to fix case.

Go to user rights page - https://wiki.osgeo.org/wiki/Special:UserRights  and
look up the person in question:

If you see the following groups checked on their account, uncheck them and
save:

-
wiki account
 account in progress of converting
-

Then save and that should fix the issue.

The harder to fix problem are when people are under two or more equivalent
names but different in casing or _

Case in point was Astrid emde  vs. Astrid_emde vs astrid_emde

Those ones the account may look okay but I have to go into the back to see
it's duplicated.  Just put those on the ticket and I'll fix.

We're hoping to have the issue resolved in next week and then we'll fix all
the accounts that are broken.  If we can't I'll put similar messages like
this on the wiki login page.


Thanks,
OSGeo Sys Admin group

___
Discuss mailing list
Discuss@lists.osgeo.org
https://lists.osgeo.org/mailman/listinfo/discuss

[OSGeo-Discuss] Maintenance on OSGeo7

[Regina Obe]

I need to take OSGoe7 down to complete some maintenance tasks.

I don't expect it to be down for longer than an hour.

Services affected are listed here:

https://wiki.osgeo.org/wiki/SAC_Service_Status#osgeo_7

I'll send a note after I am done.

Thanks,
Regina

___
Discuss mailing list
Discuss@lists.osgeo.org
https://lists.osgeo.org/mailman/listinfo/discuss

Re: [OSGeo-Discuss] Maintenance on OSGeo7

[Regina Obe]

> I need to take OSGoe7 down to complete some maintenance tasks.
> 
> I don't expect it to be down for longer than an hour.
> 
> Services affected are listed here:
> 
> https://wiki.osgeo.org/wiki/SAC_Service_Status#osgeo_7
> 
> I'll send a note after I am done.
> 
> Thanks,
> Regina
[Regina Obe] 
Done and backup.  I am doing some other patching of containers so things
will be up and down for next hour or so.

Thanks,
Regina

___
Discuss mailing list
Discuss@lists.osgeo.org
https://lists.osgeo.org/mailman/listinfo/discuss

[OSGeo-Discuss] WIKI migrating to LDAP upcoming Friday

[Regina Obe]

After 13 years of planning we are finally upgrading wiki.osgeo.org  to
authenticate with LDAP and ONLY use LDAP thenceforward for authentication as
detailed in below ticket.

https://trac.osgeo.org/osgeo/ticket/165

The move will happen this coming Friday, at which point, when you log in:

1) You will be informed your wiki account will be migrated, and led thru the
steps of migrating your wiki account to LDAP.

2) After the migration, you will then only use your LDAP account for your
wiki editing and all your previous history will be moved to your LDAP
account.
3) Future Wiki login will require the user to have an LDAP account, so no
wiki approval of accounts will happen thenceforward. The Request Account
link at the top sends the user to our LDAP create account page.

I have done a trial run of the migration at the below:

https://staging.wiki.osgeo.org

Please try the above and let me know if you run into any issues.  You can
report said issues on the trac ticket:

https://trac.osgeo.org/osgeo/ticket/165

If no issues reported before the final planned migration this Friday, we
will proceed as planned.

If you have questions -- feel free to reply to this email.

Thanks,
Regina and SAC Admin Team



___
Discuss mailing list
Discuss@lists.osgeo.org
https://lists.osgeo.org/mailman/listinfo/discuss

[OSGeo-Discuss] wiki.osgeo.org migration to LDAP Auth is complete

[Regina Obe]

Next time you log into https://wiki.osgeo.org you should be prompted to
merge your account with your LDAP one.

Once completed you will use your LDAP account to log in from then forward.

Feel free to report any issues on trac.

Thanks,
Regina and OSGeo SAC Team

___
Discuss mailing list
Discuss@lists.osgeo.org
https://lists.osgeo.org/mailman/listinfo/discuss

Re: [OSGeo-Discuss] OSGeo6 will have a dist upgrade today -- COMPLETED

[Regina Obe via Discuss]

> > OSGeo6 will have a dist upgrade today
> >
> > I plan to upgrade OSGeo6 from Jessie to Stretch later tonight.
> > While this is happening, there may be periods of outage with mailing
> > lists and osgeo mail.
> I'm going to be starting the process now.  I expect there to be ups and
downs
> during the process.
> Feel free to email me directly as mail list may be down.
> 
> Thanks,
> Regina
[Regina Obe] 
OSGeo6 has been upgraded and is now back up.
If you had anything running on it and you see issues, please put in a ticket
on trac.

Thanks,
Regina


___
Discuss mailing list
Discuss@lists.osgeo.org
https://lists.osgeo.org/mailman/listinfo/discuss

[OSGeo-Discuss] OSGeo6 will have a dist upgrade today

[Regina Obe via Discuss]

I plan to upgrade OSGeo6 from Jessie to Stretch later tonight.
While this is happening, there may be periods of outage with mailing lists
and osgeo mail.

I'll send a note just before I start the process and after I am done.

That said, since OSGeo6 holds our mailing lists and is our mail server, I
will not be able to email with any issues during the process.

Any such issues will be announced in OSGeo and OSGeo SAC  irc libera
channels (matrix bridges). 
I will also announce completion in these channels in addition to the mailing
lists

Thanks,
Regina
SAC Team member

___
Discuss mailing list
Discuss@lists.osgeo.org
https://lists.osgeo.org/mailman/listinfo/discuss

Re: [OSGeo-Discuss] OSGeo6 will have a dist upgrade today

[Regina Obe via Discuss]

> OSGeo6 will have a dist upgrade today
> 
> I plan to upgrade OSGeo6 from Jessie to Stretch later tonight.
> While this is happening, there may be periods of outage with mailing lists
and
> osgeo mail.
> 
> I'll send a note just before I start the process and after I am done.
> 
> That said, since OSGeo6 holds our mailing lists and is our mail server, I
will not
> be able to email with any issues during the process.
> 
> Any such issues will be announced in OSGeo and OSGeo SAC  irc libera
channels
> (matrix bridges).
> I will also announce completion in these channels in addition to the
mailing lists
> 
> Thanks,
> Regina
> SAC Team member
[Regina Obe] 

I'm going to be starting the process now.  I expect there to be ups and
downs during the process.
Feel free to email me directly as mail list may be down.

Thanks,
Regina


___
Discuss mailing list
Discuss@lists.osgeo.org
https://lists.osgeo.org/mailman/listinfo/discuss

[OSGeo-Discuss] Wiki Update

[Regina Obe via Discuss]

We've put in a patch which will hopefully solve the issue of wiki to LDAP
migrated users not having rights to edit pages.
If you still continue to have issues after, please post to the below ticket

https://trac.osgeo.org/osgeo/ticket/2599

I'll keep the ticket open for another 2 weeks to see if anyone else still
continues to have issues.

Thanks,
Regina

___
Discuss mailing list
Discuss@lists.osgeo.org
https://lists.osgeo.org/mailman/listinfo/discuss

[OSGeo-Discuss] Heads up about an LDAP issue we are having

[Regina Obe via Discuss]

An intermediary certificate for LetsEncrypt expired today.

https://letsencrypt.org/docs/dst-root-ca-x3-expiration-september-2021/

This has caused validation issues with older systems that are not verifying
the new way.  One of these is sadly our beloved trac.osgeo.org

So if you try to log into trac.osgeo.org you will get a server error.

I'm still in the middle of troubleshooting and trying to fix.

Thanks for your patience,
Regina

___
Discuss mailing list
Discuss@lists.osgeo.org
https://lists.osgeo.org/mailman/listinfo/discuss

[OSGeo-Discuss] PostGIS 3.2.0, The Olivier Courtin Release

[Regina Obe via Discuss]

The PostGIS Team is pleased to release PostGIS 3.2.0, the Olivier Courtin
release.
This release is dedicated to Olivier Courtin, a long time PostGIS developer
who passed on in March 2020.
More details about him here:
https://postgis.net/2021/12/17/olivier-courtin/

Details of this release at:  https://postgis.net/2021/12/18/postgis-3.2.0/

Source: https://download.osgeo.org/postgis/source/postgis-3.2.0.tar.gz
News: https://git.osgeo.org/gitea/postgis/postgis/raw/tag/3.2.0/NEWS
Docs: https://download.osgeo.org/postgis/docs/postgis-3.2.0.pdf

This release would not be possible without the various developers listed in
the NEWS as well as the companies that provided funding and developer time.

Companies that contributed significantly to this release are:

* CrunchyData https://www.crunchydata.com Geometry processing functions (and
improvements to GEOS), new raster functions, and address_standardizer pcre2
support
* Kontur https://www.kontur.io Speed improvements to raster, MVT, GiST
indexing, better usability of geometry processing, and new radius clustering
mode.
* Netlab https://strk.kbt.io/services.html Continuous improvement of PostGIS
topology, PostGIS upgrade plumbing,  PostGIS test plumbing, and CI bot
management
* NIBIO https://nibio.no  Developer funding for topology improvements
* Paragon Corporation https://www.paragoncorporation.com General CI bot
management, release management, alignment of PostGIS with PostgreSQL
versions

Please report issues on the PostGIS users/developer mailing lists or on our
ticket tracker as instructed here - https://postgis.net/support/

Thanks All,
PostGIS Development Team


___
Discuss mailing list
Discuss@lists.osgeo.org
https://lists.osgeo.org/mailman/listinfo/discuss

[OSGeo-Discuss] Heads up OSGeo7 restart and upgrade later today

[Regina Obe via Discuss]

I will be restarting OSGEO7 in about an hour  (it's been needing a reboot
for a while) and I will also be doing a dist upgrade.
There will be a lot of up and down while I do that.  I'm hoping to be
finished in a 1-2 hr time frame.
  
Feel free to respond to this email if you have issues with this.

Impacted services are listed on:

https://wiki.osgeo.org/wiki/SAC_Service_Status#osgeo_7


On a side note - we had an interruption today with many of our domains being
unreachable.
It was an issue with our DNS provider Pair Domains with their NS servers.  
I think they are still working on the issue, but things seem more or less
back to normal for us.

Thanks,
Regina
SAC Team


___
Discuss mailing list
Discuss@lists.osgeo.org
https://lists.osgeo.org/mailman/listinfo/discuss

[OSGeo-Discuss] OSGeo 7 upgrade starting in a bit

[Regina Obe via Discuss]

Sorry for the delay.  I have not started the OSGeo7 upgrade first.

My OpenVPN wasn't able to connect to the console, but I have that issue
squared away now with OSUOSL staff help.

That said I'm going to start the upgrade process now and expect things to go
up and down.  Hopefully for no longer than an hour.


Thanks,
Regina

___
Discuss mailing list
Discuss@lists.osgeo.org
https://lists.osgeo.org/mailman/listinfo/discuss

Re: [OSGeo-Discuss] OSGeo 7 upgrade starting in a bit

[Regina Obe via Discuss]

Upgrade of osgeo7 is complete. If you have things there, please check them
out to make sure all is in order.

https://wiki.osgeo.org/wiki/SAC_Service_Status#osgeo_7

Thanks,
Regina

___
Discuss mailing list
Discuss@lists.osgeo.org
https://lists.osgeo.org/mailman/listinfo/discuss

Re: [OSGeo-Discuss] OSGeo7 will be rebooted today

[Regina Obe via Discuss]

I'm going to start the reboot in a couple of minutes and will send a note
when all things are back up.

Thanks,
Regina

> -Original Message-
> From: Regina Obe [mailto:l...@pcorp.us]
> Sent: Friday, March 18, 2022 12:12 PM
> To: 'OSGeo Discussions' ;
'proje...@lists.osgeo.org'
> 
> Cc: 'System Administration Committee Discussion/OSGeo'
> 
> Subject: OSGeo7 will be rebooted today
> 
> I plan to do a reboot of OSGeo7 later today.  In next 12-13 hrs.
> I expect all services to start up in 15-30 minutes after.
> 
> I'll send out another note before I do and update after
> 
> If after update you see any issues feel free to post them to this ticket
> 
> https://trac.osgeo.org/osgeo/ticket/2741
> 
> 
> You can also write to me if you have issues.
> 
> Affected services are listed on this page.
> 
> https://wiki.osgeo.org/wiki/SAC_Service_Status#Services_on_osgeo7
> 
> 
> Note that LDAP is on osgeo7 too so may impact login of other services.
> 
> Thanks,
> Regina
> SAC Administrator
> 


___
Discuss mailing list
Discuss@lists.osgeo.org
https://lists.osgeo.org/mailman/listinfo/discuss

Re: [OSGeo-Discuss] OSGeo7 will be rebooted today

[Regina Obe via Discuss]

All services on osgeo7 should be back up.

Let me know if you see any issues.

> -Original Message-
> From: Regina Obe [mailto:l...@pcorp.us]
> Sent: Saturday, March 19, 2022 12:09 AM
> To: 'OSGeo Discussions' ;
'proje...@lists.osgeo.org'
> 
> Cc: 'System Administration Committee Discussion/OSGeo'
> 
> Subject: RE: OSGeo7 will be rebooted today
> 
> I'm going to start the reboot in a couple of minutes and will send a note
> when all things are back up.
> 
> Thanks,
> Regina
> 
> > -Original Message-
> > From: Regina Obe [mailto:l...@pcorp.us]
> > Sent: Friday, March 18, 2022 12:12 PM
> > To: 'OSGeo Discussions' ;
> 'proje...@lists.osgeo.org'
> > 
> > Cc: 'System Administration Committee Discussion/OSGeo'
> > 
> > Subject: OSGeo7 will be rebooted today
> >
> > I plan to do a reboot of OSGeo7 later today.  In next 12-13 hrs.
> > I expect all services to start up in 15-30 minutes after.
> >
> > I'll send out another note before I do and update after
> >
> > If after update you see any issues feel free to post them to this ticket
> >
> > https://trac.osgeo.org/osgeo/ticket/2741
> >
> >
> > You can also write to me if you have issues.
> >
> > Affected services are listed on this page.
> >
> > https://wiki.osgeo.org/wiki/SAC_Service_Status#Services_on_osgeo7
> >
> >
> > Note that LDAP is on osgeo7 too so may impact login of other services.
> >
> > Thanks,
> > Regina
> > SAC Administrator
> >


___
Discuss mailing list
Discuss@lists.osgeo.org
https://lists.osgeo.org/mailman/listinfo/discuss

Re: [OSGeo-Discuss] [Projects] [GSoC 2022 - Call for Project Ideas] PostGIS Ideas

[Regina Obe via Discuss]

Below is the PostGIS GSOC 2022 ideas page

https://trac.osgeo.org/postgis/wiki/GoogleSummerCode2022

Thanks,
Regina

___
Discuss mailing list
Discuss@lists.osgeo.org
https://lists.osgeo.org/mailman/listinfo/discuss

[OSGeo-Discuss] If you are using download.osgeo.org for sftping use upload.osgeo.org

[Regina Obe via Discuss]

This is a note for those folks who upload content to download.osgeo.org

>From now on please use upload.osgeo.org

For osgeo7 to hop across servers -- use  hop.osgeo7.osgeo.org

We are going to be distributing the load on download.osgeo.org across
servers, so if you are using download.osgeo.org you may not be hitting the
source server.

Thanks,
Regina
SAC Administrator

___
Discuss mailing list
Discuss@lists.osgeo.org
https://lists.osgeo.org/mailman/listinfo/discuss

[OSGeo-Discuss] Help us test out Weblate

[Regina Obe via Discuss]

We have Weblate installed on OSGeo infra

At 

https://weblate.osgeo.org
For a trial run I'm using our PostGIS workshop

You can login with your LDAP credentials and then I can grant you rights to
the postgis-workshop project.


If I set this up right - commits should show up after an hour or so after
each commit on the below links.

English: https://postgis.net/workshops/en/postgis-intro/
Japanese:  https://postgis.net/workshops/ja/postgis-intro/
German: https://postgis.net/workshops/de/postgis-intro/
Spanish: https://postgis.net/workshops/es/postgis-intro/
Italian: https://postgis.net/workshops/it/postgis-intro/


And you should see your commit show here:
https://github.com/postgis/postgis-workshops

here is an example Sandro did -
https://github.com/postgis/postgis-workshops/commit/f3b1f810a9c25d2889c2216b
62d4843a44544858

My plan is after we are done with some kicking of tires, we will switch
PostGIS docs from transifex to weblate.

For others who want to try it on their projects, let me know I can show you
what little I know about the topic :)

Thanks,
Regina



___
Discuss mailing list
Discuss@lists.osgeo.org
https://lists.osgeo.org/mailman/listinfo/discuss

[OSGeo-Discuss] Rebooting OSGeo7

[Regina Obe via Discuss]

I will be rebooting OSGeo7 in a couple of minutes.

I'll send another note when it's back up.

Services impacted are listed here:

https://wiki.osgeo.org/wiki/SAC_Service_Status#osgeo_7

Thanks,
Regina
SAC Team

___
Discuss mailing list
Discuss@lists.osgeo.org
https://lists.osgeo.org/mailman/listinfo/discuss

Re: [OSGeo-Discuss] Rebooting OSGeo7

[Regina Obe via Discuss]

Osgeo7 is back up.

> -Original Message-
> From: Regina Obe [mailto:l...@pcorp.us]
> Sent: Monday, January 24, 2022 6:27 PM
> To: 'System Administration Committee Discussion/OSGeo'
> 
> Cc: 'proje...@lists.osgeo.org' ;
> 'discuss@lists.osgeo.org' 
> Subject: Rebooting OSGeo7
> 
> I will be rebooting OSGeo7 in a couple of minutes.
> 
> I'll send another note when it's back up.
> 
> Services impacted are listed here:
> 
> https://wiki.osgeo.org/wiki/SAC_Service_Status#osgeo_7
> 
> Thanks,
> Regina
> SAC Team

___
Discuss mailing list
Discuss@lists.osgeo.org
https://lists.osgeo.org/mailman/listinfo/discuss

[OSGeo-Discuss] OSGeo7 going down

[Regina Obe via Discuss]

I'm going to reboot OSGeo7 shortly and will send a notice when it's backup.

Affected services are listed here: 

https://wiki.osgeo.org/wiki/SAC_Service_Status#Services_on_osgeo7



___
Discuss mailing list
Discuss@lists.osgeo.org
https://lists.osgeo.org/mailman/listinfo/discuss

Re: [OSGeo-Discuss] OSGeo7 going back up

[Regina Obe via Discuss]

> I'm going to reboot OSGeo7 shortly and will send a notice when it's
backup.
> 
> Affected services are listed here:
> 
> https://wiki.osgeo.org/wiki/SAC_Service_Status#Services_on_osgeo7
> 

Osgeo7 I snow back up.  All services should be working again.

___
Discuss mailing list
Discuss@lists.osgeo.org
https://lists.osgeo.org/mailman/listinfo/discuss

[OSGeo-Discuss] PostGIS 3.4.0 released

[Regina Obe via Discuss]

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


___
Discuss mailing list
Discuss@lists.osgeo.org
https://lists.osgeo.org/mailman/listinfo/discuss

[OSGeo-Discuss] OSGeo7 will be rebooted today

[Regina Obe via Discuss]

I plan to do a reboot of OSGeo7 later today.  In next 12-13 hrs.
I expect all services to start up in 15-30 minutes after.

I'll send out another note before I do and update after

If after update you see any issues feel free to post them to this ticket

https://trac.osgeo.org/osgeo/ticket/2741


You can also write to me if you have issues.

Affected services are listed on this page.

https://wiki.osgeo.org/wiki/SAC_Service_Status#Services_on_osgeo7


Note that LDAP is on osgeo7 too so may impact login of other services.

Thanks,
Regina
SAC Administrator



___
Discuss mailing list
Discuss@lists.osgeo.org
https://lists.osgeo.org/mailman/listinfo/discuss

[OSGeo-Discuss] PostGIS 3.3.0beta1 released

[Regina Obe via Discuss]

The PostGIS Team is pleased to release PostGIS 3.3.0beta1
Best served with PostgreSQL 15 beta2 and GEOS 3.11.0.

Extra features enabled if you are running with PostgreSQL 15 and GEOS
3.11.0.

The new --enable-lto flag improves math computations.  This new feature is
disabled by default.

Use below to enable it.

 ./configure --enable-lto

Details here:  https://postgis.net/2022/07/03/postgis-3.3.0beta1/

Warm regards,
PostGIS Development Team

___
Discuss mailing list
Discuss@lists.osgeo.org
https://lists.osgeo.org/mailman/listinfo/discuss

[OSGeo-Discuss] PostGIS 3.3.0beta2 released

[Regina Obe via Discuss]

The PostGIS Team is pleased to release PostGIS 3.3.0beta2
Best served with PostgreSQL 15 beta2, GEOS 3.11.0, and SFCGAL 1.4.1.

Extra features enabled if you are running with PostgreSQL 15, GEOS
3.11.0, and SFCGAL 1.4.1.

The new --enable-lto flag improves speed of math computations.  
This new feature is disabled by default.

Use below to enable it.

 ./configure --enable-lto

Details here:  https://postgis.net/2022/07/13/postgis-3.3.0beta2/

Warm regards,
PostGIS Development Team

___
Discuss mailing list
Discuss@lists.osgeo.org
https://lists.osgeo.org/mailman/listinfo/discuss

[OSGeo-Discuss] OSGeo7 will be going down in about 24 hrs for standard maintenance

[Regina Obe via Discuss]

I will be rebooting osgeo7 in about 24 hrs.
During this downtime, the following services will be down.

https://wiki.osgeo.org/wiki/SAC_Service_Status#Services_on_osgeo7

Note that services that rely on ldap.osgeo.org will be impacted during this
maintenance window.
Expect people to not be able to log into these services even if they are not
on osgeo7.  Services not on osgeo7 that will be impacted (e.g. logging in to
OSGeo servers , weblate.osgeo.org, repo.osgeo.org, qgis plugin upload,
wiki.osgeo.org)

I don't expect more than 30 minutes of downtime.

I will send a note before I start the process and after the process is
complete.
Feel free to write me if you have issues with this.

Thanks,
Regina
OSGeo Sys Admin

___
Discuss mailing list
Discuss@lists.osgeo.org
https://lists.osgeo.org/mailman/listinfo/discuss

[OSGeo-Discuss] OSGeo6 upgrade

[Regina Obe via Discuss]

I'm starting the upgrade of osgeo6 from stretch to buster.

So there might be some disconnects here and there until I am completed.

I will send a note after I have completed the upgrade.

Thanks,
Regina

___
Discuss mailing list
Discuss@lists.osgeo.org
https://lists.osgeo.org/mailman/listinfo/discuss

Re: [OSGeo-Discuss] OSGeo6 upgrade

[Regina Obe via Discuss]

Upgrade of OSGeo6 is complete.

> -Original Message-
> From: Regina Obe [mailto:l...@pcorp.us]
> Sent: Friday, April 29, 2022 11:28 PM
> To: 'OSGeo Discussions' 
> Cc: 'proje...@lists.osgeo.org' 
> Subject: OSGeo6 upgrade
> 
> I'm starting the upgrade of osgeo6 from stretch to buster.
> 
> So there might be some disconnects here and there until I am completed.
> 
> I will send a note after I have completed the upgrade.
> 
> Thanks,
> Regina

___
Discuss mailing list
Discuss@lists.osgeo.org
https://lists.osgeo.org/mailman/listinfo/discuss