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:
CREATE ROLE drupal WITH LOGIN SUPERUSER;
ALTER ROLE drupal WITH PASSWORD 'drupal';
GRANT all ON DATABASE drupal TO drupal;
and then edit a pg_hba.conf . The place of this file is almost never specified, I checked many guides. Of course there are so many Linux distributions, this is impossible... WRONG! There are Debian/Ubuntu, RHEL/Centos, Gentoo -- finished. Surely it's too big a work for the documentation of the Elitest Database in the World to cover these three. Anyways, under Ubuntu peeking into the /etc/init.d/postgresql-8.1 script reveals "Setting environment variables for the postmaster here does not work; please set them in /etc/postgresql/8.1/
Commenting on this Story is closed.