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.
/D