Error: Puppet::Parser::AST::Resource failed with error ArgumentError: Invalid resource type with puppetlabs / puppetlabs-postgresql module

gistfile1.txt

test.pp:
$db = 'postgresql_test_db'
class { 'postgresql::server': }

postgresql::server::db { $db:
user     => $db,
password => postgresql_password($db, $db),}

When executed:

$puppet apply --modulepath=modules:static-modules /tmp/test.pp
Warning: Config file /etc/puppet/hiera.yaml not found, using Hiera defaults
Error: Puppet::Parser::AST::Resource failed with error ArgumentError: Invalid resource type postgresql::server::db at /tmp/test.pp:6 on node tools-poc.local
Wrapped exception:
Invalid resource type postgresql::server::db
Error: Puppet::Parser::AST::Resource failed with error ArgumentError: Invalid resource type postgresql::server::db at /tmp/test.pp:6 on node tools-poc.local

operatingsystem => Ubuntu
operatingsystemrelease => 12.04
osfamily => Debian