A recent commit [1] introduced an error in the postgresql configuration. The docs say:

# su -u postgres

but this doesn't work as -u is not a valid switch to su (at least not my system and not on the system of ramsesHD who pointed this out to me on IRC). It seems the correct syntax should be

# su - postgres

[1] ​https://gitorious.org/mediagoblin/mediagoblin/commit/c3075e9178a073586f5b2eb0a91e822398e6abf1

On ​https://gitorious.org/mediagoblin/mediagoblin/ is a big orange box saying:

System notice: Gitorious is being acquired by GitLab and gitorious.org will shut down end of May. Please import your repositories to GitLab.com

You should migrate somewhere before it's too late.

A member of my instance created a blog entry and then tried to delete his account, resulting in this error in my logs.

IntegrityError: (IntegrityError) update or delete on table "core__users" violates foreign key constraint "mediatype__blogs_author_fkey" on table "mediatype__blogs"
DETAIL:  Key (id)=(23284) is still referenced from table "mediatype__blogs".
 'DELETE FROM core__users WHERE core__users.id = %(id)s' {'id': 23284}