{
  "service": {
    "check": {
      "interval": "10s",
      "script": "{{consul_scripts_path}}/pgbouncer_check.sh"
    },
    "name": "pgbouncer",
    "port": 6432,
    "tags": [ ]
  }
}

#!/bin/sh
isok=$(timeout 1 {{ postgres_bin_dir }}/psql --host 127.0.0.1 -qAt0 --port 6432 {{ noc_pg_db }} -c "select 'ok'")
if [ "$isok" = "ok" ]
then
    exit 0
else
    exit 2
fi

A check script is generally free to do anything to determine the status of the check. The only limitations placed are that the exit codes must obey this convention:

Exit code 0 - Check is passing
Exit code 1 - Check is warning
Any other code - Check is failing