View Single Post

   
  #5 (permalink)  
Old 04-17-2008, 07:24 PM
Andrus
 
Posts: n/a
Default Re: how to create backup copies

> I entered to the step definition window
>
> c:\mydir\mysubdir\mybackup.bat
>
> and ran pgagent.
>
> 1_1.bat file now remains and contains line
>
> c:\mydir\mysubdir\mybackup.bat
>
> I executed from cmd line
>
> runas /user:mydomain\postgres cmd
>
> cd "C:\Document and settings\ postgres\Local Settings\temp\pda48EB.tmp"
>
> 1_1.bat
>
>
> and pg_dump.exe creates backup file
>
>
> So running 1_1.bat manually as user postgres works OK.


Application log contains

Could'nt execute script C:\DOCUME~1\postgres\.... GetLastError() returned
183, errno = 0

Andrus.


Reply With Quote