Create a Database and secure 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