Database Management

+Database Management

Prev	Chapter�7.�Maintenance	Next

Database Management

by Joel Aufrecht
OpenACS docs are written by the named authors, but may be edited by OpenACS documentation staff. @@ -10,26 +10,26 @@ in SVRMGRL with the cascade option. This command will drop the user and every database object the user owns.

-SVRMGR> drop user server0 cascade;

+SVRMGR> drop user service0 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)='server0';

and then

+SVRMGR> select username, sid, serial# from v$session where lower(username)='service0';

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 server0 including contents cascade constraints;

Deleting a PostgreSQL tablespace

+SVRMGR> drop tablespace service0 including contents cascade constraints;

Deleting a PostgreSQL tablespace

Dropping a PostgreSQL tablespace is easy. You have to stop any AOLserver instances that are using the database that you wish to drop. If you're using daemontools, this is simple, just use the 'down' flag (-d). If you're using inittab, you have to comment out your server in /etc/inittab, reread the inittab with /sbin/init q, and then restart-aolserver - server0.

Then, to drop the db, just do:

-server0:~$ dropdb server0 + service0.

Then, to drop the db, just do:

+service0:~$ dropdb service0
 DROP DATABASE

Vacuum Postgres nightly

The "vacuum" command must be run periodically to reclaim space. The "vacuum analyze" form additionally collects statistics on the @@ -46,4 +46,4 @@

Edit your crontab:

 joeuser:~$ crontab -e

We'll set vacuum up to run nightly at 1 AM. Add the following line:

-0 1 * * * /usr/local/pgsql/bin/vacuumdb birdnotes

($Id$)

Prev	Home	Next
Chapter�7.�Maintenance	Up	Backup and Recovery

rmello at fslc.usu.edu

vinod@kurup.com

View comments on this page at openacs.org +0 1 * * * /usr/local/pgsql/bin/vacuumdb birdnotes