Puppet-postgresql is a project mainly written in ..., it's free.
A Puppet module for managing postgres - Centos 5.6 and postgres 9.04 ready