Обсуждение: pgagent installed, but where?
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-installed%2C-but-where--tf4261875.html#a12128275 Sent from the PostgreSQL - pgadmin support mailing list archive at Nabble.com.
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
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-installed%2C-but-where--tf4261875.html#a12128622 Sent from the PostgreSQL - pgadmin support mailing list archive at Nabble.com.
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 thetree is refreshed. You shouldn't need to touch it directly though which is why it hides it by default. /D