[rhmessaging-commits] rhmessaging commits: r3517 - mgmt/trunk/mint/bin.
Author: justi9
Date: 2009-07-22 14:51:08 -0400 (Wed, 22 Jul 2009)
New Revision: 3517
Added:
mgmt/trunk/mint/bin/mint-database
Log:
A new tool for administering mint's postgresql database
Copied: mgmt/trunk/mint/bin/mint-database (from rev 3516,
mgmt/trunk/cumin/bin/cumin-database-destroy)
===================================================================
--- mgmt/trunk/mint/bin/mint-database (rev 0)
+++ mgmt/trunk/mint/bin/mint-database 2009-07-22 18:51:08 UTC (rev 3517)
@@ -0,0 +1,63 @@
+#!/bin/bash -e
+
+if [[ "$EUID" != "0" ]]; then
+ echo "This script must be run as root"
+ exit 2
+fi
+
+function check-basics {
+ # Is it installed?
+ # Is it initialized?
+ # Is it running?
+
+ which rpm > /dev/null
+ rpm -q postgresql-server
+
+ test -d /var/lib/pgsql/data || {
+ echo "The database is not initialized; run '/sbin/service postgresql
start'"
+ exit 1
+ }
+
+ /sbin/service postgresql status || {
+ echo "The database is not running; run '/sbin/service postgresql
start'"
+ exit 1
+ }
+}
+
+case "$1" in
+ check)
+ check-basics
+
+ # Is it configured to be accessible?
+ # Is it accessible?
+ # Does it have a schema loaded?
+
+ su - postgres -c "psql -c '\q'" || {
+ echo "The database is not accessible"
+ exit 1
+ }
+
+ echo "The database is ready"
+ ;;
+ create)
+ check-basics
+ su - postgres -c "createuser --superuser cumin || :"
+ su - postgres -c "createdb --owner=cumin cumin || :"
+ echo "The database is created"
+ ;;
+ destroy)
+ check-basics
+ su - postgres -c "dropdb cumin || :"
+ su - postgres -c "dropuser cumin || :"
+ echo "The database is destroyed"
+ ;;
+ *)
+ echo "Configure and check the mint database"
+ echo "Usage: mint-database COMMAND"
+ echo "Commands:"
+ echo " check Check the database"
+ echo " create Create the mint user and database"
+ echo " destroy Discard the mint user, database, and all data"
+ exit 1
+ ;;
+esac