5 echo "Creating $1 List"
6 psql -U sourceforge -h `hostname -s` sourceforge 2>&1 > $DESCDIR/$1 <<-FIN
10 cat $DESCDIR/$1 | grep "^ [a-z]" | sed "s/^ \([a-z].[^ |]*\). *|.*/\1/" | sort -u > $DESCDIR/$1.tmp
11 mv $DESCDIR/$1.tmp $DESCDIR/$1
12 [ ! -d $DESCDIR/$1.dump ] && mkdir $DESCDIR/$1.dump
13 #cat $DESCDIR/$1 | while read tablename
16 # pg_dump --no-owner --no-reconnect -h `hostname -s` sourceforge -u -d -t $tablename -f $DESCDIR/$1.dump/$tablename <<-FIN
23 [ "x$DESCDIR" == "x" ] && DESCDIR=desc
24 echo "Desc in $DESCDIR"
25 [ "x$DBPASS" == "x" ] && DBPASS=`grep sys_dbpasswd /etc/sourceforge/database.inc| cut -d\" -f2 ` && [ "x$DBPASS" == "x" ] && echo "Can't get DB Passwd" && exit
28 [ ! -d $DESCDIR ] && mkdir $DESCDIR
32 createlist sequences ds