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 ---------------------------(end of broadcast)--------------------------- TIP 3: Have you checked our extensive FAQ? http://www.postgresql.org/docs/faq
