Guillaume Lelarge a écrit :
> 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.
>
>
I forgot to mention that this test was done using PostgreSQL 8.1 (latest
CVS checkout).
--
Guillaume.
http://www.postgresqlfr.org
http://dalibo.com