Shell script to monitor postgresql database status and alerts

Question

I need postgresql shell script to alert me if database is goes down.

while true; do psql -c "select 1"; if [ $? -gt 0 ]; then echo 'alert'; fi; sleep 1; done; — Vao Tsun
– Vao Tsun, Commented Jun 13, 2017 at 9:12
it tries to connect to db once in a sec and if fails, echoes 'alert' — Vao Tsun
– Vao Tsun, Commented Jun 13, 2017 at 9:27

GregD · Accepted Answer · 2017-12-11 15:57:11Z

6

pg_isready is a utility for checking the connection status of a PostgreSQL database server. The exit status specifies the result of the connection check.

Example:

while true; do
    if ! /usr/bin/pg_isready &>/dev/null; then 
        echo 'alert';
    fi;
    sleep 3;
done;

This will check the status of postgresql database every 3 seconds and echos "alert" if it is down.

https://www.postgresql.org/docs/9.3/static/app-pg-isready.html

edited Dec 11, 2017 at 15:57

GregD

2,8773 gold badges31 silver badges42 bronze badges

answered Jun 13, 2017 at 10:44

alibaba

1,9632 gold badges13 silver badges14 bronze badges

Sign up to request clarification or add additional context in comments.

Collectives™ on Stack Overflow

Shell script to monitor postgresql database status and alerts

1 Answer 1

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

Comments

Your Answer

Sign up or log in

Post as a guest

Related