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.