Django: permission denied when trying to access database after restore (migration)
It turns out that you should grant explicit ownership of all objects in the database to the owner after restore. The owner is not a superuser. It’s not enough to only set the owner at database creation time. The final solution for migration goes like this: on the client: pg_dump -f dump.sql -Ox database on …