search

AvalancheTheory / ava

0 stars 0 forks source link

Getting postgresql to work #4

Closed AvalancheTheory closed 9 years ago

AvalancheTheory commented 9 years ago

Installed postgresql. Became the postgresql user (sudo -i -u postgres). Had to become root in order to start/enable postgresql with systemd.

AvalancheTheory commented 9 years ago

changing settings to match: https://www.digitalocean.com/community/tutorials/how-to-install-and-configure-django-with-postgres-nginx-and-gunicorn not working

AvalancheTheory commented 9 years ago

Added psycopg2 to requirements. https://github.com/AvalancheTheory/ava/commit/ff837dbf63b5c7f92e463fd213c43c25faa3d68e

AvalancheTheory commented 9 years ago

https://docs.djangoproject.com/en/1.7/ref/databases/

AvalancheTheory commented 9 years ago

https://docs.djangoproject.com/en/1.7/ref/settings/

AvalancheTheory commented 9 years ago

Read through: https://wiki.postgresql.org/wiki/FAQ

AvalancheTheory commented 9 years ago

deleted the old database, which was named avaDatabase. Used the command 'createdb' to create a database that is for my user account.

AvalancheTheory commented 9 years ago

http://killtheyak.com/use-postgresql-with-django-flask/

Note the need to add the postgres binaries down at the very bottom

AvalancheTheory commented 9 years ago

didn't need to add the postgres binaries. see https://github.com/AvalancheTheory/ava/commit/4b4e4823d204116e3428ace9245dc45c1703c5e9 for correct settings.