Error pg_dump: [archiver (db)]: ERROR: permission denied for abouts relationship

Question

I am trying to reset my pg db but got these errors, suggest

pg_dump: [archiver (db)] query failed: ERROR:  permission denied for relation abouts
pg_dump: [archiver (db)] query was: LOCK TABLE public.abouts IN ACCESS SHARE MODE

Answer 1

This can be a common mistake when using ROLE(a user) who could not open objects to reset them.

As before, you can provide the specific schema that you want to reset, or even use attribute ROLEc SUPERUSER.

, , AWS/RDS, SUPERUSER, , , , .

https://www.postgresql.org/docs/current/static/sql-grant.html , GRANT , , . pg_dumpall, , ROLES.

Answer 2

, pg_dump, .

, :

GRANT USAGE ON SCHEMA public TO <user>;
GRANT SELECT ON ALL TABLES IN SCHEMA public TO <user>;