From: | <mabra(at)manfbraun(dot)de> |
---|---|
To: | <mabra(at)manfbraun(dot)de> |
Cc: | <pgsql-general(at)postgresql(dot)org> |
Subject: | Re: Looking for auto starting procedures |
Date: | 2010-12-02 18:32:23 |
Message-ID: | !&!AAAAAAAAAAAYAAAAAAAAAOb5xiPoTM8RjQUAgEiElinCgAAAEAAAAB3rS02/93BIgmeTNxF1pRcBAAAAAA==@manfbraun.de |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-general |
Hello !
And thanks to all, for answers.
Naturally, cron does not operate on DB tables and if I add/remove/change
a line in a control table dynamically, cron would not notice that ;-)
So I had to write a daemon, which acts on that table. This might happen
about ~5 - 20 seconds and cron is operates on minutes only.
An auto running stored procedure would solve the problem, if therewould be
a way to run this procedure on server startup automatically
[as it looks, write another daemon for this].
The usual notification from postgreSQL does not allow to write
an [own, better to evaluate] identifier in the syslog. This is
not a matter of the syslog daemon, its on the program which logs.
May be, I have just not found this.
Wished, my migration would a bit easier ;-)
br++mabra
-----Original Message-----
From: pgsql-general-owner(at)postgresql(dot)org
[mailto:pgsql-general-owner(at)postgresql(dot)org] On Behalf Of Robert Gravsjö
Sent: Thursday, December 02, 2010 1:24 PM
To: mabra(at)manfbraun(dot)de
Cc: pgsql-general(at)postgresql(dot)org
Subject: Re: [GENERAL] Looking for auto starting procedures
On 2010-12-01 16.16, mabra(at)manfbraun(dot)de wrote:
> Hello !
>
> I am coming from Sql Server right now and have to learn about the
> infrastructure.
>
> What I missed first, is, to execute procedures regularly/repeatedly
> on a given time. I want to prevent my to write a lot external
> programs und use cron :-(
cron is the standard way of scheduling reoccurring jobs on *nix systems.
It's preferable to having each daemon implement scheduling on its own.
>
> The othing thing is, that I need some internally running procedures, which
> do some work. On Sql Server, I can use "auto-start stored procedures".
> Is there anything like this in postgresql, or what can I do?
Is this long running processes, i.e daemons, or is it scheduled processes?
For long running I would recommend writing a proper daemon.
For scheduled I'd recommend cron or at.
>
> And, is it just possible, to put a message to the syslog and with
> my own identification string?
I'm pretty sure you can accomplish this in configuration if you're using
syslog-ng. Other syslog alternatives probably has similar possibilities.
--
Regards,
Robert "roppert" Gravsjö
From | Date | Subject | |
---|---|---|---|
Next Message | Andrus | 2010-12-02 19:11:14 | Re: How to find correct locale name for CREATEDATABASE |
Previous Message | Alban Hertroys | 2010-12-02 18:30:35 | Re: How to find correct locale name for CREATEDATABASE |