Search Postgresql Archives

Re: automating backup ?

[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]

 



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

[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]
[Index of Archives]     [Postgresql Jobs]     [Postgresql Admin]     [Postgresql Performance]     [Linux Clusters]     [PHP Home]     [PHP on Windows]     [Kernel Newbies]     [PHP Classes]     [PHP Books]     [PHP Databases]     [Postgresql & PHP]     [Yosemite]
  Powered by Linux