On Mon, Nov 15, 2010 at 1:09 PM, Piotr Czekalski <pczekal...@techbaza.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.
Can you confirm that the management database in pgAdmin is set to the postgres database for the appropriate server? -- Dave Page Blog: http://pgsnake.blogspot.com Twitter: @pgsnake EnterpriseDB UK: http://www.enterprisedb.com The Enterprise PostgreSQL Company -- Sent via pgadmin-support mailing list (pgadmin-support@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgadmin-support