On 08/26/2013 05:16 PM, Wang, Ya wrote:
> Josh,
> I tried to kill the job using task manager. However, ogr2ogr doesn't seem to be a running process. I tried to find the job using "Select * from pg_stat_activity". I can't find the job here either. So, I stopped the pgagent service and restarted postgresql server. Now, in the jobs statistics of the PgAdminIII, the job is still shown to be running.
But there's actually no process running?
Probably you'll have to directly update one of the pgagent tables.
Don't know any more than that, I'm afraid.
--
Josh Berkus
PostgreSQL Experts Inc.
http://pgexperts.com