From: | "Vishal Arora" <aroravishal22(at)hotmail(dot)com> |
---|---|
To: | fst-procurement(at)telkomsa(dot)net, pgadmin-support(at)postgresql(dot)org |
Subject: | Re: pgagent |
Date: | 2007-07-12 07:47:38 |
Message-ID: | BAY123-F1391A1DD08DE7C35619B49A9FC0@phx.gbl |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgadmin-support |
>From: Fst Procurement <fst-procurement(at)telkomsa(dot)net>
>To: pgadmin-support(at)postgresql(dot)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
From | Date | Subject | |
---|---|---|---|
Next Message | Vishal Arora | 2007-07-13 06:14:12 | Re: pgagent |
Previous Message | Fst Procurement | 2007-07-12 06:47:55 | pgagent |