Skip to content

Cleanup command fails to drop pglogical role due to privileges on view pg_stat_statements #83

@vjeeva

Description

@vjeeva

Describe the bug
PgBelt fails to drop the pglogical role when running belt teardown --full with the following error:

ERROR:  role "pglogical" cannot be dropped because some objects depend on it
DETAIL:  privileges for view pg_stat_statements

Expected behavior
The teardown command runs without errors and doesn't stop in the middle.

Additional context
This happened with a Postgres 12 RDS database.

Metadata

Metadata

Assignees

Labels

No labels
No labels

Type

No type
No fields configured for issues without a type.

Projects

No projects

Milestone

No milestone

Relationships

None yet

Development

No branches or pull requests

Issue actions