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 a > > > > How 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 -- Sent via pgsql-general mailing list (pgsql-general@xxxxxxxxxxxxxx) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-general
