AWS RDS Postgres error while taking the dump

Question

When I try to take PostgresDump (AWS RDS) the following error I am getting:

ERROR:  permission denied for relation dms_stats_detailed
pg_dump: error: query was: LOCK TABLE table_name IN ACCESS SHARE MODE

I am having admin permission though (with Master User).

Answer 1

You need to run pg_dump with a database user (the -U option) that has permission to read the tables you are dumping.