Обсуждение: Scheduling jobs
It's probably a stupid question, but I haven't been able to find the answer I have added the pgagent schema to my database and pgagent is running, but I have no "Jobs" in the database view in pgAdmin. What can I do to add it ? PostgreSQL version: PostgreSQL 8.1.2 on i386-portbld-freebsd5.3, compiled by GCC cc (GCC) 3.4.2 [FreeBSD] 20040728 pgAdmin 1.4.1 binary version running WinXP. Thanks,Poul
> -----Original Message----- > From: pgadmin-support-owner@postgresql.org > [mailto:pgadmin-support-owner@postgresql.org] On Behalf Of > Poul Møller Hansen > Sent: 17 February 2006 13:08 > To: pgadmin-support@postgresql.org > Subject: [pgadmin-support] Scheduling jobs > > It's probably a stupid question, but I haven't been able to > find the answer > > I have added the pgagent schema to my database and pgagent is running, > but I have no "Jobs" in the database view in pgAdmin. > What can I do to add it ? The schema needs to be in your maintenance DB (ie. The one pgAdmin initially connects to). My guess is that you put it someplaceelse. Regards, Dave.
>The schema needs to be in your maintenance DB (ie. The one pgAdmin initially connects to). My guess is that you put it someplaceelse. > > > ahh, now it works :) How can I get with of the pgagent schema in the other database again ? I get the message "Cannot drop system Schema pgagent" Poul
> -----Original Message----- > From: pgadmin-support-owner@postgresql.org > [mailto:pgadmin-support-owner@postgresql.org] On Behalf Of > Poul Møller Hansen > Sent: 17 February 2006 13:20 > To: pgadmin-support@postgresql.org > Subject: Re: [pgadmin-support] Scheduling jobs > > > >The schema needs to be in your maintenance DB (ie. The one > pgAdmin initially connects to). My guess is that you put it > someplace else. > > > > > > > ahh, now it works :) > > How can I get with of the pgagent schema in the other database again ? > I get the message "Cannot drop system Schema pgagent" Ahh, that you be pgAdmin protecting you from yourself :-) Try the following in a Query Tool (in the appropriate database): DROP SCHEMA pgagent CASCADE; Regards, Dave.
>Ahh, that you be pgAdmin protecting you from yourself :-) > >Try the following in a Query Tool (in the appropriate database): > >DROP SCHEMA pgagent CASCADE; > > > Thanks again, I think only schemas starting with pg_ should behave like that. Do you think it's a bug in pgAdmin ? Poul
> -----Original Message----- > From: pgadmin-support-owner@postgresql.org > [mailto:pgadmin-support-owner@postgresql.org] On Behalf Of > Poul Møller Hansen > Sent: 17 February 2006 13:42 > To: pgadmin-support@postgresql.org > Subject: Re: [pgadmin-support] Scheduling jobs > > > >Ahh, that you be pgAdmin protecting you from yourself :-) > > > >Try the following in a Query Tool (in the appropriate database): > > > >DROP SCHEMA pgagent CASCADE; > > > > > > > Thanks again, I think only schemas starting with pg_ should > behave like > that. > Do you think it's a bug in pgAdmin ? No, it's intentional behaviour to stop your dropping the pgAgent schema in error. Regards, Dave.