Re: Job Scheduling

From: Andreas Kretschmer <akretschmer(at)spamfence(dot)net>
To: pgsql-novice(at)postgresql(dot)org
Subject: Re: Job Scheduling
Date: 2011-03-10 17:49:39
Message-ID: 20110310174939.GA14595@tux
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-novice

Majid Azimi <majid(dot)merkava(at)gmail(dot)com> wrote:

> Hi guys.
>
> Do we have a feature in postgresql so that we can schedule some
> activities? or we should use other tools.
> I want to add a job so that it creates a new table as a partition of
> main table each month
> and updates (INSERT, UPDATE, DELETE) triggers in the main table.
> Is there any feature to do this or i should use cron?

No and yes, you have to use cron.

Andreas
--
Really, I'm not out to destroy Microsoft. That will just be a completely
unintentional side effect. (Linus Torvalds)
"If I was god, I would recompile penguin with --enable-fly." (unknown)
Kaufbach, Saxony, Germany, Europe. N 51.05082°, E 13.56889°

In response to

Browse pgsql-novice by date

  From Date Subject
Next Message Francisco Leovey 2011-03-10 18:02:37 psql in postgres 9.0.3 not accepting password
Previous Message Steve Crawford 2011-03-10 17:48:53 Re: Job Scheduling