Geodatabase must be enabled as geodatabase admin user

Error Message

After making an AWS-RDS database connection to ArcGIS Pro, the Enable Enterprise Geodatabase tool fails, and returns the following errors:

Geodatabase must be enabled as geodatabase admin user.
Failed to execute (EnableEnterpriseGeodatabase).

Cause

• All privileges were not assigned to the database and PostGIS extensions were not enabled.
• For PostgreSQL-based cloud database-as-a-service instances, PostGIS is required in the instance before you enable a geodatabase. ST_Geometry is not supported in database services.

Solution or Workaround

When creating an RDS for a PostgreSQL DB instance using the AWS Management Console, an administrator account is created at the same time. By default, its name is postgres. Follow the below steps to grant all the privileges and add an extension - PostGIS.

1. Open pgAdmin 4.
2. Connect to the AWS-RDS-managed server from the server group.
3. Create a new database (for example, s1) in pgAdmin.
4. In the SQL tool console run the below commands:

CREATE ROLE sde LOGIN PASSWORD 'Pass@123'
GRANT rds_superuser TO sde
GRANT ALL PRIVILEGES ON DATABASE s1 TO sde;
CREATE SCHEMA sde AUTHORIZATION sde;
CREATE EXTENSION postgis;

After granting the necessary privileges and adding the PostGIS extension to the database, connect to it using the SDE user in ArcGIS Pro, and enable the enterprise geodatabase.