database.pp
View Options

	# Define for creating a database. See README.md for more details.
	define postgresql::server::database(
	$comment = undef,
	$dbname = $title,
	$owner = undef,
	$tablespace = undef,
	$template = 'template0',
	$encoding = $postgresql::server::encoding,
	$locale = $postgresql::server::locale,
	$istemplate = false,
	$connect_settings = $postgresql::server::default_connect_settings,
	) {
	$createdb_path = $postgresql::server::createdb_path
	$user = $postgresql::server::user
	$group = $postgresql::server::group
	$psql_path = $postgresql::server::psql_path
	$default_db = $postgresql::server::default_database

	# If possible use the version of the remote database, otherwise
	# fallback to our local DB version
	if $connect_settings != undef and has_key( $connect_settings, 'DBVERSION') {
	$version = $connect_settings['DBVERSION']
	} else {
	$version = $postgresql::server::_version
	}

	# If the connection settings do not contain a port, then use the local server port
	if $connect_settings != undef and has_key( $connect_settings, 'PGPORT') {
	$port = undef
	} else {
	$port = $postgresql::server::port
	}

	# Set the defaults for the postgresql_psql resource
	Postgresql_psql {
	db => $default_db,
	psql_user => $user,
	psql_group => $group,
	psql_path => $psql_path,
	port => $port,
	connect_settings => $connect_settings,
	}

	# Optionally set the locale switch. Older versions of createdb may not accept
	# --locale, so if the parameter is undefined its safer not to pass it.
	if ($version != '8.1') {
	$locale_option = $locale ? {
	undef => '',
	default => "LC_COLLATE = '${locale}' LC_CTYPE = '${locale}'",
	}
	$public_revoke_privilege = 'CONNECT'
	} else {
	$locale_option = ''
	$public_revoke_privilege = 'ALL'
	}

	$template_option = $template ? {
	undef => '',
	default => "TEMPLATE = \"${template}\"",
	}

	$encoding_option = $encoding ? {
	undef => '',
	default => "ENCODING = '${encoding}'",
	}

	$tablespace_option = $tablespace ? {
	undef => '',
	default => "TABLESPACE = \"${tablespace}\"",
	}

	if $createdb_path != undef {
	warning('Passing "createdb_path" to postgresql::database is deprecated, it can be removed safely for the same behaviour')
	}

	postgresql_psql { "CREATE DATABASE \"${dbname}\"":
	command => "CREATE DATABASE \"${dbname}\" WITH ${template_option} ${encoding_option} ${locale_option} ${tablespace_option}",
	unless => "SELECT 1 FROM pg_database WHERE datname = '${dbname}'",
	require => Class['postgresql::server::service']
	}~>

	# This will prevent users from connecting to the database unless they've been
	# granted privileges.
	postgresql_psql { "REVOKE ${public_revoke_privilege} ON DATABASE \"${dbname}\" FROM public":
	refreshonly => true,
	}

	Postgresql_psql["CREATE DATABASE \"${dbname}\""]->
	postgresql_psql { "UPDATE pg_database SET datistemplate = ${istemplate} WHERE datname = '${dbname}'":
	unless => "SELECT 1 FROM pg_database WHERE datname = '${dbname}' AND datistemplate = ${istemplate}",
	}

	if $comment {
	# The shobj_description function was only introduced with 8.2
	$comment_information_function = $version ? {
	'8.1' => 'obj_description',
	default => 'shobj_description',
	}
	Postgresql_psql["CREATE DATABASE \"${dbname}\""]->
	postgresql_psql { "COMMENT ON DATABASE \"${dbname}\" IS '${comment}'":
	unless => "SELECT 1 FROM pg_catalog.pg_database d WHERE datname = '${dbname}' AND pg_catalog.${comment_information_function}(d.oid, 'pg_database') = '${comment}'",
	db => $dbname,
	}
	}

	if $owner {
	postgresql_psql { "ALTER DATABASE \"${dbname}\" OWNER TO \"${owner}\"":
	unless => "SELECT 1 FROM pg_database JOIN pg_roles rol ON datdba = rol.oid WHERE datname = '${dbname}' AND rolname = '${owner}'",
	require => Postgresql_psql["CREATE DATABASE \"${dbname}\""],
	}

	if defined(Postgresql::Server::Role[$owner]) {
	Postgresql::Server::Role[$owner]->Postgresql_psql["ALTER DATABASE \"${dbname}\" OWNER TO \"${owner}\""]
	}
	}

	if $tablespace {
	postgresql_psql { "ALTER DATABASE \"${dbname}\" SET ${tablespace_option}":
	unless => "SELECT 1 FROM pg_database JOIN pg_tablespace spc ON dattablespace = spc.oid WHERE datname = '${dbname}' AND spcname = '${tablespace}'",
	require => Postgresql_psql["CREATE DATABASE \"${dbname}\""],
	}

	if defined(Postgresql::Server::Tablespace[$tablespace]) {
	# The tablespace must be there, before we create the database.
	Postgresql::Server::Tablespace[$tablespace]->Postgresql_psql["CREATE DATABASE \"${dbname}\""]
	}
	}
	}

File Metadata

Mime Type: text/plain
Expires: Jul 4 2025, 9:53 AM (5 w, 1 d ago)
Storage Engine: blob
Storage Format: Raw Data
Storage Handle: 3452513

database.pp
No OneTemporary
Actions

database.pp
View Options

File Metadata

Event Timeline

database.ppNo OneTemporaryActions

database.ppView Options

File Metadata

Event Timeline

database.pp
No OneTemporary
Actions

database.pp
View Options