feat: Add support for Postgres 18

[cbaker6]

Pull Request

• Report security issues confidentially.
• Any contribution is under this license.
• Link this pull request to an issue.

Issue

Closes: #9871

Approach

Add support for Postgres 18. Note that Postgis 3.6 is made for Posgres 18.

Tasks

• Add tests
• @mtrezza should update the repo settings to require the CI passes for ci / PostgreSQL 18, PostGIS 3.6

Summary by CodeRabbit

• Documentation

  • Updated badges to include PostgreSQL 18.
  • Expanded compatibility table with a new row for PostgreSQL 18 (PostGIS 3.6), including EOL and version compatibility details.

• Chores

  • Extended CI coverage to test against PostgreSQL 18 with PostGIS 3.6 by adding an extra matrix entry.

[parse-github-assistant]

🚀 Thanks for opening this pull request!

[coderabbitai]

📝 Walkthrough

Walkthrough

Adds PostgreSQL 18 (PostGIS 3.6) to the CI matrix in .github/workflows/ci.yml and updates README.md badges and the Postgres versions table to include PostgreSQL 18 / PostGIS 3.6 entries and metadata.

Changes

Cohort / File(s)	Summary
CI workflow: PostgreSQL matrix update \.github/workflows/ci.yml	Added a new matrix entry for postgis/postgis:18-3.6 with a corresponding NODE_VERSION matrix value; no other job steps or logic changed.
Docs: README badges and versions table README.md	Updated PostgreSQL badge to include version 18 and added a table row for PostgreSQL 18 with PostGIS 3.6, EOL Nov 2030, and compatibility note (<= 11.x, 2028).

Estimated code review effort

🎯 2 (Simple) | ⏱️ ~10 minutes

Pre-merge checks and finishing touches

✅ Passed checks (3 passed)

Check name	Status	Explanation
Docstring Coverage	✅ Passed	No functions found in the changes. Docstring coverage check skipped.
Title Check	✅ Passed	The title succinctly describes the primary change of adding Postgres 18 support, matching the modifications in the CI configuration and documentation and uses clear phrasing.
Description Check	✅ Passed	The pull request description includes all required template sections: the initial boilerplate under “Pull Request,” a linked issue with “Closes: #9871,” a clear “Approach” detailing the added PostgreSQL 18 support, and a “Tasks” checklist that has been trimmed to relevant items. It correctly follows the specified template structure and provides the necessary information.

✨ Finishing touches

• 📝 Generate docstrings

🧪 Generate unit tests (beta)

• Create PR with unit tests
• Post copyable unit tests in a comment

---

Thanks for using CodeRabbit! It's free for OSS, and your support helps us grow. If you like it, consider giving us a shout-out.

❤️ Share

• X
• Mastodon
• Reddit
• LinkedIn

_{Comment @coderabbitai help to get the list of available commands and usage tips.}

[parseplatformorg]

✅ Snyk checks have passed. No issues have been found so far.

Status	Scanner	Critical	High	Medium	Low	Total (0)
✅	Open Source Security	0	0	0	0	0 issues

💻 Catch issues earlier using the plugins for VS Code, JetBrains IDEs, Visual Studio, and Eclipse.

[coderabbitai]

Actionable comments posted: 1

📜 Review details

Configuration used: CodeRabbit UI

Review profile: CHILL

Plan: Pro

📥 Commits

Reviewing files that changed from the base of the PR and between f62da3f and bf3b1de.

📒 Files selected for processing (2)

• .github/workflows/ci.yml (1 hunks)
• README.md (2 hunks)

⏰ Context from checks skipped due to timeout of 90000ms. You can increase the timeout in your CodeRabbit configuration to a maximum of 15 minutes (900000ms). (14)

• GitHub Check: PostgreSQL 18, PostGIS 3.6
• GitHub Check: PostgreSQL 17, PostGIS 3.5
• GitHub Check: Docker Build
• GitHub Check: Node 20
• GitHub Check: PostgreSQL 16, PostGIS 3.5
• GitHub Check: PostgreSQL 15, PostGIS 3.3
• GitHub Check: MongoDB 7, ReplicaSet
• GitHub Check: MongoDB 8, ReplicaSet
• GitHub Check: PostgreSQL 15, PostGIS 3.5
• GitHub Check: PostgreSQL 15, PostGIS 3.4
• GitHub Check: MongoDB 6, ReplicaSet
• GitHub Check: Node 18
• GitHub Check: Redis Cache
• GitHub Check: Code Analysis (javascript)

[codecov]

Codecov Report

✅ All modified and coverable lines are covered by tests.
✅ Project coverage is 93.01%. Comparing base (7cb962a) to head (b42f1f1).
⚠️ Report is 3 commits behind head on alpha.

Additional details and impacted files

@@            Coverage Diff             @@
##            alpha    #9870      +/-   ##
==========================================
- Coverage   93.02%   93.01%   -0.02%     
==========================================
  Files         187      187              
  Lines       15097    15097              
  Branches      174      174              
==========================================
- Hits        14044    14042       -2     
- Misses       1041     1043       +2     
  Partials       12       12              

☔ View full report in Codecov by Sentry.
📢 Have feedback on the report? Share it here.

🚀 New features to boost your workflow:

• ❄️ Test Analytics: Detect flaky tests, report on failures, and find test suite problems.
• 📦 JS Bundle Analysis: Save yourself from yourself by tracking and limiting bundle sizes in JS merges.

[parseplatformorg]

🎉 This change has been released in version 8.3.0-alpha.3