Обсуждение: Temporal Event
Hi, I would like to trigger a rule every day in the specific periodic time, such as: at 12:00 pm, in Postgresql. But i don't know if it is possible. Help me please. Eunice Palmeira -- Maceió AL - Brasil _______________________________________________________________________ Yahoo! Encontros O lugar certo para encontrar a sua alma gêmea. http://br.encontros.yahoo.com/
On Wed, 3 Jul 2002, eunice palmeira wrote: > Hi, > I would like to trigger a rule every day in the > specific periodic time, such as: at 12:00 pm, in > Postgresql. But i don't know if it is possible. Help > me please. > Eunice Palmeira -- Maceió AL - Brasil I don't believe this is possible from within the server. Your best bet is to use a client program kicked off by a crontab entry. I think Oracle does have such a facility though. Does anyone know and is it something that should be added to Postgres? -- Nigel J. Andrews Director --- Logictree Systems Limited Computer Consultants
On Wed, 2002-07-03 at 08:20, eunice palmeira wrote: > Hi, > I would like to trigger a rule every day in the > specific periodic time, such as: at 12:00 pm, in > Postgresql. But i don't know if it is possible. Help > me please. man crontab Cron is your friend here. Just write a cronjob that invokes psql and the appropriate SQL statement(s). I do this with some of my daily maintenance stuff. -- Larry Rosenman http://www.lerctr.org/~ler Phone: +1 972-414-9812 E-Mail: ler@lerctr.org US Mail: 1905 Steamboat Springs Drive, Garland, TX 75044-6749
On Wed, Jul 03, 2002 at 10:20:50AM -0300, eunice palmeira wrote: > Hi, > I would like to trigger a rule every day in the > specific periodic time, such as: at 12:00 pm, in > Postgresql. But i don't know if it is possible. Help > me please. Use cron. PostgreSQL currently doesn't support periodic command scheduling (and a good argument can be made that it shouldn't, since we'd just be rewriting cron inside PostgreSQL). Cheers, Neil -- Neil Conway <neilconway@rogers.com> PGP Key ID: DB3C29FC
This is a problem for your cron daemon. Look outside of postgresql for the solution to this one. Joshua b. Jore ; http://www.greentechnologist.org On Wed, 3 Jul 2002, [iso-8859-1] eunice palmeira wrote: > Hi, > I would like to trigger a rule every day in the > specific periodic time, such as: at 12:00 pm, in > Postgresql. But i don't know if it is possible. Help > me please. > Eunice Palmeira -- Macei� AL - Brasil > > _______________________________________________________________________ > Yahoo! Encontros > O lugar certo para encontrar a sua alma g�mea. > http://br.encontros.yahoo.com/ > > > > ---------------------------(end of broadcast)--------------------------- > TIP 3: if posting/reading through Usenet, please send an appropriate > subscribe-nomail command to majordomo@postgresql.org so that your > message can get through to the mailing list cleanly > > >
Can't you just run a cronjob executing a query? Something like this in your crontab: 0 12 * * * su - postgres -c "psql < your.job.sql" eunice palmeira wrote: > Hi, > I would like to trigger a rule every day in the > specific periodic time, such as: at 12:00 pm, in > Postgresql. But i don't know if it is possible. Help > me please. > Eunice Palmeira -- Maceió AL - Brasil