1. What is the nature and description of the request?

Enhance the Ansible Automation Platform (AAP) Operator to support PostgreSQL PVC size expansion through updates to the AutomationController custom resource.

1. Why does the customer need this? (List the business requirements here)

Customers routinely need to increase PostgreSQL storage as data grows. Currently, modifying the postgres_storage_requirements field in the AutomationController CR does not trigger a successful PVC expansion. The Operator attempts to update the underlying StatefulSet, which is not allowed for certain fields, resulting in reconciliation failures. This causes PostgreSQL pods to terminate and not return to a running state, making the environment unavailable.

Operator logs confirm this is not a supported operation today, and SMEs have stated that PVC resize support is not implemented in the current AAP Operator. Therefore, this request is an enhancement, not a defect.

For more details, please see https://issues.redhat.com/browse/AAP-48354

The only way is to change the size on the PVC and deleting the postgres pod and letting it recreate without adjusting the request size in the AutomationController object.

1. How would you like to achieve this? (List the functional requirements here)

Implement Operator logic to safely handle PVC expansion by:
Detecting storage size increases in postgres_storage_requirements.
Managing the necessary StatefulSet lifecycle (delete/recreate workflow where required).
Ensuring the PostgreSQL pods return cleanly after the resize.
Providing a fully supported, documented method for increasing PostgreSQL storage in AAP-managed deployments.

1. List any affected known dependencies: Doc, UI etc..
2. Github Link if any