Return to generate_arglist CVS log

Up to [Local Repository] / badi / public_scripts / parallelstarter / db_backup

Annotation of badi/public_scripts/parallelstarter/db_backup/generate_arglist, revision 1.1.1.1

1.1       adi         1: # Prepare db_backup to be run with parallelstarter:
                      2: # generate arglist from password file
                      3: 
                      4: # step through DBLIST and convert each line 
                      5: # into a set of command line args for db_backup
                      6: 
                      7: if [ -e "$ARGLIST_FILE" ]; then
                      8:        rm "$ARGLIST_FILE"
                      9: fi
                     10: 
                     11: while read dbinfo; do
                     12: 
                     13:        # ignore comment and empty lines
                     14:        if [ $(echo "$dbinfo" | egrep -c "^[ \t]*#.*$") -gt 0 ]; then
                     15:               continue
                     16:        fi
                     17:        
                     18:        # ignore empty lines or malformed lines
                     19:        if [ $(echo "$dbinfo" | sed 's/[^:]//g' | wc -m) -lt 4 ]; then
                     20:                continue
                     21:        fi
                     22: 
                     23:        curhost="`echo $(echo "$dbinfo" | awk -F ':' '{print $1}')`"
                     24:         curdb="`echo $(echo "$dbinfo" | awk -F ':' '{print $3}')`"
                     25:         curuser="`echo $(echo "$dbinfo" | awk -F ':' '{print $4}')`"
                     26:         curtype="`echo $(echo "$dbinfo" | awk -F ':' '{print $2}')`"
                     27:        curpw="`echo $(echo "$dbinfo" | awk -F ':' '{print $5}')`"
                     28: 
                     29:        echo "-h $curhost -D $curdb -u $curuser -c $DBLIST -t $curtype" >> "$ARGLIST_FILE"
                     30:        
                     31:        # write .pgpass in case there is a PostgreSQL DB involved
                     32:        if [ "$curtype" = "postgresql" ]; then
                     33:                # see if password is already registered
                     34:                if [ ! -e "$HOME/.pgpass" ]; then
                     35:                        touch "$HOME/.pgpass"
                     36:                        chmod 600 "$HOME/.pgpass"
                     37:                fi
                     38:                if [ $(grep -c "$curhost:$PGPORT:$curdb:$curuser" "$HOME/.pgpass") -eq 0 ]; then
                     39:                        # add the line to .pgpass
                     40:                        echo "$curhost:$PGPORT:$curdb:$curuser:$curpw" >> "$HOME/.pgpass"
                     41:                elif [ $(grep -c "$curhost:$PGPORT:$curdb:$curuser:$curpw" "$HOME/.pgpass") -eq 0 ]; then
                     42:                        # the pw has changed; replace the password with new value
                     43:                        mv "$HOME/.pgpass" "$HOME/.pgpass.old"
                     44:                        touch "$HOME/.pgpass"
                     45:                        chmod 600 "$HOME/.pgpass"
                     46:                        grep -v "$curhost:$PGPORT:$curdb:$curuser" "$HOME/.pgpass.old" >> "$HOME/.pgpass"
                     47:                        echo "$curhost:$PGPORT:$curdb:$curuser:$curpw" >> "$HOME/.pgpass"
                     48:                fi
                     49:        fi
                     50: 
                     51: done < "$DBLIST"