Re: Job scheduling in Postgre

From: Jason Long <mailing(dot)list(at)supernovasoftware(dot)com>
To: Robert Treat <xzilla(at)users(dot)sourceforge(dot)net>
Cc: pgsql-general(at)postgresql(dot)org, "A(dot) Kretschmer" <andreas(dot)kretschmer(at)schollglas(dot)com>, IPS <sethi(at)nic(dot)in>
Subject: Re: Job scheduling in Postgre
Date: 2008-12-04 22:54:38
Message-ID: 49385FAE.4060105@supernovasoftware.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

Robert Treat wrote:
> On Tuesday 02 December 2008 07:11:02 A. Kretschmer wrote:
>
>> am Tue, dem 02.12.2008, um 16:45:16 +0500 mailte IPS folgendes:
>>
>>> I have certain jobs to be executed automatically at a given interval of
>>> time in the postgre SQL database. Is their any utility/feature available
>>> in Postgre to do so.
>>>
>> No, use the scheduler from the OS, CRON for example (UNIX).
>>
>>
>
> There is a database level schedular called (iirc) pgAgent, which comes bundled
> with pgAdmin. I think it's so well hidden because it comes as a part of a
> tool which is only used by a small subset of the community. I had hopes that
> it might follow autovacuums path and get moved into a contrib module and
> possibly integrated into the backend some day, but I haven't seen much push
> in that direction.
>
>
What is everyone using instead of pgAdmin?
In production I only use ssh and psql, but in development I do use pgAdmin.

In response to

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Scott Marlowe 2008-12-05 01:30:07 Re: Job scheduling in Postgre
Previous Message David Fetter 2008-12-04 19:21:45 Re: cumulative count