sudo -u goblinartists ./bin/gmg dbupdate returns sqlalchemy.exc.ProgrammingError: (ProgrammingError) exception

[Jorge Araya Navarro]

I'm trying to deploy Postgres in my mediagoblin instance, but I have this problem.

[shackra@abrilhost mediagoblin]$ sudo -u goblinartists ./bin/gmg dbupdate
** Message: pygobject_register_sinkfunc is deprecated (GstObject)
/srv/http/goblinartists.net/mediagoblin/lib/python2.7/site-packages/SQLAlchemy-0.7.6-py2.7-linux-x86_64.egg/sqlalchemy/engine/default.py:473: SAWarning: Unicode type received non-unicode bind param value.
Traceback (most recent call last):
  File "./bin/gmg", line 8, in <module>
    load_entry_point('mediagoblin==0.3.0.dev', 'console_scripts', 'gmg')()
  File "/srv/http/goblinartists.net/mediagoblin/mediagoblin/gmg_commands/__init__.py", line 100, in main_cli
    args.func(args)
  File "/srv/http/goblinartists.net/mediagoblin/mediagoblin/gmg_commands/dbupdate.py", line 93, in dbupdate
    run_dbupdate(app_config)
  File "/srv/http/goblinartists.net/mediagoblin/mediagoblin/gmg_commands/dbupdate.py", line 88, in run_dbupdate
    migration_manager.init_or_migrate()
  File "/srv/http/goblinartists.net/mediagoblin/mediagoblin/db/sql/util.py", line 196, in init_or_migrate
    migration_number = self.database_current_migration
  File "/srv/http/goblinartists.net/mediagoblin/mediagoblin/db/sql/util.py", line 104, in database_current_migration
    if self.migration_data is None:
  File "/srv/http/goblinartists.net/mediagoblin/mediagoblin/db/sql/util.py", line 80, in migration_data
    self.migration_model).filter_by(name=self.name).first()
  File "build/bdist.linux-x86_64/egg/sqlalchemy/orm/query.py", line 2107, in first
  File "build/bdist.linux-x86_64/egg/sqlalchemy/orm/query.py", line 2001, in __getitem__
  File "build/bdist.linux-x86_64/egg/sqlalchemy/orm/query.py", line 2176, in __iter__
  File "build/bdist.linux-x86_64/egg/sqlalchemy/orm/query.py", line 2191, in _execute_and_instances
  File "build/bdist.linux-x86_64/egg/sqlalchemy/engine/base.py", line 1450, in execute
  File "build/bdist.linux-x86_64/egg/sqlalchemy/engine/base.py", line 1583, in _execute_clauseelement
  File "build/bdist.linux-x86_64/egg/sqlalchemy/engine/base.py", line 1697, in _execute_context
  File "build/bdist.linux-x86_64/egg/sqlalchemy/engine/base.py", line 1690, in _execute_context
  File "build/bdist.linux-x86_64/egg/sqlalchemy/engine/default.py", line 335, in do_execute
sqlalchemy.exc.ProgrammingError: (ProgrammingError) permission denied for relation core__migrations
 'SELECT core__migrations.name AS core__migrations_name, core__migrations.version AS core__migrations_version \nFROM core__migrations \nWHERE core__migrations.name = %(name_1)s \n LIMIT %(param_1)s' {'name_1': '__main__', 'param_1': 1}
[shackra@abrilhost mediagoblin]$

this could be a bug?

[Jorge Araya Navarro]

oh, btw, I change the permissions before running the command and psql said "GRANT".

[Jorge Araya Navarro]

just be careful and create everything (database and schemas) under the same user which is going to run the MediaGoblin instance