Révision fdf6cea2
postgresql_transactions: change from bash to sh; fix shellcheck issues
| plugins/postgresql/postgresql_transactions | ||
|---|---|---|
| 1 |
#!/bin/bash
|
|
| 1 |
#!/bin/sh |
|
| 2 | 2 |
# |
| 3 | 3 |
# Plugin to monitor PostgreSQL Commits and Rollbacks in Transactions |
| 4 | 4 |
# |
| ... | ... | |
| 42 | 42 |
echo 'rollbacks.info Number of transaction rollbacks per second.' |
| 43 | 43 |
exit 0 |
| 44 | 44 |
fi |
| 45 |
psql -h ${dbserver} -U ${dbuser} -tc "SELECT 'commits.value '||SUM(xact_commit)::TEXT||E'\nrollbacks.value '||SUM(xact_rollback)::TEXT FROM pg_stat_database;" --no-align
|
|
| 45 |
psql -h "$dbserver" -U "$dbuser" -tc "SELECT 'commits.value '||SUM(xact_commit)::TEXT||E'\\nrollbacks.value '||SUM(xact_rollback)::TEXT FROM pg_stat_database;" --no-align |
|
Formats disponibles : Unified diff