尽管具有 root 权限，但由于权限问题无法进行 pg_dump

Question

我正在尝试运行这个命令

sudo pg_dump -U bm_clients -Z 9 -v baydb |aws s3 cp - s3://thebay.com/bay.dump.gz

输出如下：

pg_dump: reading extensions
pg_dump: identifying extension members
pg_dump: reading schemas
pg_dump: reading user-defined tables
pg_dump: [archiver (db)] query failed: ERROR:  permission denied for relation provider_seq
pg_dump: [archiver (db)] query was: LOCK TABLE londiste.provider_seq IN ACCESS SHARE MODE

当连接到数据库并检查权限时，我发现它是首席用户。

我也无法在 \dt 中找到 londiste。

我也跑过

GRANT ALL PRIVILEGES ON ALL TABLES IN SCHEMA public TO bm_clients;
GRANT