Dave Page a écrit : > Guillaume Lelarge wrote: >> 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. > > Rats - could have sworn I tested that but I must have done something > stupid. Please try with SVN trunk - it should be OK now. >
Works on 7.4 and 8.1. I'll commit my fix on the dollar quoting stuff if you don't mind. It'll allow 7.4 users to use pgAgent. -- 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
