Create a Database and secure [[sysadmin:postgresql|PostgreSQL]]

  1. install postgresql
  2. su - postgres
  3. createuser testuser
  4. Create database
    • createdb test –encoding'utf8'= (if you like to have utf-8 encoding) or
    • createdb test
  5. Login into build in user table
  6. psql postgres
    1. ALTER USER testuser WITH ENCRYPTED PASSWORD 'supergeheim';
    2. Exit database management \q
    3. Exit database user
  7. exit
  8. echo „local cmsms cmsms md5“ »pg_hba.conf (/etc/postgresql/8.1/main/pg_hba.conf in debian)
  9. restart postgresql