Issue Details
InsightCM 3.12.x ships with PostgreSQL 16.10, and InsightCM 26.0 ships with PostgreSQL 16.13, which is several security releases behind. PostgreSQL 16.14 fixes 11 CVEs, including three rated CVSS 8.8. PostgreSQL can be upgraded to 16.14 independently of InsightCM by running the EDB installer over the existing installation.
Solution/Procedure
This is a same-major minor upgrade (16.10 → 16.14): the installer swaps the server binaries in place and reuses the existing data directory, so no dump/restore is required. The EDB installer detects the existing installation and upgrades it automatically. pgAdmin 4 and Stack Builder are optional client/add-on tools and are not required on an InsightCM server — deselect them during installation.
1. We recommend creating a checkpoint of the server, or taking a backup of the databases, before upgrading PostgreSQL.
2. Download the PostgreSQL 16.14 Windows x86-64 installer from the EDB download page (see Related Articles below).
3. Stop the InsightCM and InsightCM MongoDB services.
4. Stop the PostgreSQL service (e.g., postgresql-x64-16).
5. Run the EDB installer. Keep the existing installation directory and data directory when prompted.
6. On the Select Components screen, uncheck pgAdmin 4 and Stack Builder. Keep PostgreSQL Server and Command Line Tools checked.
7. Complete the installer. If offered, do not launch Stack Builder at the finish screen.
8. Start the PostgreSQL service.
9. (Optional) Verify the upgrade:
SELECT version();
This must report 16.14.
10. (Optional) Verify the TimescaleDB extension loads:
SELECT extversion FROM pg_extension WHERE extname = 'timescaledb';
11. Restart the InsightCM services — ideally, reboot the server to bring everything back up cleanly.
12. Smoke-check InsightCM: log in to the UI, confirm the asset tree loads, and confirm devices are collecting data.
Additional Information
Upgrading PostgreSQL to 16.14 on all previous InsightCM versions is supported
Related Articles
EDB PostgreSQL Installer Downloads (External Link)
PostgreSQL 16.14 Security Release Announcement (External Link)
Do you need more help?
Submit your questions or requests using the Support Ticket Submission form.