Turbine 2.x User's Guide: Using Turbine With PostgreSQL
Turbine ships with Torque as a persistence engine, although you can use any Object Model technology with Turbine.
For information on using Torque with PostgreSQL, please confer the Torque PostgreSQL FAQ.