Forum debian-fr.org

function retry {
   nTrys=0
   maxTrys=3
   status=256
   until [ $status == 0 ] ; do
      $*
      status=$?
      nTrys=$(($nTrys + 1))
      if [ $nTrys -gt $maxTrys ] ; then
            echo "Number of re-trys exceeded. Exit code: $status"
            exit $status
      fi
      if [ $status != 0 ] ; then
            echo "Failed (exit code $status)... retry $nTrys"
            sleep 60
      fi
   done
}

PostgresDBpresent=`psql -t -h $REMOTE_HOST -U $PG_USER -d postgres -c "select datname from pg_database where (datname LIKE 'postgres')" 2>> $SCRIPT_LOG_FILE"`

PostgresDBpresent=`retry psql -t -h $REMOTE_HOST -U $PG_USER -d postgres -c "select datname from pg_database where (datname LIKE 'postgres')" 2>> $SCRIPT_LOG_FILE"`

psql: warning: extra command-line argument "datname" ignored
psql: warning: extra command-line argument "from" ignored
psql: warning: extra command-line argument "pg_database" ignored
psql: warning: extra command-line argument "where" ignored
psql: warning: extra command-line argument "(datname" ignored
psql: warning: extra command-line argument "LIKE" ignored
psql: warning: extra command-line argument "'postgres')" ignored
ERROR:  syntax error at end of input
LINE 1: select
              ^
^Cpsql: warning: extra command-line argument "datname" ignored
psql: warning: extra command-line argument "from" ignored
psql: warning: extra command-line argument "pg_database" ignored
psql: warning: extra command-line argument "where" ignored
psql: warning: extra command-line argument "(datname" ignored
psql: warning: extra command-line argument "LIKE" ignored
psql: warning: extra command-line argument "'postgres')" ignored
ERROR:  syntax error at end of input
LINE 1: select
              ^
^Cpsql: warning: extra command-line argument "datname" ignored
psql: warning: extra command-line argument "from" ignored
psql: warning: extra command-line argument "pg_database" ignored
psql: warning: extra command-line argument "where" ignored
psql: warning: extra command-line argument "(datname" ignored
psql: warning: extra command-line argument "LIKE" ignored
psql: warning: extra command-line argument "'postgres')" ignored
ERROR:  syntax error at end of input
LINE 1: select
              ^
^Cpsql: warning: extra command-line argument "datname" ignored
psql: warning: extra command-line argument "from" ignored
psql: warning: extra command-line argument "pg_database" ignored
psql: warning: extra command-line argument "where" ignored
psql: warning: extra command-line argument "(datname" ignored
psql: warning: extra command-line argument "LIKE" ignored
psql: warning: extra command-line argument "'postgres')" ignored
ERROR:  syntax error at end of input
LINE 1: select
              ^

Req="psql -t -h $REMOTE_HOST -U $PG_USER -d postgres -c \"select datname from pg_database where (datname LIKE 'postgres')\" 2>> $SCRIPT_LOG_FILE"
PostgresDBpresent=`retry eval "$Req"`

until nc -z $server $portPsql; do sleep 60; done

until psql ... || [ $((essais++)) -eq 3 ]
do sleep 60
done