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

Projects

No projects

Milestone

No milestone

Relationships

None yet

Development

No branches or pull requests

Issue actions