Cloud Service Broker AWS Postgres Service throws Error: granting admin user access to binding user: pq: must have admin option on role

Products

• Cloud Services Products

Issue/Introduction

When you try to manage AWS Postgres Service, operations such unbind and delete AWS Postgres Service. This throws
 

Error: unbind could not be completed: Service broker failed to delete service binding for instance <PosgresServiceInstance>: Service broker error: unbind failed: Error: granting admin user access to binding user: pq: must have admin option on role "XXXXX" exit status 1

Environment

Product Version: Other

Resolution

The error due to incompatibility with CSB Broker and AWS postgres_version you are using. Check your plan configuration if you are using postgres_version set to 15. Please note as of the time of writing, CSB version 1.5.2 and prior, Postgres version 15 is not supported. This is also mentioned in our official docs below:

Amazon RDS for PostgreSQL

Amazon Aurora PostgreSQL-Compatible Edition

Please update postgres_version to a support version to resolve this issue

More info on how Cloud Service Broker are tested prior to release:

When we release a new broker version, it is tested against the AWS features at that particular point in time, and we cannot foresight what AWS will change in the future and how those changes will affect an already released broker.

The same will happen to any other broker or direct integration with the IaaS, so it is not a situation specific to the CSB or production use but a matter of integration with a 3rd party service that evolves.