PostgreSQL database (Windows)¶
Note
Original author JA Cole
Get PostgreSQL and the python connector¶
- Download the installer from http://www.enterprisedb.com/products-services-training/pgdownload#windows
- Download psycopg2 from http://www.lfd.uci.edu/~gohlke/pythonlibs/. Make sure it matches your python and Windows version.
Install PostgreSQL¶
Run the the postgresql installer. It will ask for a location. Ensure the “data” directory is not under “Program Files” as this can cause permissions errors. Enter a superuser password when prompted. Make sure you keep this safe as you will need it.
Create a user and database¶
Open pgAdmin III
- Click on servers to expand
- Double click on PostgreSQL 9.4
- Enter your superuser password
- Right click on “login roles” and choose “New login role”
- Create the openremuser (or whatever you want your user to be called) and under definition add a password.
- Click OK
- Right click on databases and choose “New database”
- Name the database (openremdb is fine) and assign the the owner to the user you just created.
Install psycopg2¶
pip install psycopg2-2.6.1-cp27-cp27m-win32.whl
# or if you have the 64-bit version
pip install psycopg2-2.6.1-cp27-cp27m-win_amd64.whl
# adjusting the version number appropriately
If this is your initial install, you are now ready to install OpenREM, so go to the Installing OpenREM docs.
If you are replacing a SQLite test install with PostgreSQL, continue here.
Configure OpenREM to use the database¶
- Find and edit the settings file (notepad works fine). The path depends on your python install, but could be something like:
C:\lib\python2.7\site-packages\openrem\openremproject\local_settings.py
- Set the following (changing name, user and password as appropriate):
'ENGINE': 'django.db.backends.postgresql_psycopg2',
'NAME': 'openrem_db',
'USER': 'openremuser',
'PASSWORD': 'openrem_pw',