Job scheduling in Postgre
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.<BR><BR>with regards, <BR><BR>I.P.S. Sethi <BR>
On 02/12/2008 11:45, IPS wrote:
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.
cron?
Ray.
------------------------------------------------------------------
Raymond O'Donnell, Director of Music, Galway Cathedral, Ireland
rod@iol.ie
Galway Cathedral Recitals: http://www.galwaycathedral.org/recitals
------------------------------------------------------------------
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).
Andreas
--
Andreas Kretschmer
Kontakt: Heynitz: 035242/47150, D1: 0160/7141639 (mehr: -> Header)
GnuPG-ID: 0x3FFF606C, privat 0x7F4584DA http://wwwkeys.de.pgp.net
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.
--
Robert Treat
Conjecture: http://www.xzilla.net
Consulting: http://www.omniti.com
On Thu, Dec 4, 2008 at 3:50 PM, Robert Treat
<xzilla@users.sourceforge.net> 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.
It would need to be ported to C first (it's currently wxWidgets/C++).
We are packaging it separately now though.
http://www.pgadmin.org/docs/1.8/pgagent.html
http://www.pgadmin.org/download/pgagent.php
--
Dave Page
EnterpriseDB UK: http://www.enterprisedb.com
am Thu, dem 04.12.2008, um 10:50:38 -0500 mailte Robert Treat folgendes:
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
How does it work? Independent from the OS? On the server, within
PostgreSQL?
Andreas
--
Andreas Kretschmer
Kontakt: Heynitz: 035242/47150, D1: 0160/7141639 (mehr: -> Header)
GnuPG-ID: 0x3FFF606C, privat 0x7F4584DA http://wwwkeys.de.pgp.net
On Thu, Dec 4, 2008 at 4:21 PM, A. Kretschmer
<andreas.kretschmer@schollglas.com> wrote:
am Thu, dem 04.12.2008, um 10:50:38 -0500 mailte Robert Treat folgendes:
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 aHow does it work? Independent from the OS? On the server, within
PostgreSQL?
It runs as a service on Windows or daemon on *nix, and connects to a
pgagent schema in a database which may or may not be on the same
machine.
You can define jobs using pgAdmin (the definitions of which are stored
in the database) which consist of one or more SQL or batch/shell
steps. A job can be targetted at a particular server, so you can
ensure batch steps run on a Windows box, and shell on a unix, or can
be run by the first (or only) pgAgent instance that picks it up. SQL
steps currently target a specific database, and in future releases
will be able to target databases on alternate servers - a feature
required for use with hot standby servers.
Each job can have one or more schedules attached to it. Schedules are
defined in a vaguely cron-like way, and include date/time based
exception rules (so you can do things like 'run every day except for
the 25/12/2008'.
See http://www.pgadmin.org/docs/1.8/pgagent.html for more info, and screenshots.
--
Dave Page
EnterpriseDB UK: http://www.enterprisedb.com
am Thu, dem 04.12.2008, um 16:40:38 +0000 mailte Dave Page folgendes:
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 aHow does it work? Independent from the OS? On the server, within
PostgreSQL?It runs as a service on Windows or daemon on *nix, and connects to a
pgagent schema in a database which may or may not be on the same
machine.You can define jobs using pgAdmin (the definitions of which are stored
in the database) which consist of one or more SQL or batch/shell
steps. A job can be targetted at a particular server, so you can
ensure batch steps run on a Windows box, and shell on a unix, or can
be run by the first (or only) pgAgent instance that picks it up. SQL
steps currently target a specific database, and in future releases
will be able to target databases on alternate servers - a feature
required for use with hot standby servers.
Thx for the explanation.
Andreas
--
Andreas Kretschmer
Kontakt: Heynitz: 035242/47150, D1: 0160/7141639 (mehr: -> Header)
GnuPG-ID: 0x3FFF606C, privat 0x7F4584DA http://wwwkeys.de.pgp.net
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.
