One way of running paste and the celery worker is to use supervisord, it would be nice to include and example in the code or the doc

In the ​Considerations for Production Deployments, there are a few distribution specific init scripts mentionned. Here's a more cross-system one, using Supervisor, a process control system. On Debian, it's more reliable than ​joar's MediaGoblin init scripts, as it doesn't fail at restarting them.

I suggest to add the following "init method" for Debian in the documentation mentionned above.

The Paster FCGI server supervisor file, with MediaGoblin's documentation paths.

[program:mediagoblin-paster]
command = /srv/mediagoblin.example.org/mediagoblin/bin/paster serve /srv/mediagoblin.example.org/mediagoblin/paste_local.ini --server-name=fcgi fcgi_host=127.0.0.1 fcgi_port=26543
directory = /srv/mediagoblin.example.org/mediagoblin
user = mediagoblin
autostart = true
autorestart = true
stdout_logfile = /var/log/supervisor/mediagoblin-paster.log
stderr_logfile = /var/log/supervisor/mediagoblin-paster_err.log
environment = CELERY_ALWAYS_EAGER=false

The Celery task processor supervisor file, with MediaGoblin's documentation paths.

[program:mediagoblin-celeryd]
command = /srv/mediagoblin.example.org/mediagoblin/bin/celeryd
directory = /srv/mediagoblin.example.org/mediagoblin
user = mediagoblin
autostart = true
autorestart = true
stdout_logfile = /var/log/supervisor/mediagoblin-celeryd.log
stderr_logfile = /var/log/supervisor/mediagoblin-celeryd_err.log
environment = CELERY_CONFIG_MODULE="mediagoblin.init.celery.from_celery"

I'm not a supervisor-guru, I just followed these ​Section Values in supervisor's configuration documentation, so anyone is free to improve it, of course !

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?