postgresql_replication_monitor
Differences
This shows you the differences between two versions of the page.
| Next revision Both sides next revision | |||
|
postgresql_replication_monitor [2011/07/12 14:18] k2patel created |
postgresql_replication_monitor [2011/07/12 16:22] k2patel |
||
|---|---|---|---|
| Line 2: | Line 2: | ||
| <code bash> | <code bash> | ||
| + | #!/bin/bash | ||
| ############################# | ############################# | ||
| # Requirement Specification | # Requirement Specification | ||
| Line 35: | Line 36: | ||
| export psql=/usr/local/pg-9.0.3/bin/psql | export psql=/usr/local/pg-9.0.3/bin/psql | ||
| export bc=/usr/bin/bc | export bc=/usr/bin/bc | ||
| + | |||
| + | ## Delay Limit | ||
| + | export dlylmt=100000 | ||
| Line 57: | Line 61: | ||
| ## Customization End here | ## Customization End here | ||
| ########################### | ########################### | ||
| + | |||
| if [[ $pr_int_num -eq $sr_int_num && $pr_int_num -eq $tr_int_num && $sr_int_num -eq $tr_int_num ]] ; then | if [[ $pr_int_num -eq $sr_int_num && $pr_int_num -eq $tr_int_num && $sr_int_num -eq $tr_int_num ]] ; then | ||
| Line 68: | Line 73: | ||
| fi | fi | ||
| else | else | ||
| + | if [[ $(bc <<< $pr_int_num-$sr_int_num) -gt $dlylmt ]]; then | ||
| echo "Stream: Primary: $pr_int_num Secondary: $sr_int_num Import: $tr_int_num : CRITICAL" | echo "Stream: Primary: $pr_int_num Secondary: $sr_int_num Import: $tr_int_num : CRITICAL" | ||
| - | #echo "pgprod2.mcfina.com;$pr_int_num;$sr_int_num;$tr_int_num;1;WARNING" | ||
| - | #echo "WARNING - Stream is behind" | ||
| exit $STATE_CRITICAL | exit $STATE_CRITICAL | ||
| + | else | ||
| + | echo "Stream: Primary: $pr_int_num Secondary: $sr_int_num Import: $tr_int_num : WARNING" | ||
| + | exit $STATE_WARNING | ||
| + | fi | ||
| fi | fi | ||
| echo "Stream: Primary: $pr_int_num Secondary: $sr_int_num Import: $tr_int_num : UNKNOWN" | echo "Stream: Primary: $pr_int_num Secondary: $sr_int_num Import: $tr_int_num : UNKNOWN" | ||
postgresql_replication_monitor.txt ยท Last modified: 2020/08/10 02:35 (external edit)
Page Tools
Except where otherwise noted, content on this wiki is licensed under the following license: CC Attribution-Share Alike 4.0 International
