We really don't recommend PostgreSQL.

We've tried to get Flux to work with PostgreSQL and have only run into trouble. Everyone who has worked with Flux and PostgreSQL in the office strongly advises against it.

If possible, please use a different database.

That being said, here is what our software developer's manual says about PostgreSQL and Flux:

"Note: PostgreSQL is not a supported database. Flux is not tested against this database. Flux may not work correctly or at all with this database. However, if you would like to see if Flux works correctly with PostgreSQL, the following information may be helpful. The suggested mappings for PostgreSQL include the following mappings.

• BIT=BOOLEAN
  
• FLOAT=DOUBLE PRECISION
  
• VARBINARY=BYTEA
  
• VARCHAR=CHARACTER VARYING(128)
  

It is possible that the scheduler may not be able to create tables automatically in PostgreSQL. In that case, you must create your tables manually using the supplied DDL or DDL similar to it."