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 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@…,