Postgresql: Backup automático com data e hora no nome do arquivo | Pgdump with date and time in backup file name

Windows!

Crie o arquivo e salve com a extensão .BAT, em seguida faça o agendamento da tarefa no Windows.

// Base local
@ECHO OFF

SET PGPASSWORD=123456

pg_dump.exe -h localhost -U postgres -F c -b -v -f "c:\BackupPostGre_%date:/=%_%time:~0,2%-%time:~3,2%-%time:~6,2%.backup" minhabase

// Base na Amazon
@ECHO OFF

SET PGPASSWORD=123456

pg_dump.exe -h minhabase.xxxx.sa-east-1.rds.amazonaws.com -p 5432 -U postgres -F c -b -v -f "c:\BackupPostGre_%date:/=%_%time:~0,2%-%time:~3,2%-%time:~6,2%.backup" minhabase