PostgresΒΆ
The current schema, as of .21 is:
CREATE TABLE <table> ( unique_key VARCHAR(GEARMAN_UNIQUE_SIZE),
function_name VARCHAR(255),
priority INTEGER,
data BYTEA,
when_to_run INTEGER,
UNIQUE (unique_key, function_name));
To start gearmand edit /etc/default/gearman-job-server to include:
export PGHOST=TheHostname
export PGPORT=5432
export PGUSER=gearman
export PGPASSWORD=ThePassword
export PGDATABASE=gearman
PARAMS="--verbose -q libpq --libpq-table=gearmanqueue1 --verbose"
This is Debian specific so you will need to adapt it to your distribution.