Drupal is a very nice content management system which supports PostgreSQL. You can find a Drupal/PostgeSQL discussion group at http://groups.drupal.org/postgresql.