Autodesk / Autodesk/pgbelt

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

Open
#83 1 comment 0 reactions 1 assignee Claimed by @vjeeva View on GitHub
Dominant language
Python
Stars
22
Forks
8
PR merge metrics
No merged PRs in 30d

Description

**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.

Contributor guide

Open the contributing guide

Assessment

This issue has not been assessed yet.

Get new issues in your inbox

A short digest of beginner-friendly GitHub issues.