CODEWITHSUNDEEP
postgresqlpg-dump
shubhendu
shubhendu

Reputation: 351

Not able to pg_dump due to permission, despite having permissions

I am trying to run this command

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

The output is as follows:

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

While connecting to database and checking the permission I find it as chief user.

I am also not able to find londiste in the \dt.

I also have run

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

Upvotes: 1

Views: 364

Answers (1)

Laurenz Albe
Laurenz Albe

Reputation: 246308

You need the USAGE privilege on schema londiste and the SELECT privilege on londiste.provider_seq.

Upvotes: 1

Related Questions