[translate-pootle] error setting up a new pootle database on postgres 9.3.2

[Mark B. <ma...@mi...>]

Hey folks,

I'm setting up a new pootle server and ideally I'd like to use Postgres. I
love that pootle comes with a Fabric deploy file, so I'm trying to use that
as well.

The Fabric installer currently only supports mysql but I've added postgres
support for the CREATE DATABASE / DROP DATABASE statement, as that was
fairly easy :)

However, I'm now stuck at the 'manage.py setup' stage with a postgres error.
The actual error from Fabric is this unhelpful one:

django.db.utils.DatabaseError: current transaction is aborted, commands
ignored until end of transaction block

But digging into the postgres logs I found this error first:
14:30:54 UTC:172.31.21.93(57281):pootle@pootle:[18390]:ERROR:  relation
"django_site" does not exist at character 78
2014-03-10 14:30:54 UTC:172.31.21.93(57281):pootle@pootle:[18390]:STATEMENT:
 SELECT "django_site"."id", "django_site"."domain", "django_site"."name"
FROM "django_site" WHERE "django_site"."id" = 1
2014-03-10


To give you an idea of what I've done so far I've run
fab production bootstrap
fab production create_db
fab production update_config
fab production setup

Any thoughts? Is there another step for setting up a new server that I've
missed?

P.S. is there a mailing list archive around? I hate asking questions that
have already been answered...

Many thanks,

Mark