Обсуждение: Not found pgAgent Jobs in pgAdmin

Поиск
Список
Период
Сортировка

Not found pgAgent Jobs in pgAdmin

От
"Sabin Coanda"
Дата:
Hi there,
 
I have the database "MyDBTest" on my local server.
 
I installed pgAgent service on my local PC with the following command:
"D:\Program Files\PostgreSQL\8.2\bin\pgAgent.exe" INSTALL pgAgent_MyDBTest -u postgres -p xxx hostaddr=127.0.0.1 dbname="MyDBTest" user=postgres
 
The service is running well an I don't find any error messages in the event logs.
 
The problem is that I don't find Jobs node in pgAdmin.
 
I use the following environment:
  • Windows XP sp2
  • English language
  • "PostgreSQL 8.2.3 on i686-pc-mingw32, compiled by GCC gcc.exe (GCC) 3.4.2 (mingw-special)"
  • pgAdmin v.1.6.2( Jan 6 2007, rev:5837)
TIA,
Sabin

Re: Not found pgAgent Jobs in pgAdmin

От
Dave Page
Дата:
Sabin Coanda wrote:
> Hi there,
>  
> I have the database "MyDBTest" on my local server.
>  
> I installed pgAgent service on my local PC with the following command:
> "D:\Program Files\PostgreSQL\8.2\bin\pgAgent.exe" INSTALL
> pgAgent_MyDBTest -u postgres -p xxx hostaddr=127.0.0.1 dbname="MyDBTest"
> user=postgres
>  
> The service is running well an I don't find any error messages in the
> event logs.
>  
> The problem is that I don't find Jobs node in pgAdmin.
>  
> I use the following environment:
> 
>     * Windows XP sp2
>     * English language
>     * "PostgreSQL 8.2.3 on i686-pc-mingw32, compiled by GCC gcc.exe
>       (GCC) 3.4.2 (mingw-special)"
>     * pgAdmin v.1.6.2( Jan 6 2007, rev:5837)

You must run the pgAgent SQL script in the same database that pgAgent
connects to and pgAdmin uses as it's maintenance DB. Normally this would
be the postgres database.

Regards, Dave