puppet manifest for postgres 9.2 on ubuntu

default.pp

exec {
  "apt-get update":
  path => "/usr/bin"
}

# manage_package_repo => true will satisfy apt_postgresql_org
# include postgresql::package_source::apt_postgresql_org

class { 'postgresql':
  version => '9.2',
  manage_package_repo => true,
  charset => 'UTF8',
  locale  => 'en_US.UTF-8'
}

class { 'postgresql::server':

}

postgresql::db { 'mydatabasename':
  user     => 'mydatabaseuser',
  password => 'mypassword'
}