Re: Automatic backup in windows

Hello everyone,  I want to schedule the automatic backup in windows postgresql platform. 

I have attached the script,  if any changes is required please correct and send back. This is my humble request. 

Actually I don't know to write the windows script.  Otherwise if incase any have the script please send me .

Db name:rathi26

Backup file path:C:\Users\gangireddyobiredy\Desktop\case.sql

Thank you And Regards 

Obireddy. G

 

@echo off

SET day=%date:~0,2%

SET month=%date:~7,8%

SET year=%date:~6,4%

SET hh=%time:~0,2%

SET mm=%time:~3,2%

SET BACKUPDIR=C:\users_Backup

SET datestr=%day%-%month%-%year%_%hh%-%mm%

SET dir=%day%-%month%-%year%

mkdir C:\users_Backup%dir%

#Provide database name here

SET db1=dbname1

echo datestr is %datestr%                                   

SET BACKUP_rathi26=C:\Users\gangireddyobiredy\Desktop\case.sqll

SET rathi26=%db1%%datestr%.sql

ECHO Backup file name is %rathi26%

SET PGPASSWORD=

echo on

#Execute Backup for database

C:\Program Files\PostgreSQL\13\bin>pg_dump.exe -p 5432 -U postgres -v -d rathi26 > C:\Users\gangireddyobiredy\Desktop\case.sql

echo Backup Completed