Re: automating backup ? - Mailing list pgsql-general

From Zlatko Matic
Subject Re: automating backup ?
Date
Msg-id 000901c57b62$fce2ca60$0c8a1dc3@zlatko58zaczpv
Whole thread Raw
In response to Win32 users?  (Joe <svn@freedomcircle.net>)
List pgsql-general
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@gmx.net>
To: <pgsql-general@postgresql.org>
Cc: "Zlatko Matic" <zlatko.matic1@sb.t-com.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


pgsql-general by date:

Previous
From: "Relyea, Mike"
Date:
Subject: Re: Indexes not used - what am I missing?
Next
From: Bruno Wolff III
Date:
Subject: Re: Finding points within 50 miles