🚀 Autobase 2.5 — Expert Mode

With the release of Autobase version 2.0, we introduced the Console (UI) — a graphical interface that simplifies cluster deployment. Now, we’re adding Expert Mode, which unlocks advanced UI options tailored for experienced users who need greater control and flexibility.

This release has been highly anticipated 🎉
Huge thanks to Ilya Napolskikh (@Rainbrand) for the amazing work on Expert Mode! 🙏💙

🔭 Looking ahead, we are planning to enhance the Autobase UI with features that will enable you to manage your PostgreSQL clusters directly through the UI. If you’re interested in supporting the continued development of this feature, please consider becoming a sponsor.

✨ Highlights

Expert Mode

This mode reveals additional advanced settings that allow for precise cluster configuration, including options not available in the standard mode:

• Custom server type - Specify a custom server (instance) type not shown in the console list.
• Spot instances - The ability to use Spot instances.
• Volume and file system type - Select storage volume type and file system.
• Custom network - Specify a custom Network/VPC.
• Databases - Add databases and users.
• Connection pools - Configure the PgBouncer connection pooler.
• Extensions - Select extensions to install.
• Backup options - Configure backup settings.
• Postgres and kernel parameters - Adjust PostgreSQL and kernel parameters.
• Additional settings - Configure extra options, including: Synchronous standby nodes, Public database access, Cloud Load Balancer, Monitoring via Netdata.

Additionally, for Your Own Machines mode:

• Convert standalone to HA - Transform an existing PostgreSQL installation into a full HA cluster.
• DCS options - Choose the DCS type (etcd or Consul), deploy new nodes, or use an existing DCS cluster.
• Load balancer options - Decide whether to deploy HAProxy on database nodes or on dedicated servers.
• Custom data directory - Define a custom path for the PostgreSQL data directory.

YAML tab

Autobase offers a wide range of functionality, and not all options can be fully represented through UI forms. That’s why we added a YAML editor, allowing you to specify any parameters that were previously available only in command-line mode.

New Hetzner Cloud instances (including ARM)

Inserts updated pricing and specifications for various Hetzner instance types, including ARM-based instances.

New AWS/GCP instances (Xeon Gen 4)

Upgraded compute instances to the 4th-gen Intel Sapphire Rapids series (AWS: m7, GCP: c3) for improved performance and memory bandwidth, without a significant increase in cost.

IOPS and throughput options for AWS EBS volumes

Introduces configurable IOPS and throughput parameters for both data and system EBS volumes in AWS.
Variables: volume_iops (default: 3000), volume_throughput (default: 125).

Ansible 12 support

Added compatibility with Ansible version 12.

Migration Notes

Important note! The minimum supported Patroni version is 4.0.0 (released on 2024-08-29).
If you’re still using an older version, this is a good opportunity to upgrade your cluster before using Autobase 2.5.0.

What's Changed

• chore(deps): update python dependencies by @renovate[bot] in #1285
• Run scheduled workflows only repo owner vitabaks by @cherts in #1290
• fix: Fixed several errors in the remove_node playbook by @cherts in #1292
• fix: Added update patroni config file in the add_node playbook by @cherts in #1294
• chore(deps): update npm dependencies by @renovate[bot] in #1295
• chore(deps): update python dependencies by @renovate[bot] in #1296
• Make WAL-G retention configurable with WAL_G_RETENTION_FULL by @vitabaks in #1302
• Check syntax of patroni and pg_hba config files by @sshenderson in #1297
• Handle missing subjectAltName in TLS certificate role by @vitabaks in #1305
• Improve Patroni leader health check logic by @vitabaks in #1306
• Add Ansible 12 compatibility by @Copilot in #1279
• chore(deps): update dependency python to 3.14 by @renovate[bot] in #1307
• chore(deps): update docker dependencies to v2.4.1 by @renovate[bot] in #1308
• chore(deps): update python dependencies by @renovate[bot] in #1312
• chore(deps): update dependency vite to v7.1.11 [security] by @renovate[bot] in #1315
• chore(deps): update npm dependencies by @renovate[bot] in #1313
• Add ignore-listen-port option for Patroni config validation by @sshenderson in #1317
• Compatibility with Ansible 12 (part 2) by @vitabaks in #1321
• Describe the README for each ansible role by @Copilot in #1217
• fix: Replaced tls_cert_generate with host_type in pg_hba.conf.j2 by @catemiko in #1323
• Introduce new option disable_logrotate_for_postgresql by @bkhomuts in #1327
• chore(deps): update python dependencies by @renovate[bot] in #1328
• Set default nameservers to empty list by @vitabaks in #1329
• fix(deps): update go dependencies by @renovate[bot] in #1331
• Update AWS/GCP instances to Xeon Gen 4 (Sapphire Rapids) by @vitabaks in #1332
• chore(deps): update npm dependencies by @renovate[bot] in #1330
• Do not set tags: nosync when sync_priority is defined by @bkhomuts in #1342
• fix: Make Consul commands conditional on TLS configuration by @tired-engineer in #1345
• fix(deps): update go dependencies by @renovate[bot] in #1350
• chore(deps): update dependency js-yaml to v4.1.1 [security] by @renovate[bot] in #1348
• Add IOPS and throughput options for AWS EBS volumes by @vitabaks in #1351
• feat(expertMode): implemented expert mode by @Rainbrand in #1322
• Update Hetzner cloud instances (including ARM) by @vitabaks in #1352
• Update etcd version to 3.5.25 by @vitabaks in #1353

New Contributors

• @sshenderson made their first contribution in #1297
• @catemiko made their first contribution in #1323
• @tired-engineer made their first contribution in #1345

Full Changelog: 2.4.0...2.5.0