Skip to content

Set up postgresql for production use

bendikro edited this page Aug 25, 2011 · 5 revisions

First you need to set up PostgreSQL e.g. like described here: https://help.ubuntu.com/community/PostgreSQL You'll now have a user "postgres" that'll have access to the database. Either log in as postgres (e.g. sudo su postgres), or run the following commands with "sudo -u postgres 'commands'"

Create a postgresql user

~$ createuser --echo --password --no-superuser --no-createrole --no-createdb devilryuser

Create the database

~$ createdb devilry

Update settings

Make sure DATABASES["default"] in settings/settings.py is configured for PostgreSQL, and that any other database config is commented out or removed.

Clone this wiki locally