Postgresql as Backend

[jimcooncat]

'sudo aptitude install drupal', after I already had apache, php4, and postgresql installed, didn't create the drupal user or drupal database in Postgresql.

'sudo dpkg-reconfigure drupal' threw up a nice curses interface, but it didn't do the job either.

I don't know about packaging. I did get the setup to work, and have documented the workaround: http://ubuntuforums.org/showthread.php?t=52264

Some things I noticed:

You have to su - postgres before creating a new user, database, or language.

The /usr/share/drupal/database/database.pgsql, which holds the postgresql commands to create the tables. At the top of the it says it's an include file, so maybe it seems buggy because I used it out of context(?):

 - does not create the drupal user or database, so apparently isn't run as the postgres user to do this part of the job.

 - has CREATE FUNCTION statements which require the loading of plpgsql language.

 - has the two commands to load the plpgsql language tacked onto the end of the file, perhaps they need to be defined earlier?

 - needs those last two commands to be run as the postgres user.

[jimcooncat (jimcooncat)]

Oh yeah, the /usr/share/drupal/database/database.pgsql mentions Debian Bug #242572, which tacks the two language commands on the end. Probably has nothing to do with the problem, but I thought I'd mention it. Details at:
http://lists.drupal.org/archives/drupal-devel/2004-05/msg00569.html