postgres scheduler pgAgent
ghdrako edited this page Nov 7, 2023
·
2 revisions
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;
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 z poziomu pgAdmin jest zakladka/ikonka jobs i tam mozna konfigurowac joby i kiedy maja sie odpalac.
Test