title: After a PostgreSQL restore, I get "permission denied for relation django_session"
body: <p>I'm currently running my Django 1.1.1 site with PostgreSQL 8.4.2 both on the live server and locally.  When I try to restore one of my backup from the live server on my local box, I get the following error while accessing my site locally(<a href="http://localhost:8000" rel="nofollow noreferrer">http://localhost:8000</a>):</p>
  
  <pre><code>Exception Type: ProgrammingError at /
  Exception Value: permission denied for relation django_session
  </code></pre>
  
  <p>I also get a similar error while accessing all the contents of one of my models:</p>
  
  <pre><code>$ python manage.py shell
  Python 2.6.4 (r264:75706, Dec  7 2009, 18:45:15) 
  [GCC 4.4.1] on linux2
  Type "help", "copyright", "credits" or "license" for more information.
  (InteractiveConsole)
  &gt;&gt;&gt; from myapp.models import MyModel
  &gt;&gt;&gt; MyModel.objects.all()
  ...
  ProgrammingError: permission denied for relation myapp_mymodel
  </code></pre>
  
  <p>I used <code>pg_dump</code> for backup on the live server and dropping my local db followed by <code>psql dbname &lt; infile</code> for restore. Does anyone know what's wrong?</p>