0

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
shubhendu
  • 101
  • 1
  • 3
  • This `londiste` looks like a schema, not a table, so list your schemas with `\dn` and grant privileges for each schema as you did with schema `public`. – tbielaszewski Nov 21 '20 at 00:10

0 Answers0