Hi, I have got it worked from another way. written a shell scrip and created an exe for that Now defined a windows task scheduler and given this exe file, its doing the backup perfectly. Also provided a link in application for super user, once clicked we are calling a java runtime proces and calling the exe which is generating the bakup.
2009/5/5 Raymond O'Donnell <r...@iol.ie> > On 05/05/2009 10:47, Kranti™ K K Parisa wrote: > > > When I run the command thru command prompt able to get the backup > > file(without asking the password as I have passed an entry in pgpass.conf > > file) of 1mb in size. but when I use RUN NOW from aggent job getting the > > file generated in the given directory but its of 0kb in size. > > I don't know anything about pgAgent, but it sounds as if the job is > failing for some reason and writing an empty file. Are there any logs > you can check? - maybe the Windows event log or the PostgreSQL log? > Also, what about permissions on the output directory - has the backup > process got permission to write there? > > Just wild guesses.... > > Ray. > > > ------------------------------------------------------------------ > Raymond O'Donnell, Director of Music, Galway Cathedral, Ireland > r...@iol.ie > Galway Cathedral Recitals: http://www.galwaycathedral.org/recitals > ------------------------------------------------------------------ > -- Kranti K K Parisa M: +91 - 9391 - 438 - 738 O: +91 - 4023 - 844 - 738 ------------------------------------------------------------------ " world will be different, if...... " ------------------------------------------------------------------
