Re: PGAdmin - still no jobs node.

On 15 November 2010 13:09, Piotr Czekalski <pczekalski(at)techbaza(dot)pl> wrote:

> I've installed the PgAgent over PostgreSQL 8.4.2(already running for few
> months), on Fedora 12 (x64) OS. The DB by itself works perfect. The script
> was taken from the Fedora's distro, running:
> ./psql -h <hostip> -d postgres --user postgres -f
> /usr/local/pgadmin3/share/pgadmin3/pgagent.sql and returned no errors (just
> warnings on creation of few sequences).
> The schema has been created in Postgres (management) database but still
> PgAdmin (1.12.1) shows only PgAgent under Catalogue node, there is no
> visible pgagent schema under Schema's node nor Jobs node to manage jobs.
> When I try to create pgagent schema it says such a schema already exists
> (which I believe is true).
> The user connecting to database is Postgres with DBA right thus I believe
> this is not a security problem, however.
>
> select * from pg_namespace;
>
> returns null value for nspacl column, where nspname='pgagent'.
>
> I've already followed the problem listed here:
> http://archives.postgresql.org/pgsql-general/2010-10/msg00621.php
> but still no luck as it seemed to be wrong database selected to install
> pgagent which is not the above case.
>
> Any help would be appreciated.
>
>
Have you got the jobs node enabled? This is done by going to File > Options
> Browser and ticking the "pgAgent Jobs" option.

--
Thom Brown
Twitter: @darkixion
IRC (freenode): dark_ixion
Registered Linux user: #516935