Re: pgagent - Mailing list pgadmin-support
From | Vishal Arora |
---|---|
Subject | Re: pgagent |
Date | |
Msg-id | BAY123-F2117B03B99332E8463D9E0A9FD0@phx.gbl Whole thread Raw |
In response to | pgagent (Fst Procurement <fst-procurement@telkomsa.net>) |
List | pgadmin-support |
Hi Jimmy Can you just pass me your batch file and the screen shot of your step definition in pgAdminIII - Vishal >From: Fst Procurement <fst-procurement@telkomsa.net> >To: Vishal Arora <aroravishal22@hotmail.com> >Subject: Re: [pgadmin-support] pgagent >Date: Fri, 13 Jul 2007 07:52:21 +0200 > >Hi Vishal, > >Thanks for your reply. > >I tried your suggestions with the following results: > >The batch file is now executing, but the entry in the pglog file >complaining about the backslash only stopped after I installed PgAdmin3 Ver >1.7. > >Although the batch file executes, it creates a file with 0kb. I tried >different parameters without success. Again running the command from the >DOS prompt worked correctly, but not when run through pgagent. > >Is there something else I can try? > >regards > >Jimmy > >Vishal Arora wrote: >> >> >>>From: Fst Procurement <fst-procurement@telkomsa.net> >>>To: pgadmin-support@postgresql.org >>>Subject: [pgadmin-support] pgagent >>>Date: Thu, 12 Jul 2007 08:47:55 +0200 >>> >>>Hi , >>> >>>I have searched the net and found some articles on pgagent, but I am >>>unable to get "pg_dump" to execute.: >>> >>>"Pg_Dump postgres -U postgres -Fc -f c:\db-dump" causes an error in >> >>If you try to run this in definition tab in step window it won't run. >> >>Make a .bat file and put the command as follows - >> >>@echo off >> >>"C:\Program Files\PostgreSQL\8.2\bin\pg_dump" -Upostgres > "c:\db-dump" >> >>@echo on >> >>And in the step definition tab - put the path of this .bat file within >>qoutes (" " ). >> >> >>>the >>>pglog file. It complains about the backslash. When I enter this command >>>in >>>the definition tab the backslash is escaped in the SQL tab. If I change >>>the >>>command to: >>> >>>" Pg_Dump postgres -U postgres -f db.dump" it still complains about a >>>backslash. Its as though it is not really seeing the command. >>> >>>I tried this command as a SQL and a BATCH step with no success. >>> >>>In one of the articles on the net I saw that W2K has a bug and will not >>>run >>>a BATCH step. >>> >>>Do you perhaps have any other ideas how I can get pg_dump to run through >>>pg_agent ? Any help would be greatly appreciated. >>> >>>regards, >>> >>>Jimmy >>> >> >> >>Is your pgAgent service running? >> >> >>> >>> >>>---------------------------(end of broadcast)--------------------------- >>>TIP 5: don't forget to increase your free space map settings >> >>_________________________________________________________________ >>Local listings, incredible imagery, and driving directions - all in one >>place! http://maps.live.com/?wip=69&FORM=MGAC01 >> >> >> _________________________________________________________________ http://liveearth.msn.com
pgadmin-support by date: