Activate Backup

For systems without automation.

• Clone dir

  cd /opt
  git clone https://github.com/vico-research-and-consulting/postgresql-scripts.git
  chown postgres:postgres /opt/postgresql-scripts
  

• Create Backup volume/disk and mount it to /srv/backup/postgresql
• Create backup directory

  mkdir /srv/backup/postgresql
  chown postgres:postgres /srv/backup/postgresql
  

• Activate job

  echo "0 2 * * * postgres /opt/postgresql-scripts/backup-databases.sh /srv/backup/postgresql  5 2>&1| logger -t postgresql-backup" > /etc/cron.d/postgresql-backup
  

• Assign Zabbix Template to host (Custom__Service__Postgresql__Backup.xml)
• Run initial backup

  su - postgres
  /opt/postgresql-scripts/backup-databases.sh /srv/backup/postgresql 5