================================================================================
Setting up the Database (PostgreSQL)
================================================================================

Installing the Database
================================================================================

GNU/Linux
--------------------------------------------------------------------------------

On Debian and Ubuntu, a simple ::

   #> apt-get install postgresql postgresql-client postgresql-contrib libpq-dev

Mac OS X
--------------------------------------------------------------------------------

To install postgres 8.3, you can use the one-click installer on the following
site : [[Postgresql 8.3 One-Click Installer |
http://www.postgresql.org/download/macosx]]

You can also follow the instruction on this site : [[Postgresql 8.3 MacPorts
installation |
http://shifteleven.com/articles/2008/03/21/installing-postgresql-on-leopard-using-macports]]

Microsoft Windows
--------------------------------------------------------------------------------


Configuring PostgreSQL
================================================================================

Make sure that you have set an UTF-8 locale/encoding (e.g. set
LANG=en_CA.UTF-8 environment variable). The postgresql cluster will be created
in the encoding which is currently set. Type locale in the term and you should
see something similar to the following::

    $> locale
    LANG=en_CA.UTF-8
    LC_CTYPE="en_CA.UTF-8"
    LC_NUMERIC="en_CA.UTF-8"
    LC_TIME="en_CA.UTF-8"
    LC_COLLATE="en_CA.UTF-8"
    LC_MONETARY="en_CA.UTF-8"
    LC_MESSAGES="en_CA.UTF-8"
    LC_PAPER="en_CA.UTF-8"
    LC_NAME="en_CA.UTF-8"
    LC_ADDRESS="en_CA.UTF-8"
    LC_TELEPHONE="en_CA.UTF-8"
    LC_MEASUREMENT="en_CA.UTF-8"
    LC_IDENTIFICATION="en_CA.UTF-8"
    LC_ALL=


**Creating a Database User and Changing Authentication Scheme**

For simplicity we create a database user "markus" with the same
password, to which superuser privileges will be granted. We will use this user
for MarkUs later. As root execute the following (be careful not to forget any
backslashes or single-/doublequotes)::

    #> sudo -u postgres psql postgres
    postgres=# \password postgres
    postgres=# create role markus createdb login password 'markus';
    postgres=# \q
    #> sudo psql -c "create user markus with superuser password 'markus';" postgres

The above command should output the following::

    CREATE ROLE

However if you keep getting the following everytime you try to enter your
password::

    #> su -c "psql -c \"create user markus with superuser password
    'markus';\""
    postgres Password:
    su: Authentication failure

You can run the following instead::

    #>sudo su
    Password:
    #> su -c "psql -c \"create user markus with superuser password
    'markus';\"" postgres
    CREATE ROLE

Finally, we need to change a line in the configuration file of the PostgreSQL
database. As root open "pg_hba.conf" (sometimes "pg_hdb.conf") in
``/etc/postgres/\<pg-version\>/main/``  or in
``/etc/postgresql/\<pg-version\>/main/`` and look for the following lines (the
first one is actually only a comment)::

    # "local" is for Unix domain socket connections only
    local   all         all                               peer

Now change the second line like so::

    local   all         all                               md5

Restart PostgresSQL in order to apply those configuration changes to the
server::

    #> /etc/init.d/postgresql restart

To test if everything went fine we try to connect to the "postgres" database
using our newly created user::

    #> psql postgres markus

You will be asked for a password, so type "markus". After that you
should see the console of PostgreSQL.

Install PostgreSQL (make sure that the created cluster is UTF-8 encoded; If not
required, it also works with latin-1)

Configuring MarkUs
--------------------------------------------------------------------------------

Setup the database.yml file, in the MarkUs' root directory:

* `ln -s config/database.yml.postgresql config/database.yml`

* in config/database.yml, make sure that "development:" and the 5 lines under it (adapter, encoding, database, username, password) are not commented out

* do the same for "test:" and the 5 lines under it to be able to run unit tests and functional tests

* change the usernames and password (in development and test) to the ones you used in the section above ('markus' if you copy/pasted the instructions)

Now go back to the MarkUs tutorial :

* Installation on GNU/Linux

  * [[Development environment|InstallationGnuLinux]]
  * [[Production environment|InstallProdStable]]
  * [[Old Stable (deprecated) environment|InstallProdOld]]

* Installation on Mac OS X

  * [[Development environment|InstallationMacOsX]]
  * Production (need to be done)

* Installation on Windows

  * [[Development environment|InstallationWindows]]