Running Transifex with PostgreSQL on Fedora

Steps with sudo command configured to the current user:

$ sudo yum install postgresql-server python-psycopg2

$ sudo service postgresql initdb
Initializing database: [ OK ]

$ sudo service postgresql start
Starting postgresql service: [ OK ]

$ sudo su – postgres

-bash-4.0$ psql

postgres=# CREATE USER transifex WITH PASSWORD ‘transifex’;
CREATE ROLE

postgres=# CREATE DATABASE transifex OWNER transifex;
CREATE DATABASE

postgres=# \q

-bash-4.0$ exit

$ sudo vim /var/lib/pgsql/data/pg_hba.conf

# “local” is for Unix domain socket connections only
local transifex transifex password # Add this line
local all all ident

$ sudo service postgresql restart

$ psql transifex transifex
Password for user transifex:
psql (8.4.1)
Type “help” for help.

transifex=>

transifex=> \q

# Bellow it assumes the Tx code is under ~/workspace/mainline/ and
# all the dependencies are installed. http://docs.transifex.org/intro/install.html

$ cd workspace/mainline/transifex/

$ vim settings/21-engines.conf

# Database configuration
DATABASE_ENGINE = ‘postgresql_psycopg2′
DATABASE_NAME = ‘transifex’
DATABASE_USER = ‘transifex’
DATABASE_PASSWORD = ‘transifex’

$ ./manage.py syncdb

$ ./manage.py migrate codebases # It shouldn’t be necessary :/

$ ./manage.py migrate

$ ./manage.py loaddata txcommon/fixtures/*

$ ./manage.py runserver 8080

That’s it!