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. -- Guillaume. http://www.postgresqlfr.org http://dalibo.com ---------------------------(end of broadcast)--------------------------- TIP 4: Have you searched our list archives? http://archives.postgresql.org
