Hi Jimmy
Can you just pass me your batch file and the screen shot of your step
definition in pgAdminIII
- Vishal
From: Fst Procurement <[EMAIL PROTECTED]>
To: Vishal Arora <[EMAIL PROTECTED]>
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 <[EMAIL PROTECTED]>
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
---------------------------(end of broadcast)---------------------------
TIP 1: if posting/reading through Usenet, please send an appropriate
subscribe-nomail command to [EMAIL PROTECTED] so that your
message can get through to the mailing list cleanly
