Console (UI/API): Cluster management functionality

[vitabaks]

With the release of postgresql_cluster version 2.0, we introduced a Console (UI) designed for deploying clusters through a graphical interface. The next step is to add functionality for managing an already deployed cluster through the UI, including:

• Edit a cluster
  • Change the cluster name, description, environment, synchronous mode, etc.
• Stop/Start a cluster or a specific cluster node
  • Control the Patroni service or the VM (for cloud deployments)
• Delete a cluster
  • Remove cluster components from the server or the entire VM (for cloud deployments)
  • Note: Currently, only deleting the cluster record from the Console database has been implemented.
• Switchover/Failover, Reinit, Reload, Restart
  • Integration with the Patroni API
• Users
  • Create and edit database users
• Databases
  • Create and edit databases
• Extensions
  • Create and edit database extensions
• Parameters
  • Edit Postgres and system parameters
• Connections
  • Manage connection settings
  • Enable/disable public access to the database (for cloud deployments)
  • Configure PgBouncer connection pools
  • Manage pg_hba rules
• Backups
  • Manage database backup settings
    • Backup schedule
    • Backup retention
    • Backup tool configuration
  • Details: https://postgresql-cluster.org/docs/management/backup
• Restore a cluster
  • Restoring (PITR) or Cloning a cluster from a backup
  • Details: https://postgresql-cluster.org/docs/management/restore
• Upgrades
  • Minor and major cluster upgrade
  • Details: https://postgresql-cluster.org/docs/management/upgrades
• Cluster Scaling
  • Scaling the cluster - add Postgres node
  • Details: https://postgresql-cluster.org/docs/management/cluster-scaling

Example:

Note: Access to the Figma project with all implementation details will be provided during development.

---

Consider sponsoring the project via GitHub or Patreon

[vitabaks]

If you're interested in this feature, please consider becoming a sponsor.

The development of this feature requires sponsorship to fund developer efforts. If you're already a sponsor and are interested in this feature, please leave a comment here so we can prioritize this issue accordingly.

We also welcome contributions from those willing to dedicate their time to implement this feature on a voluntary basis. Please see the Contributing Guide for more information.

[stanlog]

Hello @vitabaks thank you so much for this marvelous software, and all this work of automation with Ansible.

I don't know if it's the right place to put a wish list, but I realized a little lack last days when testing deployments : I can't import an existing cluster deployed through command line and Ansible into the UI (or I pass by this feature). Do you think it would be possible ? (even if I have to connect in bash in the container and launch several commands to do the job). I tried to deploy my cluster in the UI, adapted vars in Ansible automation files, and config / update cluster launching ansible-playbook commands, but it's not really simple, and not really do the job in some cases.

[vitabaks]

Hello @stanlog Thank you for your feedback and suggestion.

For the feature request to import an existing cluster into the Console, it’s better to create a separate issue so we can track and consider it for future development.

In the meantime, this can be done manually by adding the cluster data directly into the clusters and servers tables in the console database.

[stanlog]

For the feature request to import an existing cluster into the Console, it’s better to create a separate issue so we can track and consider it for future development.

Yes, I will create a dedicated issue to ask for this enhancement.

Thank you for the workaround to populate the database in the UI to import an existing cluster :)