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
