permission denied for relation django_migrations

django postgresql django-cms
Rajat Gupta picture Rajat Gupta · Nov 23, 2015 · Viewed 8.1k times · Source

I am using Django CMS, I want to take backup of my database. But when I am firing the query to take my back of database:

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

After firing the query I am getting the following error:

pg_dump: [archiver (db)] query failed: ERROR: permission denied for relation django_migrations

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

Can anyone help me on this?

Answer

markwalker_ picture markwalker_ · Nov 28, 2015

Sounds like it's down to permissions, so make sure you at least have USAGE for relevant schema and the SELECT privilege for the table.

Check out this answer for much greater detail.

Related questions

DatabaseError: current transaction is aborted, commands ignored until end of transaction block?

I got a lot of errors with the message : "DatabaseError: current transaction is aborted, commands ignored until end of transaction block" after changed from python-psycopg to python-psycopg2 as Django project's database engine. The code remains the same, just don't know …

Read More
How to set up a PostgreSQL database in Django

I'm new to Python and Django. I'm configuring a Django project using a PostgreSQL database engine backend, But I'm getting errors on each database operation. For example when I run manage.py syncdb, I'm getting: C:\xampp\htdocs\djangodir>…

Read More
Error: No module named psycopg2.extensions

I am trying to set up a PostgreSQL database for my django project, which I believe I have done now thanks to the replies to my last question Problems setting up a postgreSQL database for a django project. I am …

Read More