On 08/26/2013 04:13 PM, Wang, Ya wrote:
> Hello All,
> I have a job scheduled using pg_agent, which copies data from MS SQL_SERVER to postgresql table using Ogr2Ogr tools. It is a huge table and it has been two days. Somehow it is still running. I have been trying to kill the job with no success. Restarting the postgresql server or Pg_agent don't do the job.
How have you been trying to kill the job?
--
Josh Berkus
PostgreSQL Experts Inc.
http://pgexperts.com