Re: how to create backup copies

> -----Original Message-----
> From: pgadmin-support-owner(at)postgresql(dot)org
> [mailto:pgadmin-support-owner(at)postgresql(dot)org] On Behalf Of Andrus
> Sent: 13 April 2006 10:25
> To: pgadmin-support(at)postgresql(dot)org
> Subject: Re: [pgadmin-support] how to create backup copies
>
> >> Couldn't execute script
> >> C:DOCUME~1\postgres\LOCAL~1TemppgaD591.tmp1_1.bat
> >
> > Is that *exactly* what was displayed, or is your backslash
> key playing
> > up?
>
> Sorry. Some backslashes are missing. actially it is
>
> C:\DOCUME~1\postgres\LOCAL~1\Temp\pgaD591.tmp\1_1.bat
>
> Any idea how to make automatic backup at 3:00 every night in
> W2K server ?

To be honest for a simple backup on the local machine you'll be better
off running it from task scheduler. pgAgent is better suited to running
batch processing jobs that may run on any one of a number of nodes, or
SQL jobs that run directly on the database.

Regards, Dave.