| Lists: | pgsql-general |
|---|
| From: | eunice palmeira <e_palmeira(at)yahoo(dot)com(dot)br> |
|---|---|
| To: | alewis(at)themecca(dot)net, pgsql-general(at)postgreSQL(dot)org |
| Subject: | Temporal Event |
| Date: | 2002-07-03 13:20:50 |
| Message-ID: | 20020703132050.58830.qmail@web20605.mail.yahoo.com |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Lists: | pgsql-general |
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/
| From: | "Nigel J(dot) Andrews" <nandrews(at)investsystems(dot)co(dot)uk> |
|---|---|
| To: | eunice palmeira <e_palmeira(at)yahoo(dot)com(dot)br> |
| Cc: | alewis(at)themecca(dot)net, pgsql-general(at)postgreSQL(dot)org |
| Subject: | Re: Temporal Event |
| Date: | 2002-07-03 20:44:06 |
| Message-ID: | Pine.LNX.4.21.0207032141510.2828-100000@ponder.fairway2k.co.uk |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Lists: | pgsql-general |
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
| From: | Larry Rosenman <ler(at)lerctr(dot)org> |
|---|---|
| To: | eunice palmeira <e_palmeira(at)yahoo(dot)com(dot)br> |
| Cc: | alewis(at)themecca(dot)net, pgsql-general(at)postgresql(dot)org |
| Subject: | Re: Temporal Event |
| Date: | 2002-07-03 20:50:01 |
| Message-ID: | 1025729401.412.54.camel@lerlaptop.iadfw.net |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Lists: | pgsql-general |
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(at)lerctr(dot)org
US Mail: 1905 Steamboat Springs Drive, Garland, TX 75044-6749
| From: | nconway(at)klamath(dot)dyndns(dot)org (Neil Conway) |
|---|---|
| To: | eunice palmeira <e_palmeira(at)yahoo(dot)com(dot)br> |
| Cc: | alewis(at)themecca(dot)net, pgsql-general(at)postgreSQL(dot)org |
| Subject: | Re: Temporal Event |
| Date: | 2002-07-03 20:56:58 |
| Message-ID: | 20020703205658.GB13938@klamath.dyndns.org |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Lists: | pgsql-general |
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(at)rogers(dot)com>
PGP Key ID: DB3C29FC
| From: | Arjen van der Meijden <acm(at)tweakers(dot)net> |
|---|---|
| To: | pgsql-general(at)postgresql(dot)org |
| Subject: | Re: Temporal Event |
| Date: | 2002-07-03 21:06:09 |
| Message-ID: | afvovu$klc$1@news.tudelft.nl |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Lists: | pgsql-general |
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
| From: | Josh Jore <josh(at)lavendergreens(dot)org> |
|---|---|
| To: | eunice palmeira <e_palmeira(at)yahoo(dot)com(dot)br> |
| Cc: | alewis(at)themecca(dot)net, <pgsql-general(at)postgreSQL(dot)org> |
| Subject: | Re: Temporal Event |
| Date: | 2002-07-03 22:50:54 |
| Message-ID: | Pine.BSO.4.44.0207031750070.15912-100000@kitten.greentechnologist.org |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Lists: | pgsql-general |
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 gmea.
> http://br.encontros.yahoo.com/
>
>
>
> ---------------------------(end of broadcast)---------------------------
> TIP 3: if posting/reading through Usenet, please send an appropriate
> subscribe-nomail command to majordomo(at)postgresql(dot)org so that your
> message can get through to the mailing list cleanly
>
>
>