On Mon, Nov 15, 2010 at 1:09 PM, Piotr Czekalski <pczekalski@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