====== Create a Database and secure [[sysadmin:postgresql|PostgreSQL]] ======
  - install postgresql
  - ''su - postgres''
  - ''createuser testuser''
  - Create database
    * ''createdb test --encoding'''utf8'= (if you like to have utf-8 encoding) or
    * ''createdb test''
  - Login into build in user table
  - ''psql postgres''
    - ''ALTER USER testuser WITH ENCRYPTED PASSWORD 'supergeheim';''
    - Exit database management ''\q''
    - Exit database user
  - exit
  - ''echo "local cmsms cmsms md5" >>pg_hba.conf'' (''/etc/postgresql/8.1/main/pg_hba.conf'' in debian)
  - restart postgresql