Postgresql is user friendly in the old fashioned way: it's just picky about it's friends. After getting postgresql up and running on my laptop, I can't say I love it more than before -- let's say, even less. Let me remind you that after installing mysql, you are up and running immediately, and if you use mysql for localhost only, having a single, passwordless root works fine.
But postgresql... first you change your Unix user to postgres, enter psql and run these: