Thread: Greenplum + pgagent

Greenplum + pgagent

From

kurics40

Date:

18 May 2013, 17:05:52

Does someone know how to integrate pgagent with Greenplum?

I could install it but it says that:

function cannot execute on segment because it issues a non-SELECT statement
(fucntion.c133) (seg0 localhost.localdomain:40000 pid=2780 (cdbisp.c1475)
 DETAIL SQL statement "UPDATE pgagent.pga_job SET jobnextrun = NULL WHERE
jobenalbed AND jobid=$1"

 PL/pgSQL function "pga_schedule_trigger" line 10 at SQL statement
<http://postgresql.1045698.n5.nabble.com/file/n5756084/pgadminIII.jpg>



--
View this message in context: http://postgresql.1045698.n5.nabble.com/Greenplum-pgagent-tp5756084.html
Sent from the PostgreSQL - pgadmin hackers mailing list archive at Nabble.com.

Re: Greenplum + pgagent

From

Dave Page

Date:

18 May 2013, 17:22:29

On Sat, May 18, 2013 at 3:05 PM, kurics40 <kurics40@freemail.hu> wrote:
> Does someone know how to integrate pgagent with Greenplum?
>
> I could install it but it says that:
>
> function cannot execute on segment because it issues a non-SELECT statement
> (fucntion.c133) (seg0 localhost.localdomain:40000 pid=2780 (cdbisp.c1475)
>  DETAIL SQL statement "UPDATE pgagent.pga_job SET jobnextrun = NULL WHERE
> jobenalbed AND jobid=$1"
>
>  PL/pgSQL function "pga_schedule_trigger" line 10 at SQL statement
> <http://postgresql.1045698.n5.nabble.com/file/n5756084/pgadminIII.jpg>

pgAgent cannot be used with Greenplum as the scheduling database I'm afraid.

--
Dave Page
Blog: http://pgsnake.blogspot.com
Twitter: @pgsnake

EnterpriseDB UK: http://www.enterprisedb.com
The Enterprise PostgreSQL Company