Skip to content

This powershell script automates backups of postgresql database and send alert to telegram

License

Notifications You must be signed in to change notification settings

SMWkda/PostgresAutobackupScript

Folders and files

NameName
Last commit message
Last commit date

Latest commit

 

History

9 Commits
 
 
 
 
 
 
 
 

Repository files navigation

REQUIRES PG_DUMP.EXE BINARY TO WORK

Usage:

  1. Download pg_dump.exe or install pgAdmin 4
  2. Place script somewhere, specify database credentials and backups folder path
  3. Create Task Scheduler Job with my XML template, specify time schedule
  4. Additionally specify telegram bot credentials and chatId to send alerts

Backup Archives Example:

{B19B00D9-09FD-492D-90AF-A5755A5DEB76}

Telegram Alerts via Bot:

{DCE7FB1B-1FD8-4F3A-A16B-679A013E39ED}