Skip site navigation (1) Skip section navigation (2)

Re: PgAgent does not works

From: Christophe Chauvet <christophe(dot)chauvet(at)aznetwork(dot)fr>
To: "Khan, Mahmood Ahram" <Mahmood(dot)Khan(at)in(dot)unisys(dot)com>
Cc: Dave Page <dpage(at)postgresql(dot)org>, Vishal Arora <aroravishal22(at)hotmail(dot)com>, pgadmin-support(at)postgresql(dot)org
Subject: Re: PgAgent does not works
Date: 2007-06-25 09:55:27
Message-ID: 467F910F.6010309@aznetwork.fr (view raw or flat)
Thread:
Lists: pgadmin-support
-----BEGIN PGP SIGNED MESSAGE-----
Hash: SHA1

Hi

Can you reinstall your services with logging enable (option -l)?

C:\Program Files\pgAdmin III\pgAgent INSTALL pgAgent -l 1 -u postgres -p secret hostaddr=127.0.0.1
dbname=postgres user=postgres

And check your Event Viewer.

Regards,

Christophe Chauvet.

Khan, Mahmood Ahram a écrit :
> I have also tried that. When i create a new job I think some rows should
> be written to the tables in the pgagent schema. But when I am checking
> physically the tables there is no data. Is that so due to service of
> pgagent.
> 
> Thanks & Best Regards
>  
> M.AHRAM KHAN 
> -----Original Message-----
> From: pgadmin-support-owner(at)postgresql(dot)org
> [mailto:pgadmin-support-owner(at)postgresql(dot)org] On Behalf Of Dave Page
> Sent: Monday, June 25, 2007 1:17 PM
> To: Vishal Arora
> Cc: pgadmin-support(at)postgresql(dot)org
> Subject: Re: [pgadmin-support] PgAgent does not works
> 
> Vishal Arora wrote:
>>
>>
>>> From: Dave Page <dpage(at)postgresql(dot)org>
>>> To: Vishal Arora <aroravishal22(at)hotmail(dot)com>
>>> CC: pgadmin-support(at)postgresql(dot)org
>>> Subject: Re: [pgadmin-support] PgAgent does not works
>>> Date: Sun, 24 Jun 2007 20:46:53 +0100
>>>
>>> Vishal Arora wrote:
>>>> Hi,
>>>>
>>>> I want to run some jobs in postgresql  database using pgAgent. I
> have 
>>>> installed PGAdmin III on my windows XP machine.
>>>>
>>>> I tried by scheduling small job like inserting data into a table.
> The 
>>>> job is created, I ahve scheduled to run every minute but it is not  
>>>> running at all. I can not see it in the statistics tab in pgAdmin as
> 
>>>> well. The job is shown in the pga_jobs table in pgagent schema. I 
>>>> have installed it as service and its running perfectly fine.
>>>>
>>>> Kindly let me know whats going wrong.
>>>>
>>> Are the pgAdmin maintenance DB, the DB containing the pgagent schema,
> 
>>> and the DB that pgagent connects to all the same one?
>> Yes it is the postgres database as mentioned in the installation
> guide.
> 
> Do you have anything listed in the host agent field? If so, please 
> remove it.
> 
> Regards, Dave.
> 
> ---------------------------(end of broadcast)---------------------------
> TIP 5: don't forget to increase your free space map settings
> 
> ---------------------------(end of broadcast)---------------------------
> TIP 1: if posting/reading through Usenet, please send an appropriate
>        subscribe-nomail command to majordomo(at)postgresql(dot)org so that your
>        message can get through to the mailing list cleanly
> 
> 
-----BEGIN PGP SIGNATURE-----
Version: GnuPG v1.4.2 (MingW32)

iD8DBQFGf5EOMl/S4ZhUIzERAh1BAJ44s/MwmWgE2RryzPQf/lKYopxxEwCfWdf1
R7QbXRICBYaG4DsDPGu/Vjs=
=Jp3Q
-----END PGP SIGNATURE-----

In response to

pgadmin-support by date

Next:From: Dave PageDate: 2007-06-25 10:01:25
Subject: Re: PgAgent does not works
Previous:From: Vishal AroraDate: 2007-06-25 09:53:05
Subject: Re: PgAgent does not works

Privacy Policy | About PostgreSQL
Copyright © 1996-2014 The PostgreSQL Global Development Group