Index: openacs-4/packages/acs-core-docs/www/install-openacs-delete-tablespace.adp
===================================================================
RCS file: /usr/local/cvsroot/openacs-4/packages/acs-core-docs/www/install-openacs-delete-tablespace.adp,v
diff -u -N -r1.3 -r1.4
--- openacs-4/packages/acs-core-docs/www/install-openacs-delete-tablespace.adp 8 Nov 2017 09:42:11 -0000 1.3
+++ openacs-4/packages/acs-core-docs/www/install-openacs-delete-tablespace.adp 25 Apr 2018 08:38:27 -0000 1.4
@@ -3,11 +3,11 @@
Skip down for instructions on Deleting a PostgreSQL
tablespace. Should it become necessary to rebuild a tablespace from scratch,
you can use the drop user
command in SVRMGRL with the cascade
option. This command will drop the
-user and every database object the user owns.
-SVRMGR>
drop user
+user and every database object the user owns.$OPENACS_SERVICE_NAME
cascade;
SVRMGR> drop user $OPENACS_SERVICE_NAME
cascade;
If this does not work because svrmgrl "cannot drop a user that is currently connected", make sure to kill the AOLserver -using this user. If it still does not work, do:
-SVRMGR> select username, sid, serial# from v$session where lower(username)='$OPENACS_SERVICE_NAME
';
-
and then
-SVRMGR>alter system kill session '
+using this user. If it still does not work, do:sid, serial#
';SVRMGR>select username, sid, serial# from v$session where lower(username)='
+$OPENACS_SERVICE_NAME
';and then
SVRMGR>alter system kill session '
sid, serial#
';where sid and serial# are replaced with the corresponding values for the open session.
Use with caution!
If you feel the need to delete everything related to the service, you -can also issue the following:
-SVRMGR>drop tablespace
+can also issue the following:$OPENACS_SERVICE_NAME
including contents cascade constraints;SVRMGR>drop tablespace
$OPENACS_SERVICE_NAME
including contents cascade constraints;@@ -44,14 +40,13 @@ .
Then, to drop the db, just do:
[$OPENACS_SERVICE_NAME ~]$+DROP DATABASEdropdb
-DROP DATABASE -$OPENACS_SERVICE_NAME
- \ No newline at end of file + rightLink="install-next-nightly-vacuum" rightLabel="Next" rightTitle="Vacuum Postgres nightly" + homeLink="index" homeLabel="Home" + upLink="database-management" upLabel="Up"> + \ No newline at end of file