Using Postgresql with Spine

root@spine.sourceforge.net:/tmp/Spine-1.1$ su - postgres
postgres@spine.sourceforge.net:~1$ cd /tmp/Spine-1.1
postgres@spine.sourceforge.net:/tmp/Spine-1.1# createdb $database
CREATE DATABASE
postgres@spine.sourceforge.net:/tmp/Spine-1.1# psql $database < /tmp/Spine-1.1/psql-struct.sql
...

postgres@spine.sourceforge.net:/tmp/Spine-1.1# psql $database < /tmp/Spine-1.1/mysql3-data.sql
...

postgres@spine.sourceforge.net:/tmp/Spine-1.1# createuser -D -A -E -P $username
Enter password for new user:
Enter it again:
CREATE USER
postgres@spine.sourceforge.net:/tmp/Spine-1.1#

postgres@spine.sourceforge.net:/tmp/Spine-1.1# perl -e'for(qw(adminaccess attribute content macro message \r
messagegroup navbarbuttons navbars revision session statistics style usergroup users wiki)) \r
{ print "GRANT ALL ON $_ to $ARGV[0];
GRANT ALL ON ".$_."_id_seq to $ARGV[0];
" }' $username | psql $database

The following variables are used:

• $database : The database name. This value is used in the httpd.conf 'dbname' value.
• $username : The username. This value is used in the httpd.conf 'dbuser' value.
• $password : The password. This value is used in the httpd.conf 'dbpwd' value.