I have installed pgagent, apparently, but can't find it anywhere. I followed
the instructions...from the postgres database, opened the query window,
installed plpgsql (installed as expected), ran the pgagent script. Success
reported. If I try to run the same script, I'm notified that it's already
installed.

I expect to find a pgagent schema in the postgres database but it's not
there (only schema is public). There is no 'jobs' folder etc. I've restarted
pgadmin, refreshed etc, have looked with other postgres admin utils...so,
where is pgagent? Crazy question.
--
View this message in context: http://www.nabble.com/pgagent-instal...html#a12128275
Sent from the PostgreSQL - pgadmin support mailing list archive at Nabble.com.


---------------------------(end of broadcast)---------------------------
TIP 3: Have you checked our extensive FAQ?

http://www.postgresql.org/docs/faq

novnov wrote:
> I have installed pgagent, apparently, but can't find it anywhere. I followed
> the instructions...from the postgres database, opened the query window,
> installed plpgsql (installed as expected), ran the pgagent script. Success
> reported. If I try to run the same script, I'm notified that it's already
> installed.
>
> I expect to find a pgagent schema in the postgres database but it's not
> there (only schema is public). There is no 'jobs' folder etc. I've restarted
> pgadmin, refreshed etc, have looked with other postgres admin utils...so,
> where is pgagent? Crazy question.

The schema is considered a system object and is hidden by default on
1.6.x and under the catalogs node in 1.8.

You should see a Jobs node under the server on which you've installed
the schema (at the same level as databases, tablespaces, roles etc.). If
you don't try restarting pgAdmin. If you still don't, check that you
have the same database that you installed the pgAgent schema in set as
your maintenance database in the server properties dialog.

Regards, Dave

---------------------------(end of broadcast)---------------------------
TIP 2: Don't 'kill -9' the postmaster

I was using pgadmin 1.6.1 before, bundled with the windows postgres 8.2 I
have installed, now I've installed 1.6.3 separately, which seems to include
pgagent by default. Now both pgadmin installs show a jobs folder; not sure
if I could have missed that before or if the pgadmin 1.6.3 changed
something. Still no schema showing for pgagent. Not sure anyone needs to
comment on this, but while issue seems to be solved, would like to know, is
the schema supposed to be somewhere?


novnov wrote:
>
> I have installed pgagent, apparently, but can't find it anywhere. I
> followed the instructions...from the postgres database, opened the query
> window, installed plpgsql (installed as expected), ran the pgagent script.
> Success reported. If I try to run the same script, I'm notified that it's
> already installed.
>
> I expect to find a pgagent schema in the postgres database but it's not
> there (only schema is public). There is no 'jobs' folder etc. I've
> restarted pgadmin, refreshed etc, have looked with other postgres admin
> utils...so, where is pgagent? Crazy question.
>

--
View this message in context: http://www.nabble.com/pgagent-instal...html#a12128622
Sent from the PostgreSQL - pgadmin support mailing list archive at Nabble.com.


---------------------------(end of broadcast)---------------------------
TIP 9: In versions below 8.0, the planner will ignore your desire to
choose an index scan if your joining column's datatypes do not
match

novnov wrote:
> I was using pgadmin 1.6.1 before, bundled with the windows postgres 8.2 I
> have installed, now I've installed 1.6.3 separately, which seems to include
> pgagent by default. Now both pgadmin installs show a jobs folder; not sure
> if I could have missed that before or if the pgadmin 1.6.3 changed
> something.

No, pgAdmin itself doesn't change anything - it just looks for the schema.

> Still no schema showing for pgagent. Not sure anyone needs to
> comment on this, but while issue seems to be solved, would like to know, is
> the schema supposed to be somewhere?

It's there - switch on View System Objects and it should appear when the
tree is refreshed.

You shouldn't need to touch it directly though which is why it hides it
by default.

/D

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