Dave Page a écrit :
> Guillaume Lelarge wrote:
>> Dave Page a écrit :
>>> Guillaume Lelarge wrote:
>>>> First, you'll need to install some stuff :
>>>> * create a postgres database ;
>>>> * change the pgagent.sql file (there's a dollar quote function that
>>>> disallow it to be used where pre-8.0 release) ;
>>>> * launch pgagent like this :
>>>> pgagent hostaddr=IP_ADDR dbname=postgres
>>> There's no need to run pgagent itself. All the changed code is in pgAdmin.
>>>
>>>> Then
>>>> * launch pgAdmin
>>>> * create a job (http://www.pgadmin.org/docs/dev/pgagent-jobs.html)
>>>>
>>>> To be honest, I don't find the pgagent interface when I use my 7.4 and
>>>> 8.1 cluster. This will take more time than I first thought.
>>> Make sure you run the SQL file in the maintenance DB.
>>>
>> I found the issue with your last email. The maintenance DB was still
>> template1.
>>
>> I can add a job but, even after a refresh, I can't see it. I only gave a
>> name to my job and click OK. So, it seems the SELECT DISTINCT returns
>> nothing.
>
> Rats - could have sworn I tested that but I must have done something
> stupid. Please try with SVN trunk - it should be OK now.
>
Works on 7.4 and 8.1. I'll commit my fix on the dollar quoting stuff if
you don't mind. It'll allow 7.4 users to use pgAgent.
--
Guillaume.
http://www.postgresqlfr.org
http://dalibo.com