= PostGIS Tracker and Wiki =
{{{
#!html
}}}
[[Image(OSGeo_project.svg, width=140, right, link=http://www.osgeo.org/)]]
|| Build status || \
||= '''Debbie''' [[br]] ,,''Debian Buster/sid [[br]]GNU/Linux 64bit[[br]] gcc (Debian 8.2.0-3) 8.2.0[[br]] SFCGAL 1.3.7[[br]]Proj 7.0.1[[br]]Tests upgrades (3.0+)'',, =||\
||= '''Winnie''' [[br]] ,,''Windows[[br]]32bit (mingw64 gcc 4.8.1)[[br]] / 64bit (mingw64 gcc 4.8.3) [[br]] SFCGAL 1.3 head'',, =||\
||= '''Dronie''' [[br]] ,,''Trisquel[[br]]GNU/Linux 64bit[[br]]PG 9.3 to 10[[br]]GEOS 3.6.2[[br]]GDAL 2.2.3[[br]]Tests upgrades'',, =||\
||= '''Travis''' [[br]] ,,''Ubuntu 12.04[[br]]GNU/Linux 64bit gcc 4.8.4[[br]]PG 9.4 (= 2.2)[[br]]PG 9.5 (= 2.3)[[br]]PG 9.6(>=2.4)[[br]]GDAL 2.1.0[[br]]GEOS 3.6, 3.7 '',, =||\
||= '''Gitlab-CI''' [[br]] ,,''Debian[[br]]see badge titles[[br]]for details[[br]]Tests dump-restore'',, =||\
||= '''Bessie''' [[br]] ,,''FreeBSD 12.0 64-bit[[br]]clang version 6.0.1[[br]]PG 11 (>=2.3)[[br]]GDAL 2.4.1[[br]]GEOS 3.7.2[[br]]SFCGAL 1.3.6, Proj 6.1.0'',, =||\
||= '''Bessie32''' [[br]] ,,''FreeBSD 11.2 32-bit[[br]]clang version 4.0.0[[br]]PG 10.9 (>=2.3)[[br]]GDAL 2.4.1[[br]]GEOS 3.7.2[[br]]SFCGAL 1.3.6, Proj 6.1.0'',, =||\
||= '''Berrie''' [[br]] ,,''Rasberry Pi 32-bit (Debian Buster)[[br]]gcc 8.3.0[[br]]PG 13 (>=3.0)[[br]]GDAL 2.4.0[[br]]GEOS 3.7.1[[br]]Proj 5.2.0'',, =|| \
||= '''Berrie64''' [[br]] ,,''Rasberry Pi 64-bit (Debian Buster)[[br]]gcc 8.3.0[[br]]PG 13 (>=3.0)[[br]]GDAL 2.4.0[[br]]GEOS 3.7.1[[br]]Proj 5.2.0'',, =||
||= '''master''' =|| \
|| [[Image(https://debbie.postgis.net/buildStatus/icon?job=PostGIS_trunk, link=https://debbie.postgis.net/view/PostGIS/job/PostGIS_trunk/, alt=status, height="20", title='PG 9.5-12 (branch), GDAL 2.3 branch, GEOS trunk')]] || \
|| [[Image(https://winnie.postgis.net:444/buildStatus/icon?job=PostGIS_trunk, link=https://winnie.postgis.net:444/view/PostGIS/job/PostGIS_trunk/, alt=status, height="20", title='PG 9.5-11, GDAL 2.2.4, GEOS 3.7dev,32/64-bit')]] ||\
|| [[Image(https://dronie.osgeo.org/api/badges/postgis/postgis/status.svg?ref=refs/heads/master, link=https://dronie.osgeo.org/postgis/postgis?branch=master, alt=status)]] ||\
|| [[Image(https://secure.travis-ci.org/postgis/postgis.svg?branch=master, link=https://travis-ci.org/postgis/postgis?branch=master, alt=status, height="20")]] ||\
|| [[Image(https://gitlab.com/postgis/postgis/badges/master/pipeline.svg, link=https://gitlab.com/postgis/postgis/commits/master, alt=status, title='PG 11.1, GDAL 2.4.0, GEOS 3.7.1, PROJ 5.2.0')]] ||\
|| [[Image(https://debbie.postgis.net/buildStatus/icon?job=PostGIS_Worker_Run/label=bessie&build=last:${params.reference=refs/heads/master}, link=https://debbie.postgis.net/view/PostGIS/job/PostGIS_Worker_Run/label=bessie, alt=status, height="20", title='PG 10.1(branch), GDAL 2.1 branch, GEOS 3.6')]] ||\
|| [[Image(https://debbie.postgis.net/buildStatus/icon?job=PostGIS_Worker_Run/label=bessie32&build=last:${params.reference=refs/heads/master}, link=https://debbie.postgis.net/view/PostGIS/job/PostGIS_Worker_Run/label=bessie32, alt=status, height="20", title='PG 10.1(branch), GDAL 2.1 branch, GEOS 3.6')]] ||\
|| [[Image(https://debbie.postgis.net/buildStatus/icon?job=PostGIS_Worker_Run/label=berrie&build=last:${params.reference=refs/heads/master}, link=https://debbie.postgis.net/view/PostGIS/job/PostGIS_Worker_Run/label=berrie, alt=status, height="20", title='PG 12(branch), GDAL 2.4.0 branch, GEOS 3.7.1')]] ||\
|| [[Image(https://debbie.postgis.net/buildStatus/icon?job=PostGIS_Worker_Run/label=berrie&build=last:${params.reference=refs/heads/master}, link=https://debbie.postgis.net/view/PostGIS/job/PostGIS_Worker_Run/label=berrie64, alt=status, height="20", title='PG 12(branch), GDAL 2.4.0 branch, GEOS 3.7.1')]] ||
||= '''3.0''' =|| \
|| [[Image(https://debbie.postgis.net/buildStatus/icon?job=PostGIS_3.0, link=https://debbie.postgis.net/view/PostGIS/job/PostGIS_3.0/, alt=status, height="20", title='PG 9.3-12(branch), GDAL 2.3 branch, GEOS 2.4')]] || \
|| [[Image(https://winnie.postgis.net:444/buildStatus/icon?job=PostGIS_3.0, link=https://winnie.postgis.net:444/view/PostGIS/job/PostGIS_3.0/, alt=status, height="20", title='PG 9.5-11, GDAL 2.2.4, GEOS 3.7dev,32/64-bit')]] ||\
|| [[Image(https://dronie.osgeo.org/api/badges/postgis/postgis/status.svg?ref=refs/heads/stable-3.0, link=https://dronie.osgeo.org/postgis/postgis?branch=stable-3.0, alt=status)]] ||\
|| [[Image(https://secure.travis-ci.org/postgis/postgis.svg?branch=stable-3.0, link=https://travis-ci.org/postgis/postgis?branch=stable-3.0, alt=status, height="20")]] ||\
|| [[Image(https://gitlab.com/postgis/postgis/badges/stable-3.0/pipeline.svg, link=https://gitlab.com/postgis/postgis/commits/stable-3.0, alt=status, height="20", title='PG 9.6.10, GDAL 2.1.2, GEOS 3.5.1, PROJ 4.9.3')]] ||\
|| [[Image(https://debbie.postgis.net/buildStatus/icon?job=PostGIS_Worker_Run/label=bessie&build=last:${params.reference=refs/heads/stable-3.0}, link=https://debbie.postgis.net/view/PostGIS/job/PostGIS_Worker_Run/label=bessie, alt=status, height="20", title='PG 10.1(branch), GDAL 2.1 branch, GEOS 3.6')]] ||\
|| [[Image(https://debbie.postgis.net/buildStatus/icon?job=PostGIS_Worker_Run/label=bessie32&build=last:${params.reference=refs/heads/stable-3.0}, link=https://debbie.postgis.net/view/PostGIS/job/PostGIS_Worker_Run/label=bessie32, alt=status, height="20", title='PG 10.1(branch), GDAL 2.1 branch, GEOS 3.6')]] ||\
|| [[Image(https://debbie.postgis.net/buildStatus/icon?job=PostGIS_Worker_Run/label=berrie&build=last:${params.reference=refs/heads/stable-3.0}, link=https://debbie.postgis.net/view/PostGIS/job/PostGIS_Worker_Run/label=berrie, alt=status, height="20", title='PG 12(branch), GDAL 2.4.0 branch, GEOS 3.7.1')]] || \
|| [[Image(https://debbie.postgis.net/buildStatus/icon?job=PostGIS_Worker_Run/label=berrie64&build=last:${params.reference=refs/heads/stable-3.0}, link=https://debbie.postgis.net/view/PostGIS/job/PostGIS_Worker_Run/label=berrie64?build=last:${params.reference=refs/heads/stable-3.0, alt=status, height="20", title='PG 12(branch), GDAL 2.4.0 branch, GEOS 3.7.1')]] ||
||= '''2.5''' =|| \
|| [[Image(https://debbie.postgis.net/buildStatus/icon?job=PostGIS_2.5, link=https://debbie.postgis.net/view/PostGIS/job/PostGIS_2.5/, alt=status, height="20", title='PG 9.3-12(branch), GDAL 2.3 branch, GEOS 2.4')]] || \
|| [[Image(https://winnie.postgis.net:444/buildStatus/icon?job=PostGIS_2.5, link=https://winnie.postgis.net:444/view/PostGIS/job/PostGIS_2.5/, alt=status, height="20", title='PG 9.5-11, GDAL 2.2.4, GEOS 3.8,32/64-bit')]] ||\
|| [[Image(https://dronie.osgeo.org/api/badges/postgis/postgis/status.svg?ref=refs/heads/stable-2.5, link=https://dronie.osgeo.org/postgis/postgis?branch=stable-2.5, alt=status)]] ||\
|| [[Image(https://secure.travis-ci.org/postgis/postgis.svg?branch=stable-2.5, link=https://travis-ci.org/postgis/postgis?branch=stable-2.5, alt=status, height="20")]] ||\
|| [[Image(https://gitlab.com/postgis/postgis/badges/stable-2.5/pipeline.svg, link=https://gitlab.com/postgis/postgis/commits/stable-2.5, alt=status, height="20", title='PG 9.6.10, GDAL 2.1.2, GEOS 3.5.1, PROJ 4.9.3')]] ||\
|| [[Image(https://debbie.postgis.net/buildStatus/icon?job=PostGIS_Worker_Run/label=bessie&build=last:${params.reference=refs/heads/stable-2.5}, link=https://debbie.postgis.net/view/PostGIS/job/PostGIS_Worker_Run/label=bessie, alt=status, height="20", title='PG 11 (branch), GDAL 2.1 branch, GEOS 3.6')]] ||\
|| [[Image(https://debbie.postgis.net/buildStatus/icon?job=PostGIS_Worker_Run/label=bessie32&build=last:${params.reference=refs/heads/stable-2.5}, link=https://debbie.postgis.net/view/PostGIS/job/PostGIS_Worker_Run/label=bessie32, alt=status, height="20", title='PG 11(branch), GDAL 2.1 branch, GEOS 3.6')]] ||\
|| [[Image(https://debbie.postgis.net/buildStatus/icon?job=PostGIS_Worker_Run/label=berrie&build=last:${params.reference=refs/heads/stable-2.5}, link=https://debbie.postgis.net/view/PostGIS/job/PostGIS_Worker_Run/label=berrie, alt=status, height="20", title='PG 12(branch), GDAL 2.4.0 branch, GEOS 3.7.1')]] ||\
|| [[Image(https://debbie.postgis.net/buildStatus/icon?job=PostGIS_Worker_Run/label=berrie64&build=last:${params.reference=refs/heads/stable-2.5}, link=https://debbie.postgis.net/view/PostGIS/job/PostGIS_Worker_Run/label=berrie64, alt=status, height="20", title='PG 12(branch), GDAL 2.4.0 branch, GEOS 3.7.1')]] ||
||= '''2.4''' =|| \
|| [[Image(https://debbie.postgis.net/buildStatus/icon?job=PostGIS_2.4, link=https://debbie.postgis.net/view/PostGIS/job/PostGIS_2.4/, alt=status, height="20", title='PG 9.3-9.6 10(branch), GDAL 2.3 branch, GEOS 2.4')]] || \
|| [[Image(https://winnie.postgis.net:444/buildStatus/icon?job=PostGIS_2.4, link=https://winnie.postgis.net:444/view/PostGIS/job/PostGIS_2.4/, alt=status, height="20", title='PG 9.3-9.6, GDAL 2.2.4, GEOS 3.7dev,32/64-bit')]] ||\
|| [[Image(https://dronie.osgeo.org/api/badges/postgis/postgis/status.svg?ref=refs/heads/stable-2.4, link=https://dronie.osgeo.org/postgis/postgis?branch=stable-2.4, alt=status)]] ||\
|| [[Image(https://secure.travis-ci.org/postgis/postgis.svg?branch=stable-2.4, link=https://travis-ci.org/postgis/postgis?branch=stable-2.4, alt=status, height="20")]] ||\
|| [[Image(https://gitlab.com/postgis/postgis/badges/stable-2.4/pipeline.svg, link=https://gitlab.com/postgis/postgis/commits/stable-2.4, alt=status, height="20", title='PG 9.6.10, GDAL 2.1.2, GEOS 3.5.1, PROJ 4.9.3')]] ||
== About PostGIS ==
PostGIS is a geospatial extension for PostgreSQL. It allows map data to be stored, queried and analyzed within the database. It is an [http://www.osgeo.org OSGeo] project.
This Trac instance is used for bug, enhancement & task tracking for PostGIS. It also serves as a user and developer wiki, and a view into the [CodeRepository code repository]. To edit the wiki pages and bug/enhancement/task tickets you'll need to login with an [http://www.osgeo.org/osgeo_userid OSGeo Userid]. Read the TracGuide for details about how the site works.
The project's website is [https://postgis.net]
== Downloading ==
* [https://download.osgeo.org/postgis/source/ Released Tar Balls]
* [CodeMirrors List of source repos]
* [wiki:RCDownloads Release Candidate Downloads]
== Documentation ==
* Doxygen Dev Documents [https://postgis.net/docs/doxygen/3.1 3.1] [https://postgis.net/docs/doxygen/3.0 3.0] [https://postgis.net/docs/doxygen/2.5 2.5] [https://postgis.net/docs/doxygen/2.4 2.4]
* [http://postgis.net/documentation/ PostGIS Manuals]
* [wiki:UsersWikiPostgreSQLPostGIS PostgreSQL/PostGIS GEOS GDAL /PostGIS version support matrix]
== Mail lists ==
* [http://lists.osgeo.org/mailman/listinfo/postgis-users postgis-users] – Discussion of the use and uses of the PostGIS
* [http://lists.osgeo.org/mailman/listinfo/postgis-devel postgis-devel] – Discussion of ongoing development to the PostGIS; technical issues and debates about changes to the internals of PostGIS belong here
* [http://lists.osgeo.org/mailman/listinfo/postgis-tickets postgis-tickets] – Automatic notifications from Trac tickets (also called "issues")
== Bug Tracking ==
* [/newticket Submit a new bug report] (you need to [http://trac.osgeo.org/postgis/login login] with an [http://www.osgeo.org/osgeo_userid OSGeo Userid]). If you need to reset your password use [https://www.osgeo.org/user OSGeo profile reset password]
* Bug reports for the [wiki:WKTRaster PostGIS Raster] extension must have the summary prefixed with '''[raster]''' and the corresponding "raster" component assigned.
* If possible, provide the output of gdalinfo run upon the source raster.
* If the bug relates to the raster2pgsql loader, provide the command line parameters you are using.
* [/report/3 List Open Bugs]
* [query:status!=closed&type=enhancement&order=id&desc=1,compact List Open Enhancement Requests]
== Related Planets ==
* [http://planet.postgis.net Planet PostGIS]
* [http://planet.osgeo.org Planet OSGeo]
* [http://planet.postgresql.org Planet PostgreSQL]
* [http://planetgs.com Planet Geospatial]
== Wiki ==
* [UsersWikiMain Users Wiki]
* [wiki:UsersWikiInstall PostGIS Install and Compilation Guide] for different systems
* [wiki:UsersWikiPackages PostGIS Pre-Built Packages] for different systems
* [DevWikiMain Developer Wiki]
* [wiki:DevWikiRFC PostGIS RFCs]
* [wiki:GoogleSummerCode2019 Google Summer Of Code 2019]
* [wiki:GoogleSummerCode2018 Google Summer Of Code 2018]
* [wiki:GoogleSummerCode Google Summer Of Code 2013]
* [DevWikiEvent Code Sprint]
* [wiki:PostGIS3]
* [wiki:FAQ FAQ]
== PostGIS Extensions ==
List of PostGIS extensions:
=== PostGIS Raster (formerly PostGIS WKT Raster) ===
* [wiki:WKTRaster PostGIS Raster] – Integration of a new raster type within PostGIS spec.
* [wiki:WKTRasterTutorial01 Raster Tutorial] – Demonstrates how to use Raster with vector geometries and install on windows.
* [http://postgis.net/docs/manual-dev/RT_reference.html Raster functions reference] – This is a list of already implemented functions. Documentation of functions still in progress.
* [http://fuzzytolerance.info/code/postgis-raster-ftw/ PostGIS Raster FTW] – Real application – land classification /vector/raster operations
* [http://trac.osgeo.org/gdal/wiki/frmts_wtkraster.html PostGIS Raster Driver for GDAL] – Information about PostGIS Raster driver for GDAL
* [http://mateusz.loskot.net/2009/03/30/crunching-wkt-rasters/ Crunching Rasters with WKT Raster]
=== PostGIS Topology ===
* [wiki:UsersWikiPostgisTopology PostGIS Topology]
== Trac Documentation ==
* TracGuide – Built-in Documentation
* [http://trac.edgewall.org/ The Trac project] – Trac Open Source Project
* [http://trac.edgewall.org/wiki/TracFaq Trac FAQ] – Frequently Asked Questions
* TracSupport – Trac Support
For a complete list of local wiki pages, see TitleIndex.