Backupscripte - Druckversion

Code:

SET PGPASSWORD=$redacted

"C:\Programme\PostgreSQL\10\bin\pg_dumpall.exe" --host localhost --port 5432 --username "postgres" --no-password  --verbose --file N:\Backups\Batched_Cluster\dumpall_%date:~6,4%_%date:~3,2%_%date:~0,2%.backup.sql

set PGPASSWORD=null

Code:

@echo off



goto comment



 Description: This file use to backup the database using PostgreSQL backup utility "pg_dump".

              Backup parameters should be setup before executing this file

 

 File Format flags :     

                c = Custom

                t = Tar

                p = Plain SQL





    

    Table Excluding Flags:

    -T table_name

    

:comment





REM "Set following backup parameters to take backup"

SET PGPASSWORD=$redacted

SET db_name=redacted

SET file_format=c

SET host_name=localhost

SET user_name=postgres

SET pg_dump_path="C:\Programme\PostgreSQL\10\bin\pg_dump.exe"  

SET target_backup_path=N:\Backups\Batched_DB\

SET other_pg_dump_flags=--blobs --verbose -c 



REM Fetch Current System Date and set month,day and year variables

for /f "tokens=1-3 delims=- " %%i in ("%date%") do (

    set month=%%j

    set day=%%i

    set year=%%k

)

for /f "tokens=1-3 delims=: " %%i in ("%time%") do (

    set hour=%%i

    set min=%%j

    set sec=%%k

)





REM Creating string for backup file name

for /f "delims=" %%i in ('dir "%target_backup_path%" /b/a-d ^| find /v /c "::"') do set count=%%i

set /a count=%count%+1 

set datestr=backup_%year%_%month%_%day%_%hour%_%min%



REM Backup File name

set BACKUP_FILE=%db_name%_%datestr%.backup



REM :> Executing command to backup database

%pg_dump_path% --host=%host_name% -U %user_name% --format=%file_format%  -f %target_backup_path%%BACKUP_FILE%  %db_name% 



REM %pg_dump_path% --host=%host_name% -U %user_name% --format=%file_format%  %other_pg_dump_flags% -f %target_backup_path%%BACKUP_FILE%  %db_name%



ECHO Backup l‰uft ...  Fenster schiesst selbstst‰ndig

Code:

SET PGPASSWORD=$redacted

"C:\Programme\PostgreSQL\10\bin\pg_dumpall.exe" --host localhost --port 5432 --username "postgres" --no-password  --verbose --file N:\Backups\Batched_Roles\pgroles.backup.sql --roles-only

set PGPASSWORD=null