pg_dump using MS-DOS BAT file

Поиск
Список
Период
Сортировка
Искать
От
Richard Broersma Jr
Тема
pg_dump using MS-DOS BAT file
Дата
Msg-id
363397.71757.qm@web31814.mail.mud.yahoo.com
Список
Creating shell scripts and cron jobs are pretty easy tasks in *nix.  I wanted to attach a sample
BAT file script for anyone that is enterested in get something similar to work under windows. 
Comments are welcome.

Copy this text below into you own  bat file and then create a new "scheduled job"
by:

open "Control Panel"
open "Scheduled Tasks"
open "Add Scheduled Tasks"
Browse to where you saved you bat file.
Configure a the schedule and how many time a day you would like your db dumped.

I didn't attach my bat file to this email since I expect most email filters would balk at a bat
file.  Let me know what you think.

Regards,
Richard Broersma Jr.

------------------------------------------------------------------------

REM Backup BAT file script begins here

REM Set these variables to what is appropriate for your system

SET PGPATH="C:\Program Files\PostgreSQL\8.2rc1\bin\"
SET SVPATH="O:\02U20410 Rule 1105\Engr\Controls\Instrument Index\db_backup\"
SET ALTPTH="C:\Documents and Settings\BroersR\My Documents\db_backupalt\"
SET PRJDB=proj02u20411
SET DBUSR=postgres


REM This is an ugly solution to get a timestamp for the newly created
REM dump file.

FOR /F "TOKENS=2,3,4 DELIMS=/ " %%i IN ('DATE /T') DO SET d=%%k-%%i-%%j
FOR /F "TOKENS=1,2,3 DELIMS=: " %%i IN ('TIME /T') DO SET t=%%i%%j%%k

SET DBDUMP=%PRJDB%-%d%-%t%.dump

%PGPATH%pg_dump.exe -C -U %DBUSR% %PRJDB% > %SVPATH%%DBDUMP%
copy %SVPATH%%DBDUMP% %ALTPTH%

REM Backup BAT file script ends here

-------------------------------------------------------------------------
В списке pgsql-general по дате отправления
От: Joshua D. Drake
Дата:
Сообщение: Re: Is PostgreSQL for this?
От: Ron Johnson
Дата:
Сообщение: Re: Is PostgreSQL for this?
FAQ