Re: How to stop a scheduled PG_Agent job?

Lists: sfpug
From: "Wang, Ya" <Ya(dot)Wang(at)vta(dot)org>
To: "'sfpug(at)postgresql(dot)org'" <sfpug(at)postgresql(dot)org>
Subject: How to stop a scheduled PG_Agent job?
Date: 2013-08-26 23:13:12
Message-ID: CD4BEECCEBBAA545974D52EB0A5B6EF13AE98831@ROMAIL4.vta.org
Views: Raw Message | Whole Thread | Download mbox | Resend email
Lists: sfpug

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.

If you can point me in the right direction, I would greatly appreciate it.

Thanks,

Ya

From: Josh Berkus <josh(at)agliodbs(dot)com>
To: sfpug(at)postgresql(dot)org
Subject: Re: How to stop a scheduled PG_Agent job?
Date: 2013-08-27 00:09:04
Message-ID: 521BEE20.3080302@agliodbs.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Lists: sfpug

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

From: "Wang, Ya" <Ya(dot)Wang(at)vta(dot)org>
To: 'Josh Berkus' <josh(at)agliodbs(dot)com>, "sfpug(at)postgresql(dot)org" <sfpug(at)postgresql(dot)org>
Subject: Re: How to stop a scheduled PG_Agent job?
Date: 2013-08-27 00:16:44
Message-ID: CD4BEECCEBBAA545974D52EB0A5B6EF13AE9B872@ROMAIL4.vta.org
Views: Raw Message | Whole Thread | Download mbox | Resend email
Lists: Postg윈 토토SQL : Postg윈 토토SQL 메일 링리스트 : 2013-08-27 00:16 이후의 SFPUG.

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.

Ya

-----Original Message-----
From: sfpug-owner(at)postgresql(dot)org [mailto:sfpug-owner(at)postgresql(dot)org] On Behalf Of Josh Berkus
Sent: Monday, August 26, 2013 5:09 PM
To: sfpug(at)postgresql(dot)org
Subject: Re: [sfpug] How to stop a scheduled PG_Agent job?

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

From: Josh Berkus <josh(at)agliodbs(dot)com>
To: sfpug(at)postgresql(dot)org
Subject: Re: How to stop a scheduled PG_Agent job?
Date: 2013-08-27 04:01:39
Message-ID: 521C24A3.6060604@agliodbs.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Lists: Postg스포츠 토토 결과SQL : Postg스포츠 토토 결과SQL 메일 링리스트 : 2013-08-27 이후 SFPUG 04:01

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

From: "Wang, Ya" <Ya(dot)Wang(at)vta(dot)org>
To: 'Josh Berkus' <josh(at)agliodbs(dot)com>, "sfpug(at)postgresql(dot)org" <sfpug(at)postgresql(dot)org>
Subject: Re: How to stop a scheduled PG_Agent job?
Date: 2013-08-27 04:09:02
Message-ID: CD4BEECCEBBAA545974D52EB0A5B6EF13AE9B88D@ROMAIL4.vta.org
Views: Raw Message | Whole Thread | Download mbox | Resend email
Lists: sfpug

Josh,
Thank you. I also suspect that the jobs statistics may not be accurate. My bigger problem is that I can't restart pgagent service anymore.

Ya

-----Original Message-----
From: sfpug-owner(at)postgresql(dot)org [mailto:sfpug-owner(at)postgresql(dot)org] On Behalf Of Josh Berkus
Sent: Monday, August 26, 2013 9:02 PM
To: sfpug(at)postgresql(dot)org
Subject: Re: [sfpug] How to stop a scheduled PG_Agent job?

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

From: Josh Berkus <josh(at)agliodbs(dot)com>
To: "Wang, Ya" <Ya(dot)Wang(at)vta(dot)org>
Cc: "sfpug(at)postgresql(dot)org" <sfpug(at)postgresql(dot)org>
Subject: Re: How to stop a scheduled PG_Agent job?
Date: 2013-08-27 18:19:51
Message-ID: 521CEDC7.7090603@agliodbs.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Lists: sfpug

On 08/26/2013 09:09 PM, Wang, Ya wrote:
> Josh,
> Thank you. I also suspect that the jobs statistics may not be accurate. My bigger problem is that I can't restart pgagent service anymore.

I don't actually use pgagent for anything, so that's as much as I know.

If you're still stuck, try the pgadmin mailing list.

--
Josh Berkus
PostgreSQL Experts Inc.
http://pgexperts.com