postgres scheduler pgAgent - ghdrako/doc_snipets GitHub Wiki

• https://www.pgadmin.org/docs/pgadmin4/latest/pgagent_install.html

pgAgent is not supported in google cloud nor Amazon.

CREATE EXTENSION pgagent;

This command will create a number of tables and other objects in a schema called ‘pgagent’.

The database must also have the pl/pgsql procedural language installed - use the PostgreSQL CREATE LANGUAGE command to install pl/pgsql if necessary.

CREATE LANGUAGE plpgsql;

Daemon installation on Unix

Install the pgAgent daemon on a Unix system as demon or service in windows. pgAgent is available in Debian/Ubuntu (DEB) and Redhat/Fedora (RPM) packages for Linux users.

Konfiguracja

Konfiguracja z poziomu pgAdmin jest zakladka/ikonka jobs i tam mozna konfigurowac joby i kiedy maja sie odpalac.