Thread: pgagent

pgagent

From

Fst Procurement

Date:

12 July 2007, 07:30:41

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 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

Re: pgagent

From

"Vishal Arora"

Date:

12 July 2007, 07:47:47



>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

Re: pgagent

From

"Vishal Arora"

Date:

13 July 2007, 06:14:27

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