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: (view raw or whole thread)
Lists: pgadmin-support
Hash: SHA1


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=
dbname=postgres user=postgres

And check your Event Viewer.


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
> -----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
Version: GnuPG v1.4.2 (MingW32)


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-2015 The PostgreSQL Global Development Group