Linux-tips

First we need to install postgresql:

sudo aptitude install postgresql

Then change the default password for the postgres user - replace password with your password:

sudo -u postgres psql -c "ALTER USER postgres WITH PASSWORD '<password>'"

Now we add a user *in this example username should be your system username - setting up non system users requires additional steps*:

sudo -u postgres createuser -D -A -P username

you will be promted to enter a password for the user

Then create a database for amarok *replace username with your sytem user name as above*:

sudo -u postgres createdb -O username amarok

Finally we configure amarok to use the database. If you are running amarok for the first time enter settings then using the username/password and amarok database just created. Set hostname to "localhost" and port to "5432". Otherwise from amarok goto settings, configure amarok, collection