id	summary	reporter	owner	description	type	status	priority	milestone	component	resolution	keywords	cc	parents
428	sudo -u goblinartists ./bin/gmg dbupdate returns sqlalchemy.exc.ProgrammingError: (ProgrammingError) exception	Jorge Araya Navarro	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?"	defect	closed	critical		component1	invalid	postgres, sqlalchemy	jorgean@…