Description:
The azure_ops_test_azure_manage_postgresql test in the CI pipeline is failing due to a server name conflict. The error message indicates that the specified server name, test-postgresql-server, already exists, causing the test to fail when attempting to create a new PostgreSQL server with the same name. But I don't see that this name was used before or resources weren't deleted.

Error Message:

Error creating the PostgreSQL Server instance: (ServerNameAlreadyExists) Specified server name 'test-postgresql-server' is already used. Please use a different name and try again. Code: ServerNameAlreadyExists Message: Specified server name 'test-postgresql-server' is already used. Please use a different name and try again.

Steps to Reproduce:

1. Run the azure_ops_test_azure_manage_postgresql test in the CI environment.
2. Observe that the test fails when attempting to create a PostgreSQL server with the name test-postgresql-server.

Expected Behavior:
The test should successfully create a PostgreSQL server with a unique name, allowing the CI process to proceed without name conflicts.

Actual Behavior:
The test fails because the server name test-postgresql-server is already in use. This prevents the creation of a new PostgreSQL server, causing the CI pipeline to report an error.

Additional Notes:
The failure also affects subsequent cleanup tasks as the PostgreSQL server creation did not complete successfully. This might leave residual resources in the CI environment.

Environment:

• CI Environment: Azure Cloud
• Resource Group: ci-testing

Links: Link for the failure - https://main-jenkins-csb-aap.apps.ocp-c1.prod.psi.redhat.com/job/AAPQA/job/Content/job/Cloud/job/Azure_ops/job/2.5_unreleased/job/azure_ops-2.5_unreleased-cloud-pipeline-0/8/testReport/