running pg_dump via pgAgent
От | Che |
---|---|
Тема | running pg_dump via pgAgent |
Дата | |
Msg-id | 20060128175151.2898712CC7@mprdmxin.myway.com обсуждение исходный текст |
Список | pgadmin-support |
<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>
В списке pgadmin-support по дате отправления: