<table bgcolor="white" border="0" cellpadding="3" cellspacing="0" width="100%"><tr valign="top"><td width="100%"><font
color="black"size="2">Hi,<br />I am trying to use pgAgent to automatically backup my database once a day. Wouldn't this
bethe most common use of pgAgent?<br /><br />I have successfully installed pgAgent, and it runs jobs ok. However, I'm
runninginto problems when I set up a job to run a "batch" step with the following definition: <br /><br />pg_dump -f
c:\temp\dump.dat-U postgres test<br /><br />It starts the job, and the statistics for the step shows it is running (I
canalso see in my task manager that pg_dump is running) ... but it never stops! If i kill the process, the statistics
forthe step shows "success", but no backup file has been created. When I run the same command at a dos prompt it works
fine.I'm at the point now where I figure I'll just set up a windows task that calls the script once a day, but i'd
ratheruse pgAgent to do my backups. Can anyone help?<br /><br />system details:<br />windows xp<br />pervasive postgres
8.0.3<br/>pgadmin 1.4.1<br /><br />installed pgAgent via:<br />C:\Program Files\pgAdmin III\1.4>pgAgent INSTALL
pgAgent-1 2 -u postgres -p MyPass123<br /> hostaddr=127.0.0.1 dbname=postgres user=postgres password=postgresABC<br
/><br/>Thanks!<br />Che<br /><br /><br /><br /><br /></font></td></tr></table><p><hr /><font face="verdana"
size="2"><spanstyle="font-weight:bold">No banners. No pop-ups. No kidding.</span><br />Make My Way your home on the Web
-<a href="http://www.myway.com" target="_blank">http://www.myway.com</a></font>
