<\/span>PostGIS availability and download<\/span><\/h2>\n\n\n\n
PostGIS is the most widely used spatial extension for PostgreSQL, but its availability varies depending on the operating system and version of PostgreSQL. It is important to choose the stable version that is appropriate for your environment to avoid compatibility issues and ensure the reliability of your geospatial processing.<\/p>\n\n\n\n
The table below summarizes the stable and experimental versions available for the main systems:<\/p>\n\n\n\n
System<\/th> PostgreSQL version<\/th> Stable PostGIS version<\/th> Experimental\/Beta version<\/th> Download\/installation link<\/th><\/tr><\/thead>
Windows<\/strong><\/td> 15<\/td> 3.5.3<\/td> 3.6 (testing only)<\/td> VVia StackBuilder included in PostgreSQL: Extensions > Spatial Extensions > PostGIS 3.5.3 Documentation PostGIS Windows<\/a><\/td><\/tr>
Ubuntu \/ Debian<\/strong><\/td> 15<\/td> 3.5<\/td> 3.6 (source compilation)<\/td> `sudo apt install postgis postgresql-15-postgis-3.5<\/code> PostGIS packages Ubuntu\/Debian<\/a><\/td><\/tr>`
RedHat \/ CentOS \/ Fedora<\/strong><\/td> 15<\/td> 3.5<\/td> 3.6 (source compilation)<\/td> `sudo dnf install postgis31_15<\/code> PostGIS packages RPM<\/a><\/td><\/tr>`
Linux (all distros)<\/strong><\/td> All<\/td> Source compilation<\/td> Last version dev (3.6+)<\/td> PostGIS source<\/a><\/td><\/tr><\/tbody><\/table><\/figure>\n\n\n\n
\n\n\n\n
<\/span>Practical tips<\/span><\/h2>\n\n\n\n
\n
Version 3.6 is not yet officially available on Windows.<\/li>\n\n\n\n
Experimental versions are intended solely for testing and discovering new features.<\/li>\n\n\n\n
On Windows, StackBuilder facilitates the installation and updating of dependencies.<\/li>\n\n\n\n
On Linux, compiling from source allows access to the latest features, but requires proper configuration of PostgreSQL and development libraries.<\/li>\n<\/ul>\n\n\n\n
\n\n\n\n
<\/span>Compatibility & required environments<\/span><\/h2>\n\n\n\n
\n
Compatible versions: PostgreSQL 12 \u2192 18 beta 3<\/li>\n\n\n\n
Essential prerequisites:\n
\n
GEOS \u2265 3.8, ideally 3.14+ for performance and new features<\/li>\n\n\n\n
PROJ \u2265 6.1<\/li>\n\n\n\n
SFCGAL \u2265 2.2 to take full advantage of 3D features (Phttps:\/\/postgis.net\/2025\/09\/PostGIS-3.6.0\/<\/a>ostGIS)<\/li>\n<\/ul>\n<\/li>\n<\/ul>\n\n\n\n
\n\n\n\n
<\/span>Noteworthy new features<\/span><\/h2>\n\n\n\n
<\/span>3D \/ SFCGAL:<\/span><\/h3>\n\n\n\n
\n
`CG_Simplify<\/code>, CG_3DAlphaWrapping<\/code> for manipulating 3D elements<\/li>\n\n\n\n`
`Geometric transformations: scaling, rotation, translation, 3D buffer, etc. (`PostGIS<\/a>)<\/li>\n<\/ul>\n\n\n\n<\/span>Coverage & topology:<\/span><\/h3>\n\n\n\n\nST_CoverageClean(...)<\/code><\/strong> : ensures clean coverage (no overlaps, aligned edges, gaps filled). Example of use: CREATE TABLE example_clean AS SELECT id, ST_CoverageClean(geom) OVER () AS geom FROM example;<\/code> Useful for validating the geometry of a coverage. . (PostGIS<\/a>)<\/li>\n<\/ul>\n\n\n\n<\/span>Raster processing:<\/span><\/h3>\n\n\n\n\nST_AsRasterAgg<\/code> : efficiently converts geometry to raster during aggregation<\/li>\n\n\n\n ST_ReclassExact<\/code> : fast and accurate reclassification of raster values. <\/li>\n\n\n\n ST_IntersectionFractions<\/code> : calculates the overlap fractions of raster cells with geometric UE (requires GEOS 3.14).<\/li>\n\n\n\npostgis.gdal_cpl_debug<\/code> (GUC) : logs GDAL messages in PostgreSQL (PostGIS<\/a>)<\/li>\n<\/ul>\n\n\n\n \n\n\n\n<\/span>Major changes \/ Breaking changes to note<\/span><\/h2>\n\n\n\n\nST_TileEnvelope<\/code><\/strong> : envelopes are now restricted to the tile plane extent. (tile plane extent). (PostGIS<\/a>)<\/li>\n\n\n\n geometry_columns<\/code> : removal of constraint checks, impacting old workflows. (PostGIS<\/a>)<\/li>\n\n\n\n Deprecation of integer topological functions<\/strong>: now replaced by their bigint version (PostGIS<\/a>)<\/li>\n\n\n\n Change for TIN \/ PolyhedralSurface<\/strong>: use ST_NumPatche<\/em>s and ST_PatchN<\/em> instead of ST_NumGeometries<\/em>, which no longer return sub-geometries (PostGIS<\/a>)<\/li>\n\n\n\n Removal of st_approxquantile(raster, double precision)<\/strong>, unusable in practice. (PostGIS<\/a>)<\/li>\n<\/ul>\n\n\n\n \n\n\n\n<\/span>Update process<\/span><\/h2>\n\n\n\nTo migrate to PostGIS 3.6 (3.0 to 3.6):<\/p>\n\n\n <\/div> <\/div><\/div><\/div><\/p>\n\n\n\nSELECT postgis_extensions_upgrade();\n<\/code><\/pre>\n\n\n\n<\/div><\/div>\n\n\n\n For versions \u2264 2.5:<\/p>\n\n\n <\/div> <\/div><\/div><\/div>\n\n\n\nALTER EXTENSION postgis UPDATE; SELECT postgis_extensions_upgrade(); \u00ab\u00a0` :contentReference[oaicite:10]{index=10} <\/div><\/div> Nota : lancer ces commandes apr\u00e8s migration PostgreSQL<\/strong> ou restauration des extensions.<\/p>\n\n\n\n <\/span>Advanced use cases<\/span><\/h2>\n\n\n\n<\/span>Cleaning up impure coverage <\/span><\/h3>\n\n\n<\/div> <\/div><\/div><\/div><\/p>\n\n\n\n WITH dirty AS ( SELECT id, geom FROM coverage_table ) SELECT id, ST_AsText(ST_CoverageInvalidEdges(geom) OVER ()) AS invalid_geom FROM dirty; CREATE TABLE coverage_clean AS SELECT id, ST_CoverageClean(geom) OVER () FROM dirty; SELECT id, ST_AsText(ST_CoverageInvalidEdges(geom) OVER ()) FROM coverage_clean; <\/div><\/div>\n\n\n\n <\/span>Raster reclassification<\/span><\/h3>\n\n\n<\/div> <\/div><\/div><\/div><\/p>\n\n\n\nSELECT ST_ReclassExact(rast, '[(1,10,100),(11,20,200)]') AS reclass_rast\nFROM raster_table;\n<\/code><\/pre>\n\n\n\n<\/div><\/div>\n\n\n\n <\/span>Simple 3D simulation<\/span><\/h3>\n\n\n<\/div> <\/div><\/div><\/div><\/p>\n\n\n\nSELECT CG_3DAlphaWrapping(geom) FROM building_wall;\n<\/code><\/pre>\n\n\n\n<\/div><\/div>\n\n\n\n \n","protected":false},"excerpt":{"rendered":"New version: PostGIS 3.6.0 (Released September 2, 2025) PostGIS 3.6.0 has been available since September 2, 2025. It is designed to work with PostgreSQL 12 through 18 beta 3, requires GEOS 3.8+ (with optimizations for GEOS…<\/p>\n","protected":false},"author":1,"featured_media":15556,"comment_status":"open","ping_status":"closed","sticky":false,"template":"","format":"standard","meta":{"give_campaign_id":0,"_bbp_topic_count":0,"_bbp_reply_count":0,"_bbp_total_topic_count":0,"_bbp_total_reply_count":0,"_bbp_voice_count":0,"_bbp_anonymous_reply_count":0,"_bbp_topic_count_hidden":0,"_bbp_reply_count_hidden":0,"_bbp_forum_subforum_count":0,"sfsi_plus_gutenberg_text_before_share":"","sfsi_plus_gutenberg_show_text_before_share":"","sfsi_plus_gutenberg_icon_type":"","sfsi_plus_gutenberg_icon_alignemt":"","sfsi_plus_gutenburg_max_per_row":"","_monsterinsights_skip_tracking":false,"_monsterinsights_sitenote_active":false,"_monsterinsights_sitenote_note":"","_monsterinsights_sitenote_category":0,"jetpack_post_was_ever_published":false,"_jetpack_newsletter_access":"","_jetpack_dont_email_post_to_subs":false,"_jetpack_newsletter_tier_id":0,"_jetpack_memberships_contains_paywalled_content":false,"_jetpack_memberships_contains_paid_content":false,"footnotes":""},"categories":[3264],"tags":[3717,1462,3719,2060,2247],"class_list":["post-15662","post","type-post","status-publish","format-standard","has-post-thumbnail","hentry","category-postgis-fr-es-en","tag-3-6-en","tag-3d-en","tag-postgsi-en","tag-raster-en","tag-topology"],"aioseo_notices":[],"jetpack_featured_media_url":"https:\/\/i0.wp.com\/www.sigterritoires.fr\/wp-content\/uploads\/2025\/09\/postgis.jpg?fit=745%2C331&ssl=1","jetpack_shortlink":"https:\/\/wp.me\/p6XU0A-44C","jetpack_sharing_enabled":true,"_links":{"self":[{"href":"https:\/\/www.sigterritoires.fr\/index.php\/wp-json\/wp\/v2\/posts\/15662","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/www.sigterritoires.fr\/index.php\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/www.sigterritoires.fr\/index.php\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/www.sigterritoires.fr\/index.php\/wp-json\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/www.sigterritoires.fr\/index.php\/wp-json\/wp\/v2\/comments?post=15662"}],"version-history":[{"count":0,"href":"https:\/\/www.sigterritoires.fr\/index.php\/wp-json\/wp\/v2\/posts\/15662\/revisions"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/www.sigterritoires.fr\/index.php\/wp-json\/wp\/v2\/media\/15556"}],"wp:attachment":[{"href":"https:\/\/www.sigterritoires.fr\/index.php\/wp-json\/wp\/v2\/media?parent=15662"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/www.sigterritoires.fr\/index.php\/wp-json\/wp\/v2\/categories?post=15662"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/www.sigterritoires.fr\/index.php\/wp-json\/wp\/v2\/tags?post=15662"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}

System<\/th>	PostgreSQL version<\/th>	Stable PostGIS version<\/th>	Experimental\/Beta version<\/th>	Download\/installation link<\/th><\/tr><\/thead>
Windows<\/strong><\/td>	15<\/td>	3.5.3<\/td>	3.6 (testing only)<\/td>	VVia StackBuilder included in PostgreSQL: Extensions > Spatial Extensions > PostGIS 3.5.3 Documentation PostGIS Windows<\/a><\/td><\/tr>
Ubuntu \/ Debian<\/strong><\/td>	15<\/td>	3.5<\/td>	3.6 (source compilation)<\/td>	`sudo apt install postgis postgresql-15-postgis-3.5<\/code> PostGIS packages Ubuntu\/Debian<\/a><\/td><\/tr>`
RedHat \/ CentOS \/ Fedora<\/strong><\/td>	15<\/td>	3.5<\/td>	3.6 (source compilation)<\/td>	`sudo dnf install postgis31_15<\/code> PostGIS packages RPM<\/a><\/td><\/tr>`
Linux (all distros)<\/strong><\/td>	All<\/td>	Source compilation<\/td>	Last version dev (3.6+)<\/td>	PostGIS source<\/a><\/td><\/tr><\/tbody><\/table><\/figure>\n\n\n\n \n\n\n\n <\/span>Practical tips<\/span><\/h2>\n\n\n\n \n Version 3.6 is not yet officially available on Windows.<\/li>\n\n\n\n Experimental versions are intended solely for testing and discovering new features.<\/li>\n\n\n\n On Windows, StackBuilder facilitates the installation and updating of dependencies.<\/li>\n\n\n\n On Linux, compiling from source allows access to the latest features, but requires proper configuration of PostgreSQL and development libraries.<\/li>\n<\/ul>\n\n\n\n \n\n\n\n <\/span>Compatibility & required environments<\/span><\/h2>\n\n\n\n \n Compatible versions: PostgreSQL 12 \u2192 18 beta 3<\/li>\n\n\n\n Essential prerequisites:\n \n GEOS \u2265 3.8, ideally 3.14+ for performance and new features<\/li>\n\n\n\n PROJ \u2265 6.1<\/li>\n\n\n\n SFCGAL \u2265 2.2 to take full advantage of 3D features (Phttps:\/\/postgis.net\/2025\/09\/PostGIS-3.6.0\/<\/a>ostGIS)<\/li>\n<\/ul>\n<\/li>\n<\/ul>\n\n\n\n \n\n\n\n <\/span>Noteworthy new features<\/span><\/h2>\n\n\n\n <\/span>3D \/ SFCGAL:<\/span><\/h3>\n\n\n\n \n `CG_Simplify<\/code>, CG_3DAlphaWrapping<\/code> for manipulating 3D elements<\/li>\n\n\n\n` `Geometric transformations: scaling, rotation, translation, 3D buffer, etc. (`PostGIS<\/a>)<\/li>\n<\/ul>\n\n\n\n<\/span>Coverage & topology:<\/span><\/h3>\n\n\n\n\nST_CoverageClean(...)<\/code><\/strong> : ensures clean coverage (no overlaps, aligned edges, gaps filled). Example of use: CREATE TABLE example_clean AS SELECT id, ST_CoverageClean(geom) OVER () AS geom FROM example;<\/code> Useful for validating the geometry of a coverage. . (PostGIS<\/a>)<\/li>\n<\/ul>\n\n\n\n<\/span>Raster processing:<\/span><\/h3>\n\n\n\n\nST_AsRasterAgg<\/code> : efficiently converts geometry to raster during aggregation<\/li>\n\n\n\n ST_ReclassExact<\/code> : fast and accurate reclassification of raster values. <\/li>\n\n\n\n ST_IntersectionFractions<\/code> : calculates the overlap fractions of raster cells with geometric UE (requires GEOS 3.14).<\/li>\n\n\n\npostgis.gdal_cpl_debug<\/code> (GUC) : logs GDAL messages in PostgreSQL (PostGIS<\/a>)<\/li>\n<\/ul>\n\n\n\n \n\n\n\n<\/span>Major changes \/ Breaking changes to note<\/span><\/h2>\n\n\n\n\nST_TileEnvelope<\/code><\/strong> : envelopes are now restricted to the tile plane extent. (tile plane extent). (PostGIS<\/a>)<\/li>\n\n\n\n geometry_columns<\/code> : removal of constraint checks, impacting old workflows. (PostGIS<\/a>)<\/li>\n\n\n\n Deprecation of integer topological functions<\/strong>: now replaced by their bigint version (PostGIS<\/a>)<\/li>\n\n\n\n Change for TIN \/ PolyhedralSurface<\/strong>: use ST_NumPatche<\/em>s and ST_PatchN<\/em> instead of ST_NumGeometries<\/em>, which no longer return sub-geometries (PostGIS<\/a>)<\/li>\n\n\n\n Removal of st_approxquantile(raster, double precision)<\/strong>, unusable in practice. (PostGIS<\/a>)<\/li>\n<\/ul>\n\n\n\n \n\n\n\n<\/span>Update process<\/span><\/h2>\n\n\n\nTo migrate to PostGIS 3.6 (3.0 to 3.6):<\/p>\n\n\n <\/div> <\/div><\/div><\/div><\/p>\n\n\n\nSELECT postgis_extensions_upgrade();\n<\/code><\/pre>\n\n\n\n<\/div><\/div>\n\n\n\n For versions \u2264 2.5:<\/p>\n\n\n <\/div> <\/div><\/div><\/div>\n\n\n\nALTER EXTENSION postgis UPDATE; SELECT postgis_extensions_upgrade(); \u00ab\u00a0` :contentReference[oaicite:10]{index=10} <\/div><\/div> Nota : lancer ces commandes apr\u00e8s migration PostgreSQL<\/strong> ou restauration des extensions.<\/p>\n\n\n\n <\/span>Advanced use cases<\/span><\/h2>\n\n\n\n<\/span>Cleaning up impure coverage <\/span><\/h3>\n\n\n<\/div> <\/div><\/div><\/div><\/p>\n\n\n\n WITH dirty AS ( SELECT id, geom FROM coverage_table ) SELECT id, ST_AsText(ST_CoverageInvalidEdges(geom) OVER ()) AS invalid_geom FROM dirty; CREATE TABLE coverage_clean AS SELECT id, ST_CoverageClean(geom) OVER () FROM dirty; SELECT id, ST_AsText(ST_CoverageInvalidEdges(geom) OVER ()) FROM coverage_clean; <\/div><\/div>\n\n\n\n <\/span>Raster reclassification<\/span><\/h3>\n\n\n<\/div> <\/div><\/div><\/div><\/p>\n\n\n\nSELECT ST_ReclassExact(rast, '[(1,10,100),(11,20,200)]') AS reclass_rast\nFROM raster_table;\n<\/code><\/pre>\n\n\n\n<\/div><\/div>\n\n\n\n <\/span>Simple 3D simulation<\/span><\/h3>\n\n\n<\/div> <\/div><\/div><\/div><\/p>\n\n\n\nSELECT CG_3DAlphaWrapping(geom) FROM building_wall;\n<\/code><\/pre>\n\n\n\n<\/div><\/div>\n\n\n\n \n","protected":false},"excerpt":{"rendered":"New version: PostGIS 3.6.0 (Released September 2, 2025) PostGIS 3.6.0 has been available since September 2, 2025. It is designed to work with PostgreSQL 12 through 18 beta 3, requires GEOS 3.8+ (with optimizations for GEOS…<\/p>\n","protected":false},"author":1,"featured_media":15556,"comment_status":"open","ping_status":"closed","sticky":false,"template":"","format":"standard","meta":{"give_campaign_id":0,"_bbp_topic_count":0,"_bbp_reply_count":0,"_bbp_total_topic_count":0,"_bbp_total_reply_count":0,"_bbp_voice_count":0,"_bbp_anonymous_reply_count":0,"_bbp_topic_count_hidden":0,"_bbp_reply_count_hidden":0,"_bbp_forum_subforum_count":0,"sfsi_plus_gutenberg_text_before_share":"","sfsi_plus_gutenberg_show_text_before_share":"","sfsi_plus_gutenberg_icon_type":"","sfsi_plus_gutenberg_icon_alignemt":"","sfsi_plus_gutenburg_max_per_row":"","_monsterinsights_skip_tracking":false,"_monsterinsights_sitenote_active":false,"_monsterinsights_sitenote_note":"","_monsterinsights_sitenote_category":0,"jetpack_post_was_ever_published":false,"_jetpack_newsletter_access":"","_jetpack_dont_email_post_to_subs":false,"_jetpack_newsletter_tier_id":0,"_jetpack_memberships_contains_paywalled_content":false,"_jetpack_memberships_contains_paid_content":false,"footnotes":""},"categories":[3264],"tags":[3717,1462,3719,2060,2247],"class_list":["post-15662","post","type-post","status-publish","format-standard","has-post-thumbnail","hentry","category-postgis-fr-es-en","tag-3-6-en","tag-3d-en","tag-postgsi-en","tag-raster-en","tag-topology"],"aioseo_notices":[],"jetpack_featured_media_url":"https:\/\/i0.wp.com\/www.sigterritoires.fr\/wp-content\/uploads\/2025\/09\/postgis.jpg?fit=745%2C331&ssl=1","jetpack_shortlink":"https:\/\/wp.me\/p6XU0A-44C","jetpack_sharing_enabled":true,"_links":{"self":[{"href":"https:\/\/www.sigterritoires.fr\/index.php\/wp-json\/wp\/v2\/posts\/15662","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/www.sigterritoires.fr\/index.php\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/www.sigterritoires.fr\/index.php\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/www.sigterritoires.fr\/index.php\/wp-json\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/www.sigterritoires.fr\/index.php\/wp-json\/wp\/v2\/comments?post=15662"}],"version-history":[{"count":0,"href":"https:\/\/www.sigterritoires.fr\/index.php\/wp-json\/wp\/v2\/posts\/15662\/revisions"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/www.sigterritoires.fr\/index.php\/wp-json\/wp\/v2\/media\/15556"}],"wp:attachment":[{"href":"https:\/\/www.sigterritoires.fr\/index.php\/wp-json\/wp\/v2\/media?parent=15662"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/www.sigterritoires.fr\/index.php\/wp-json\/wp\/v2\/categories?post=15662"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/www.sigterritoires.fr\/index.php\/wp-json\/wp\/v2\/tags?post=15662"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}

<\/span>Compatibility & required environments<\/span><\/h2>\n\n\n\n\nCompatible versions: PostgreSQL 12 \u2192 18 beta 3<\/li>\n\n\n\n

<\/span>Noteworthy new features<\/span><\/h2>\n\n\n\n<\/span>3D \/ SFCGAL:<\/span><\/h3>\n\n\n\n\nCG_Simplify<\/code>, CG_3DAlphaWrapping<\/code> for manipulating 3D elements<\/li>\n\n\n\n

<\/span>3D \/ SFCGAL:<\/span><\/h3>\n\n\n\n\nCG_Simplify<\/code>, CG_3DAlphaWrapping<\/code> for manipulating 3D elements<\/li>\n\n\n\n