PostgreSQL with PostGIS2 extension - Puppet Example

postgresql-postgis.pp

# Install PostgreSQL 9.3 server from the PGDG repository
class {'postgresql::globals':
  version               => '9.3',
  manage_package_repo => true,
  encoding          => 'UTF8',
  locale          => 'it_IT.utf8',
}->
class { 'postgresql::server':
  ensure                  => 'present',
  listen_addresses        => '*',
  ip_mask_allow_all_users => '0.0.0.0/0',
  postgres_password       => 'PASSWORD',
}
class { 'postgresql::server::postgis':
}
# Install contrib modules
class { 'postgresql::server::contrib':
    package_ensure => 'present',
}

postgresql::server::db { 'FARlive':
  user     => 'FARLIVE',
  password => postgresql_password('FARLIVE', 'PASSWORD'),
}

postgresql::server::db { 'FARtest':
  user     => 'FARTEST',
  password => postgresql_password('FARTEST', 'PASSWORD'),
}

exec { "/usr/bin/psql -d FARtest -c 'CREATE EXTENSION postgis;'":
  user   => "postgres",
  unless => "/usr/bin/psql -d FARtest -c '\\dx' | grep postgis | grep -v postgis_topology",
}

exec { "/usr/bin/psql -d FARlive -c 'CREATE EXTENSION postgis;'":
  user   => "postgres",
  unless => "/usr/bin/psql -d FARlive -c '\\dx' | grep postgis | grep -v postgis_topology",
}

exec { "/usr/bin/psql -d FARtest -c 'CREATE EXTENSION postgis_topology;'":
  user   => "postgres",
  unless => "/usr/bin/psql -d FARtest -c '\\dx' | grep postgis_topology",
}

exec { "/usr/bin/psql -d FARlive -c 'CREATE EXTENSION postgis_topology;'":
  user   => "postgres",
  unless => "/usr/bin/psql -d FARlive -c '\\dx' | grep postgis_topology",
}