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.on@xxxxxxx>
To: <pgsql-general@xxxxxxxxxxxxxx>
Cc: "Zlatko Matic" <zlatko.matic1@xxxxxxxxxxx>
Sent: Monday, June 27, 2005 12:43 PM
Subject: Re: 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
---------------------------(end of broadcast)---------------------------
TIP 6: Have you searched our list archives?
http://archives.postgresql.org
