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 @@ Deleting a tablespace -
+ leftLink="remote-postgres" leftLabel="Prev" + title="Chapter 7. Database +Management" + rightLink="install-next-nightly-vacuum" rightLabel="Next"> +

Deleting a tablespace

Skip down for instructions on Deleting a PostgreSQL tablespace.

@@ -16,20 +16,16 @@ 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 $OPENACS_SERVICE_NAME cascade;
+user and every database object the user owns.

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 'sid, serial#';
+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 '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 $OPENACS_SERVICE_NAME including contents cascade constraints;
+can also issue the following:

SVRMGR> drop tablespace $OPENACS_SERVICE_NAME including contents cascade constraints;
 

@@ -44,14 +40,13 @@ .

Then, to drop the db, just do:

 [$OPENACS_SERVICE_NAME ~]$ dropdb $OPENACS_SERVICE_NAME
 
-DROP DATABASE
-
+DROP DATABASE

- \ 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