Hello,

Amarok was getting pretty slow with SQLite on my system (Fedora Core 5), so I thought I would try one of the other databases.  Unfortunately, I think the postgresql howto is lacking.

I installed postgresql and postgresql-server via Yum, and started the postgresql service.  I then did
su - postgres
although this only worked from root for some reason.  I created a new username and password identical to my Linux user account.  I then did
createdb amarokcollection
as in the howto.  Thus,
psql amarokcollection
brings up the psql terminal without any error messages, from my user account.

I then configured amarok to use Postgresql with hostname localhost, database amarokcollection, port 5432, and the appropriate username and group.  Amarok just keeps coming up with the "FATAL: Ident authenication failed for user " message.

What am I doing wrong?

All right, I found http://www.flmnh.ufl.edu/linux/install_postgresql.htm and http://www.postgresql.org/docs/7.1/stat ... -psql.html and now realize that I should in fact be testing postgresql with
psql -h localhost amarokcollection
which does indeed return the message
psql: FATAL:  Ident authentication failed for user "group"

Modifying all three local lines of var/lib/pgsql/data/pg_hba.conf to use trust instead of ident and restarting postgresql appears to make it go.  (I don't know if this is particularly safe, but there's really only one user on this computer and I'm using Firestarter, and it's not like my music collection is sensitive data.)

I would add this information to the wiki, but I still don't really know what I'm doing here.