用于下载和恢复Heroku postgres数据库的windows脚本

@echo off

setlocal

set HEROKU_API_KEY=YOUR_HEROKU_API_KEY
set APP_NAME=YOUR_APP_NAME
set DATABASE_NAME=YOUR_DATABASE_NAME

set BACKUP_DIR=C:\path\to\backup\directory

set PG_DUMP_PATH=C:\path\to\pg_dump.exe
set PG_RESTORE_PATH=C:\path\to\pg_restore.exe

set TIMESTAMP=%DATE:/=-%_%TIME::=-%
set TIMESTAMP=%TIMESTAMP: =0%

set BACKUP_FILE=%BACKUP_DIR%\%TIMESTAMP%.dump

echo Downloading Heroku Postgres backup...
heroku pg:backups:capture --app %APP_NAME% --remote main

echo Downloading backup file...
heroku pg:backups:download --app %APP_NAME% --remote main -o %BACKUP_FILE%

echo Restoring Heroku Postgres database...
"%PG_RESTORE_PATH%" --verbose --clean --no-acl --no-owner -h localhost -U postgres -d %DATABASE_NAME% "%BACKUP_FILE%"

echo Cleanup...
del "%BACKUP_FILE%"

echo Done.

endlocal