Query: pgagent
OS: debian
Section: 1
Format: Original Unix Latex Style Formatted with HTML and a Horizontal Scroll Bar
pgagent(1) General Commands Manual pgagent(1)NAMEpgAgent - a job scheduler for PostgreSQL.SYNOPSISpgagent [-f | -t seconds | -r seconds | -l number] {<connect string>}DESCRIPTIONIntroduced in pgAdmin III v1.4, pgAgent is a job scheduling agent for PostgreSQL, capable of running multi-step batch/shell and SQL tasks on complex schedules. Full documentation of pgAgent is available in pgAdmin III's online help. Launch pgAdmin III (simply type pgadmin3 at command prompt) and select "Help..." from the "Help" menu. Browse through the pgAdmin III documentation until you find "pgAgent". Both database setup and sys- tem part of the installation are detailed. You will also find instructions to create jobs and schedules.OPTIONS-f run in the foreground (do not detach from the terminal) -t seconds poll time interval in seconds (default 10) -r seconds retry period after connection abort in seconds (>=10, default 30) -l verbosity logging verbosity (ERROR=0, WARNING=1, DEBUG=2, default 0) <connect string> The connect string required is a standard PostgreSQL libpq connection string (see the PostgreSQL documentation for further details). For example, the following command line will run pgAgent against a server listening on the localhost, using a database called 'pgad- min', connecting as the user 'postgres': /usr/bin/pgagent hostaddr=127.0.0.1 dbname=pgadmin user=postgresSEE ALSOpgadmin3(1)AUTHORSThe content of this manual page was mostly ripped from documentation written by the pgAdmin development team. It was built by Raphael Enrici <blacknoz@club-internet.fr> for the Debian project (but may be used by others). December 26, 2005 pgagent(1)