From 9f07f8f40f787037f393a727ecf51d5883dbf7ca Mon Sep 17 00:00:00 2001 From: "Thomas G. Lockhart" Date: Sat, 14 Nov 1998 01:58:15 +0000 Subject: [PATCH] Add "vacuumdb" utility to make it easier to clean databases. Also supports the "analyze" mode, with or without specifying tables and columns. --- src/bin/vacuumdb/Makefile | 24 ++++++++++ src/bin/vacuumdb/vacuumdb | 98 +++++++++++++++++++++++++++++++++++++++ 2 files changed, 122 insertions(+) create mode 100644 src/bin/vacuumdb/Makefile create mode 100644 src/bin/vacuumdb/vacuumdb diff --git a/src/bin/vacuumdb/Makefile b/src/bin/vacuumdb/Makefile new file mode 100644 index 0000000000..98ab129e89 --- /dev/null +++ b/src/bin/vacuumdb/Makefile @@ -0,0 +1,24 @@ +#------------------------------------------------------------------------- +# +# Makefile-- +# Makefile for bin/vacuumdb +# +# Copyright (c) 1994, Regents of the University of California +# +# +# IDENTIFICATION +# $Header: /cvsroot/pgsql/src/bin/vacuumdb/Attic/Makefile,v 1.1 1998/11/14 01:58:14 thomas Exp $ +# +#------------------------------------------------------------------------- + +SRCDIR= ../.. +include ../../Makefile.global + +all: vacuumdb + +install: vacuumdb + $(INSTALL) $(INSTL_EXE_OPTS) $< $(BINDIR)/$< + +clean: + +dep depend: diff --git a/src/bin/vacuumdb/vacuumdb b/src/bin/vacuumdb/vacuumdb new file mode 100644 index 0000000000..dc9ec36651 --- /dev/null +++ b/src/bin/vacuumdb/vacuumdb @@ -0,0 +1,98 @@ +#!/bin/sh +#------------------------------------------------------------------------- +# +# vacuumdb-- +# vacuum a postgres database +# +# this program runs the monitor with the "-c" option to vacuum +# the requested database. +# +# Copyright (c) 1994, Regents of the University of California +# +# +# IDENTIFICATION +# $Header: /cvsroot/pgsql/src/bin/vacuumdb/Attic/vacuumdb,v 1.1 1998/11/14 01:58:15 thomas Exp $ +# +#------------------------------------------------------------------------- + +CMDNAME=`basename $0` + +if [ -z "$USER" ]; then + if [ -z "$LOGNAME" ]; then + if [ -z "`whoami`" ]; then + echo "$CMDNAME: cannot determine user name" + exit 1 + fi + else + USER=$LOGNAME + export USER + fi +fi + +dbname=$USER + +PASSWDOPT=""; + +while test -n "$1" +do + case $1 in + --help) usage=1;; + --analyze) analyze="analyze";; + --table) table=$2; shift;; + --verbose) verbose="verbose";; + + -a) AUTHSYS=$2; shift;; + -h) PGHOST=$2; shift;; + -p) PGPORT=$2; shift;; + -t) table=$2; shift;; + -u) PASSWDOPT=$1;; + -v) verbose="verbose";; + -z) analyze="analyze";; + -*) echo "$CMDNAME: unrecognized parameter $1"; usage=1;; + *) dbname=$1;; + esac + shift; +done + +if [ "$usage" ]; then + echo "Usage: $CMDNAME -a -h -p --analyze --verbose [--table 'table[(cols)]'] [dbname]" + exit 1 +fi + +if [ -z "$AUTHSYS" ]; then + AUTHOPT="" +else + AUTHOPT="-a $AUTHSYS" +fi + +if [ -z "$PGHOST" ]; then + PGHOSTOPT="" +else + PGHOSTOPT="-h $PGHOST" +fi + +if [ -z "$PGPORT" ]; then + PGPORTOPT="" +else + PGPORTOPT="-p $PGPORT" +fi + +if [ -z "$dbpath" ]; then + location="" +else +# if [ ! -d "$dbpath"/base ]; then +# echo "$CMDNAME: database creation failed on $dbname." +# echo "directory $dbpath/base not found." +# exit 1 +# fi + location="with location = '$dbpath'" +fi + +psql $PASSWDOPT -tq $AUTHOPT $PGHOSTOPT $PGPORTOPT -c "vacuum $verbose $analyze $table" $dbname + +if [ $? -ne 0 ]; then + echo "$CMDNAME: database vacuum failed on $dbname." + exit 1 +fi + +exit 0 -- 2.40.0