* リモートからPostgreSQLを再起動するスクリプト [#c7839c52]
#!/bin/sh
DB_NAME=my_db
DB_PGDATA=/usr/local/pgsql/data
echo "### Check PostgreSQL is running."
ssh -t -l postgres db.example.com "pg_ctl -D $DB_PGDATA status" | grep 'is running'
if [ $? -ne 0 ]; then
echo
echo "### Start PostgreSQL."
ssh -t -l postgres db.example.com "pg_ctl -w -D $DB_PGDATA start"
else
echo
echo "### Restart PostgreSQL to kill all connections."
ssh -t -l postgres db.example.com "pg_ctl -w -D $DB_PGDATA restart"
fi
echo
echo "### Done."
