Re: automating backup ?

Hello.
I created a Windows XP schedule for backup, following your instruction. Now
I have a .bat file with this script:

cd D:\Program Files\PostgreSQL\8.0\bin
pg_dumpall >D:\MYDATABASE_DUMPALL -U postgres
pg_dumpall >D:\MYDATABASE_SHEMA -U postgres -s
pg_dumpall >D:\MYDATABASE_GLOBALS -U postgres -g

Well, it works OK, but prompts for password every time. Is there any way
that I pass the superuser password (off course, in safe way) so that it
works automatically without prompting for password ?

----- Original Message -----
From: "Andreas" <maps(dot)on(at)gmx(dot)net>
To: <pgsql-general(at)postgresql(dot)org>
Cc: "Zlatko Matic" <zlatko(dot)matic1(at)sb(dot)t-com(dot)hr>
Sent: Monday, June 27, 2005 12:43 PM
Subject: Re: [GENERAL] automating backup ?

> Zlatko Matic schrieb:
>
>> Thanks Fuhr.
>> Anybody can tell me how to do it on Windows XP ?
>> Thanks.
>
>
> That's again a pure Windows issue, but not commonly needed.
> I guess, it should be in the Windows PG-FAQ, too.
>
> I'll describe the way you go with Windows 2000.
> If you are lucky WinXP Pro does it the same way and if you have only WinXP
> Home you might be lucky if you have the needed timer-service at all.
> Please try it and come back to the list and tell us what you did and if it
> solved your problem.
>
>
> First you write a text file, that contains all commands you want to get
> executed.
> All those which you would otherwise type yourself on the command line.
> Call this file zlatko_backup.bat just that it has a unique name.
>
> In Windows' start menue you find "programs".
> There is a subfolder where I don't know the English name, but it holds
> among other things the calculator and a systemprograms-folder.
> In this Systemprograms-folder you should find "planned tasks" as a folder.
> Open the "planned tasks" folder. It is empty.
> Right click in it and select "new" --> "planned task".
> Select it and you will get an settings menue of a task where you can
> define what program should run when.
> Enter here the path to zlatko_backup.bat.
>
> Provided Window's planned-tasks-service runs all is set now.
>
>
> ---------------------------(end of broadcast)---------------------------
> TIP 7: don't forget to increase your free space map settings