HEX
Server: Apache
System: Linux vpshost0650.publiccloud.com.br 4.4.79-grsec-1.lc.x86_64 #1 SMP Wed Aug 2 14:18:21 -03 2017 x86_64
User: bandeirantesbomb3 (10068)
PHP: 8.0.7
Disabled: apache_child_terminate,dl,escapeshellarg,escapeshellcmd,exec,link,mail,openlog,passthru,pcntl_alarm,pcntl_exec,pcntl_fork,pcntl_get_last_error,pcntl_getpriority,pcntl_setpriority,pcntl_signal,pcntl_signal_dispatch,pcntl_sigprocmask,pcntl_sigtimedwait,pcntl_sigwaitinfo,pcntl_strerror,pcntl_wait,pcntl_waitpid,pcntl_wexitstatus,pcntl_wifexited,pcntl_wifsignaled,pcntl_wifstopped,pcntl_wstopsig,pcntl_wtermsig,php_check_syntax,php_strip_whitespace,popen,proc_close,proc_open,shell_exec,symlink,system
Upload Files
File: //usr/lib/python2.7/site-packages/lap/postgresql_physical_backup.py
import datetime
import os
import os.path

from ConfigParser import ConfigParser
from glob import glob

# deprecated. Use barman instead

# check postgresql backup.
# this script expects the package backup-postgresql >= 2.0
# since in the end of backup postgresql archives a *backup*,
# we can use it to monitor the backup
def __run__(params):
    min_age = int(params.get('min_backup_age'))
    min_date = datetime.datetime.now() - datetime.timedelta(hours=min_age)

    cp = ConfigParser()
    conf_file = "/etc/dbas/postgresql/backup.conf"
    cp.read(conf_file)

    archive_path = cp.get('backup_physical', 'backup_archive')

    for f in glob(os.path.join(archive_path, '*backup*')):
        s = os.stat(f)
        f_date = datetime.datetime.fromtimestamp(s.st_ctime)
        if f_date >= min_date:
            return [0, 'OK: Last backup {0}'.format(f_date)]
    return [2, 'CRITICAL: no recent backup found']