gearman/docs/source/gearmand/queues/postgres.rst

========
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.