Roadmap
This section presents the highlights of PostgreSYS versions, including features planned for the upcoming semesters.
Current Version
PGSYS 4.0 | 2025-S1
- PgSmart Web: Web interface for managing PostgreSQL environments
- New documentation platform: Docusaurus with multi-language support
- Component update: Latest versions of all components
Planned Versions
PGSYS 4.1 | 2025-S2
- Tuning Advisor: Automated parameter optimization recommendations
- pgvector extension added: Support for vector data and indexes
- Component update: Latest versions of all components
PGSYS 4.2 | 2026-S1
- Extended support for Debian family operating systems: Debian 12 and Ubuntu 24**
- Cloud Native Edition: Support for Kubernetes and containerized environments
- Component update: Latest versions of all components
PGSYS 4.3 | 2026-S2
- Smart Prompt: Command-line interface with contextual suggestions and actions
- Auto Upgrade of PostgreSQL Instances: Automatic version upgrades
- Component update: Latest versions of all components
Previous Versions
PGSYS 3.1 | 2024-S1
- Observability with Prometheus and Grafana: Advanced monitoring
- PostGIS extension for geoprocessing: Support for geospatial data
- Extended support for SUSE Linux Enterprise Server: SLES 15+
- Component update: Latest versions of all components
PGSYS 3.0 | 2023-S2
- Remote administration: Client-server architecture for component management
- Minor version selection for PostgreSQL: Installation flexibility
- New automations: Guided addition of members to the Distributed Configuration Directory
- PgSmart improvements: Enhancements in usability and security
- Extended support for new Enterprise Linux OS: Oracle Linux 7.5/8.x, AlmaLinux 8.x, Rocky Linux 8.x
- Component update: Latest versions of all components
PGSYS 2.2 | 2022-T3
- High availability with Patroni: Provisioning of high-availability instances
PGSYS 2.1 | 2022-T2
- Disaster Recovery with pgBackRest: Backup policies defined by environment
PGSYS 2.0 | 2022-T1
- Backup management with pgBackRest: Simplified execution of backups and restores
PGSYS 1.2 | 2021-T4
- Extended support for CentOS/RHEL: CentOS/RHEL 8.x
PGSYS 1.1 | 2021-T3
- Connection Pool service with PgBouncer: Simplified pool configuration
- Flexible service and process control: Improved system interaction
PGSYS 1.0 | 2021-T2
- PostgreSQL instance installation and initialization: Unified and simplified process
- Assisted configuration of PostgreSQL instances: Guided adjustments