Is your cloud always on? With an Always On cloud you won't have to worry about downtime for maintenance or software application code updates, ensuring that your bottom line isn't affected.
@ECHO OFF SET HOUR=%time:~0,2% SET DATE12=%date:~-4%%date:~4,2%%date:~7,2%_0%time:~1,1%%time:~3,2%%time:~6,2% SET DATE24=%date:~-4%%date:~4,2%%date:~7,2%_%time:~0,2%%time:~3,2%%time:~6,2% if "%HOUR:~0,1%" == " " (SET DATE=%DATE12%) else (SET DATE=%DATE24%) REM xTuple/PostgreSQL Information SET PRODDB=databasename SET PGUSER=username SET PGHOST=server_name SET PGPORT=5434 SET PGBIN="C:\Program Files\PostgreSQL\9.1\bin" SET BACKUPEXT=backup REM formats can be custom/plain/tar SET FORMAT=custom SET GLOBALS=globals-%DATE%.sql SET BACKUPFILENAME=%PRODDB%.%DATE%.%BACKUPEXT% REM for %%a in (%PGPASS%) do (>"%PGPassFile%" echo %PG_HOST%:%PG_PORT%:%PRODDB%:%PGUSER%:%%~a) @ECHO Backing up globals to %GLOBALS%... %pgbin%\pg_dumpall -h 127.0.0.1 -U %PGUSER% -p %PGPORT% -g > %GLOBALS% @ECHO Backing up %PRODDB% to %BACKUPFILENAME%... %pgbin%\pg_dump -h 127.0.0.1 -U %PGUSER% -p %PGPORT% --format=%FORMAT% -C %PRODDB% > %BACKUPFILENAME% REM del "%PGPassFile%"
Add your voice to the tech community where 5M+ people just like you are talking about what matters.
Join the community of 500,000 technology professionals and ask your questions.