| From: | Dave Page <dpage(at)pgadmin(dot)org> |
|---|---|
| To: | kurics40 <kurics40(at)freemail(dot)hu> |
| Cc: | pgadmin-hackers <pgadmin-hackers(at)postgresql(dot)org> |
| Subject: | Re: Greenplum + pgagent |
| Date: | 2013-05-18 14:22:16 |
| Message-ID: | CA+OCxoxBKoCwFXiMDn7aEGESOexc+-0dAjm4t5TbZygRo4ukbw@mail.gmail.com |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Thread: | |
| Lists: | pgadmin-hackers |
On Sat, May 18, 2013 at 3:05 PM, kurics40 <kurics40(at)freemail(dot)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
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Dinesh Kumar | 2013-05-19 15:37:45 | Re: [pgadmin-hackers] Browser fixes |
| Previous Message | kurics40 | 2013-05-18 14:05:45 | Greenplum + pgagent |
