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 ---------------------------(end of broadcast)--------------------------- TIP 6: explain analyze is your friend
