CODEWITHSUNDEEP
djangopostgresqldjango-cms
Rajat Gupta
Rajat Gupta

Reputation: 1959

permission denied for relation django_migrations

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?

Upvotes: 7

Views: 10425

Answers (1)

markwalker_
markwalker_

Reputation: 12849

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.

Upvotes: 4

Related Questions