Dear Sean, Lewis and Regina,
Many thanks for your suggestions. It looks there are several options
doing automatic tasks on PostgreSQL.
I found that Windows has a task scheduler. I tried to use it but still
have problem in connecting with the server (and database). I may need
to learn setting the correct parameters.
I will try to use the PgAgent or nncronlite as they seem to be better
options. I hope you would help me again if I have further questions.
On Tue, Jul 1, 2008 at 8:30 PM, Obe, Regina <robe(dot)dnd(at)cityofboston(dot)gov> wrote:
> --- On Fri, 6/27/08, Sean Davis <sdavis2(at)mail(dot)nih(dot)gov> wrote:
>>> Postgresql doesn't have tools to do that directly. If
>>> you are on
>>> Linux or Unix, you can use cron; Windows probably has
>>> similar to automate tasks.
>> I use nncron lite. Free and cron file compatible.
>> Lewis R Cunningham
>> An Expert's Guide to Oracle Technology
>> Postgres Forums
> Actually you can use PgAgent which comes packaged with PgAdmin III.
> I've used it successfully on both windows and RedHat linux. I think it
> works anywhere PostgreSQL works. The nice thing about PgAgent is that
> you can see the status of jobs from the PgAdmin administrative tool and
> trigger a manual run of a scheduled job from PgAdmin tool from anywhere.
> Hope that helps,
> The substance of this message, including any attachments, may be
> confidential, legally privileged and/or exempt from disclosure
> pursuant to Massachusetts law. It is intended
> solely for the addressee. If you received this in error, please
> contact the sender and delete the material from any computer.
In response to
pgsql-novice by date
|Next:||From: Netzach||Date: 2008-07-02 10:21:01|
|Subject: Calculating repeating events - functionality lost with the demise
of tinterval ?|
|Previous:||From: Ridvan Lakas ng Bayan S. Baluyos||Date: 2008-07-02 08:54:08|
|Subject: Table exists but can't drop.|