From: | Raymond O'Donnell <rod(at)iol(dot)ie> |
---|---|
To: | 'PostgreSQL' <pgsql-general(at)postgresql(dot)org> |
Subject: | Re: Question] |
Date: | 2009-07-13 14:53:35 |
Message-ID: | 4A5B4A6F.1080300@iol.ie |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-general |
On 13/07/2009 09:02, hendra kusuma wrote:
> On Sat, Jul 11, 2009 at 9:03 PM, Raymond O'Donnell <rod(at)iol(dot)ie> wrote:
>
>> On 10/07/2009 21:56, Jorge Arangoitia Fernandez Baca wrote:
>>
>>> I want to know if you can create a store procedure that run
>>> automatically after a certain time, something like a timer in java. If
>>> it exists, could you tell me how it is implemented??
>> Put your function in a file, and then create a cron job that runs psql
>> taking its input from the file:
>>
>> psql -f <your_file> <your-database>
>>
>> Ray.
>>
>
> Ray, you forgot to mention that cron only work under Linux :)
Yeah, but you didn't say what OS you're on! :-)
For Windows (if that's what you're using) there are various
implementations of cron - one I like and use is pycron:
http://www.kalab.com/freeware/pycron/pycron.htm
...much nicer than trying to get the Windows scheduler to cooperate.
There's also pgAgent.
Ray.
------------------------------------------------------------------
Raymond O'Donnell, Director of Music, Galway Cathedral, Ireland
rod(at)iol(dot)ie
Galway Cathedral Recitals: http://www.galwaycathedral.org/recitals
------------------------------------------------------------------
From | Date | Subject | |
---|---|---|---|
Next Message | Andreas | 2009-07-13 14:53:58 | Re: Postgres 8.4 literal escaping |
Previous Message | Thomas Kellerer | 2009-07-13 14:51:29 | Re: Start With... Connect By? |