Voici un 'tit script (pour ba

sparky/ = 11 Octobre, 2005 - 11:36

Voici un 'tit script (pour bash sous linux) qui va t'aider

#!/bin/bash
# Author Dany De Bontridder
# script under GLP
#
if [ $# -eq 0 ];then
echo "You must give the name of an existing database"
exit 1
fi
DATID=`psql -t template1 -c "select datid from pg_stat_database where upper(datname)=upper('$1')"`
echo "Database $1 id : $DATID "
echo "******************************************"
DATID=`basename $DATID`
du -sk $PGDATA/base/$DATID/*|grep -iv pg|sort +0n|while read C D;do
ID=`basename $D`
psql $1 -t -c "select '$C',relname from pg_class where relfilenode=$ID";
done|sed "/^$/d"