1 class { 'postgresql::server':
3 'ip_mask_deny_postgres_user' => '0.0.0.0/32',
4 'ip_mask_allow_all_users' => '0.0.0.0/0',
5 'listen_addresses' => '*',
6 'manage_redhat_firewall' => true,
7 'postgres_password' => 'postgres',
12 ensure => 'directory',
14 file { '/tmp/pg_tablespaces':
15 ensure => 'directory',
19 require => File['/tmp'],
22 postgresql::tablespace{ 'tablespace1':
23 location => '/tmp/pg_tablespaces/space1',
24 require => [Class['postgresql::server'], File['/tmp/pg_tablespaces']],
26 postgresql::database{ 'tablespacedb1':
27 # TODO: ensure not yet supported
30 require => Class['postgresql::server'],
32 postgresql::database{ 'tablespacedb2':
33 # TODO: ensure not yet supported
36 tablespace => 'tablespace1',
37 require => Postgresql::Tablespace['tablespace1'],
39 postgresql::db{ 'tablespacedb3':
40 # TODO: ensure not yet supported
43 password => 'dbuser1',
44 require => Class['postgresql::server'],
46 postgresql::db{ 'tablespacedb4':
47 # TODO: ensure not yet supported
50 password => 'dbuser2',
51 tablespace => 'tablespace1',
52 require => Postgresql::Tablespace['tablespace1'],
55 postgresql::database_user{ 'spcuser':
56 # TODO: ensure is not yet supported
58 password_hash => postgresql_password('spcuser', 'spcuser'),
59 require => Class['postgresql::server'],
61 postgresql::tablespace{ 'tablespace2':
62 location => '/tmp/pg_tablespaces/space2',
64 require => [Postgresql::Database_user['spcuser'], File['/tmp/pg_tablespaces']],
66 postgresql::database{ 'tablespacedb5':
67 # TODO: ensure not yet supported
70 tablespace => 'tablespace2',
71 require => Postgresql::Tablespace['tablespace2'],