Pgadmin - Scheduling jobs

Author

Scheduling jobs

Poul Møller Hansen

2006-02-17, 7:26 am

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

---------------------------(end of broadcast)---------------------------
TIP 6: explain analyze is your friend

Dave Page

2006-02-17, 7:26 am

> -----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 someplace else.

Regards, Dave.

---------------------------(end of broadcast)---------------------------
TIP 6: explain analyze is your friend

Poul Møller Hansen

2006-02-17, 7:26 am

>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"

Poul

---------------------------(end of broadcast)---------------------------
TIP 1: if posting/reading through Usenet, please send an appropriate
subscribe-nomail command to majordomo@postgresql
.org so that your
message can get through to the mailing list cleanly

Dave Page

2006-02-17, 9:24 am

> -----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
>
>
> 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.

---------------------------(end of broadcast)---------------------------
TIP 4: Have you searched our list archives?

http://archives.postgresql.org

Dave Page

2006-02-17, 9:24 am

> -----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
>
>
> 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.

---------------------------(end of broadcast)---------------------------
TIP 5: don't forget to increase your free space map settings

Poul Møller Hansen

2006-02-17, 9:24 am

>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

---------------------------(end of broadcast)---------------------------
TIP 5: don't forget to increase your free space map settings

Sponsored Links