<div class="gmail_quote">On 15 November 2010 13:09, Piotr Czekalski <span dir="ltr"><<a
href="mailto:pczekalski@techbaza.pl">pczekalski@techbaza.pl</a>></span>wrote:<br /><blockquote class="gmail_quote"
style="margin:0pt 0pt 0pt 0.8ex; border-left: 1px solid rgb(204, 204, 204); padding-left: 1ex;"> I've installed the
PgAgentover PostgreSQL 8.4.2(already running for few months), on Fedora 12 (x64) OS. The DB by itself works perfect.
Thescript was taken from the Fedora's distro, running:<br /> ./psql -h <hostip> -d postgres --user postgres -f
/usr/local/pgadmin3/share/pgadmin3/pgagent.sqland returned no errors (just warnings on creation of few sequences).<br
/>The schema has been created in Postgres (management) database but still PgAdmin (1.12.1) shows only PgAgent under
Cataloguenode, there is no visible pgagent schema under Schema's node nor Jobs node to manage jobs.<br /> When I try to
createpgagent schema it says such a schema already exists (which I believe is true).<br /> The user connecting to
databaseis Postgres with DBA right thus I believe this is not a security problem, however.<br /><br /> select * from
pg_namespace;<br/><br /> returns null value for nspacl column, where nspname='pgagent'.<br /><br /> I've already
followedthe problem listed here:<br /><a href="http://archives.postgresql.org/pgsql-general/2010-10/msg00621.php"
target="_blank">http://archives.postgresql.org/pgsql-general/2010-10/msg00621.php</a><br/> but still no luck as it
seemedto be wrong database selected to install pgagent which is not the above case.<br /><br /> Any help would be
appreciated.<br/><br clear="all" /></blockquote></div><br />Have you got the jobs node enabled? This is done by going
toFile > Options > Browser and ticking the "pgAgent Jobs" option.<br /><br />-- <br />Thom Brown<br />Twitter:
@darkixion<br/> IRC (freenode): dark_ixion<br />Registered Linux user: #516935<br />
