As of November 13, 2024, PostgreSQL 12 is no longer supported by the official developer. Using this version, you no longer receive security updates and bug fixes.
BRIX also no longer supports older versions of PostgreSQL:
- 10 and lower starting with release 2024.4.
- 12 and lower support is scheduled to end with release 2026.4.
Upgrade PostgreSQL to version 13 or higher in advance. This will ensure database security and performance, and ensure timely implementation of improvements from the database developer.
We recommend using PostgreSQL 18. It offers the following features:
- Efficient index compression. Helps save disk space.
- Fast maintenance of large tables. Parallel index cleaning (VACUUM).
- Improved database stability. Row freezing occurs during routine operations.
- The pg_stat_io tool for detailed diagnostics of the disk subsystem. Helps analyze and improve performance.
- Flexible replica management. You can:
- Create new copies from standby servers.
- Transfer data between replicas faster thanks to parallel processing.
- Configure selective data synchronization and copy only the required table columns.
- Flexible access rules. Configure database connections using regular expressions.
To learn how to update various deployment options, read the articles:
- Updating standalone PostgreSQL 12 and lower to version 18.
- Updating PostgreSQL cluster 12 and lower to version 18.
- Updating PostgreSQL container 12 and lower to version 18.
Was this helpful?
Found a typo? Select it and press Ctrl+Enter to send us feedback