Index: openacs-4/packages/acs-core-docs/www/xml/install-guide/openacs.xml =================================================================== RCS file: /usr/local/cvsroot/openacs-4/packages/acs-core-docs/www/xml/install-guide/openacs.xml,v diff -u -r1.21.2.7 -r1.21.2.8 --- openacs-4/packages/acs-core-docs/www/xml/install-guide/openacs.xml 16 Feb 2005 10:03:26 -0000 1.21.2.7 +++ openacs-4/packages/acs-core-docs/www/xml/install-guide/openacs.xml 19 Feb 2005 04:11:09 -0000 1.21.2.8 @@ -330,13 +330,13 @@ [root root]# - Create a database with the same name as our service name, $OPENACS_SERVICE_NAME. - [root root]# su - postgres -[postgres pgsql]$ createdb -E UNICODE -U $OPENACS_SERVICE_NAME $OPENACS_SERVICE_NAME + Create a database with the same name as our service name, $OPENACS_SERVICE_NAME. The full pathname for createdb needs to be used, since the pgsql directory has not been added to the $OPENACS_SERVICE_NAME bash profile. + [root root]# su - $OPENACS_SERVICE_NAME +[$OPENACS_SERVICE_NAME $OPENACS_SERVICE_NAME]$ /usr/local/pgsql/bin/createdb -E UNICODE $OPENACS_SERVICE_NAME CREATE DATABASE -[postgres pgsql]$ -su - postgres -createdb -E UNICODE -U $OPENACS_SERVICE_NAME $OPENACS_SERVICE_NAME +[$OPENACS_SERVICE_NAME $OPENACS_SERVICE_NAME]$ +su - $OPENACS_SERVICE_NAME +/usr/local/pgsql/bin/createdb -E UNICODE $OPENACS_SERVICE_NAME Automate daily database Vacuuming. This is a process which cleans out discarded data from the database. A quick way to automate vacuuming is to edit the cron file for the database user. Recommended: VACUUM ANALYZE every hour and VACUUM FULL ANALYZE every day.