PowerShell Script: Backup All PostgreSQL Databases

A PowerShell backup script automates the process of backing up all databases from a PostgreSQL server.
This helps administrators protect important data and simplify disaster recovery.

How the Backup Script Works

1. Connect to PostgreSQL Server
   The script connects to the PostgreSQL server using authentication credentials.
2. Retrieve Database List
   It automatically collects all available user databases, excluding system templates.
3. Backup Each Database
   The script uses pg_dump to export each database into an .sql backup file.
4. Optional Compression
   Backup files can be compressed into .zip format to save storage space.
5. Save Logs and Reports
   The script stores backup logs to monitor success or failure.
6. Scheduled Automation
   The script can run automatically using Windows Task Scheduler.