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.

Previous topic

MySQL

Next topic

SQLite