django migration error: django.db.utils.ProgrammingError: must be owner of relation account_userprofile

[Samuel Muiruri]

getting this error when I'm running migrate, to note this is likely related to the db connection I believe

(revampenv) sammy@samuel-pc:~/revamp$ python manage.py migrate

Operations to perform:

  Apply all migrations: account, sessions, admin, auth, thumbnail, contenttypes, gallery

Running migrations:

  Rendering model states... DONE

  Applying account.0003_userprofile_bio...Traceback (most recent call last):

  File "manage.py", line 10, in <module>

    execute_from_command_line(sys.argv)

  File "/home/sammy/revamp/revampenv/local/lib/python2.7/site-packages/django/core/management/__init__.py", line 353, in execute_from_command_line

    utility.execute()

  File "/home/sammy/revamp/revampenv/local/lib/python2.7/site-packages/django/core/management/__init__.py", line 345, in execute

    self.fetch_command(subcommand).run_from_argv(self.argv)

  File "/home/sammy/revamp/revampenv/local/lib/python2.7/site-packages/django/core/management/base.py", line 348, in run_from_argv

    self.execute(*args, **cmd_options)

  File "/home/sammy/revamp/revampenv/local/lib/python2.7/site-packages/django/core/management/base.py", line 399, in execute

    output = self.handle(*args, **options)

  File "/home/sammy/revamp/revampenv/local/lib/python2.7/site-packages/django/core/management/commands/migrate.py", line 200, in handle

    executor.migrate(targets, plan, fake=fake, fake_initial=fake_initial)

  File "/home/sammy/revamp/revampenv/local/lib/python2.7/site-packages/django/db/migrations/executor.py", line 92, in migrate

    self._migrate_all_forwards(plan, full_plan, fake=fake, fake_initial=fake_initial)

  File "/home/sammy/revamp/revampenv/local/lib/python2.7/site-packages/django/db/migrations/executor.py", line 121, in _migrate_all_forwards

    state = self.apply_migration(state, migration, fake=fake, fake_initial=fake_initial)

  File "/home/sammy/revamp/revampenv/local/lib/python2.7/site-packages/django/db/migrations/executor.py", line 198, in apply_migration

    state = migration.apply(state, schema_editor)

  File "/home/sammy/revamp/revampenv/local/lib/python2.7/site-packages/django/db/migrations/migration.py", line 123, in apply

    operation.database_forwards(self.app_label, schema_editor, old_state, project_state)

  File "/home/sammy/revamp/revampenv/local/lib/python2.7/site-packages/django/db/migrations/operations/fields.py", line 62, in database_forwards

    field,

  File "/home/sammy/revamp/revampenv/local/lib/python2.7/site-packages/django/db/backends/postgresql/schema.py", line 21, in add_field

    super(DatabaseSchemaEditor, self).add_field(model, field)

  File "/home/sammy/revamp/revampenv/local/lib/python2.7/site-packages/django/db/backends/base/schema.py", line 396, in add_field

    self.execute(sql, params)

  File "/home/sammy/revamp/revampenv/local/lib/python2.7/site-packages/django/db/backends/base/schema.py", line 110, in execute

    cursor.execute(sql, params)

  File "/home/sammy/revamp/revampenv/local/lib/python2.7/site-packages/django/db/backends/utils.py", line 64, in execute

    return self.cursor.execute(sql, params)

  File "/home/sammy/revamp/revampenv/local/lib/python2.7/site-packages/django/db/utils.py", line 95, in __exit__

    six.reraise(dj_exc_type, dj_exc_value, traceback)

  File "/home/sammy/revamp/revampenv/local/lib/python2.7/site-packages/django/db/backends/utils.py", line 64, in execute

    return self.cursor.execute(sql, params)

[James Schneider]

On Aug 28, 2017 6:44 PM, "Samuel Muiruri" <muiruri...@gmail.com> wrote:

getting this error when I'm running migrate, to note this is likely related to the db connection I believe

<snip>

/revamp/revampenv/local/lib/python2.7/site-packages/django/db/utils.py", line 95, in __exit__

    six.reraise(dj_exc_type, dj_exc_value, traceback)

  File "/home/sammy/revamp/revampenv/local/lib/python2.7/site-packages/django/db/backends/utils.py", line 64, in execute

    return self.cursor.execute(sql, params)

It probably is. What is the actual exception? Looks like it was cut off when pasted.

-James