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 ------------------------------------------------------------------ -- Sent via pgadmin-support mailing list (pgadmin-support@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgadmin-support