Permission denied for django_migrations relation

Question

I am using Django CMS, I want to backup my database. But when I run the query to pick up my database:

pg_dump -U postgres -h 127.0.0.1 -p 5432 db_name > db_name_backup.sql

After running the request, I get the following error:

pg_dump: request [archiver (db)] failed: ERROR: rejection allowed for django_migrations relation

pg_dump: [archiver (db)] the request was: LOCK TABLE public.django_migrations IN ACCESS ACCESS MODE

Can someone help me with this?

Answer 1

It seems like this is up to permissions, so make sure you have the USAGEappropriate schema and privileges SELECTfor the table.

.