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
1. ALTER USER testuser WITH ENCRYPTED PASSWORD 'supergeheim';
2. Exit database management \q
3. Exit database user
exit
echo „local cmsms cmsms md5“ »pg_hba.conf (/etc/postgresql/8.1/main/pg_hba.conf in debian)
restart postgresql