Supported permissions are bypassrls,Ĭreatedb, createrole, login, replication and Roles to control who has access to which objects. (for example, tables) and can assign privileges on those objects to other Users, depending on how the role is set up. PostgreSQL manages database access permissions using the concept of roles.Ī role can be thought of as either a database user, or a group of database ( service-extension postgresql-role-service-type ( const ( postgresql-role ( name "alice") ( create-database? #t)))) Data Type: postgresql-role This service allows to create PostgreSQL roles and databases after Scheme Variable: postgresql-role-service-type Numeric with Unit and Enumerated described PostgreSQL parameters types Boolean, String, Numeric, The values can be numbers, booleans or strings and will be mapped to The key, and the remaining elements are the values. Each entry in the list should be a list where the first element is List of additional keys and values to include in the PostgreSQL configįile. TCP/IP sockets can be used to connect to the server.īy default, the #false value means the PostgreSQL default value will PostgreSQL does not listen on any Unix-domain sockets, in which case only To listen for connections from client applications. Specifies the directory of the Unix-domain socket(s) on which PostgreSQL is Ident-file (default: %default-postgres-ident)įilename or G-expression for the user name mapping configuration. Hba-file (default: %default-postgres-hba)įilename or G-expression for the host-based authentication configuration. The logging method to use for PostgreSQL. Host all all ::1/128 md5")) ( extra-config ' ( ( "session_preload_libraries" "auto_explain") ( "random_page_cost" 2) ( "auto_explain.log_min_duration" "100 ms") ( "work_mem" "500 MB") ( "logging_collector" #t) ( "log_directory" "/var/log/postgresql"))))))) log-destination (default: "syslog") ( service postgresql-service-type ( postgresql-configuration ( config-file ( postgresql-config-file ( log-destination "stderr") ( hba-file ( plain-file "pg_hba.conf" " Instance, to create a geographic database using the postgisĮxtension, a user can configure the postgresql-service as in this example: This file can be useful to debug PostgreSQLĭata-directory (default: "/var/lib/postgresql/data")Īdditional extensions are loaded from packages listed inĮxtension-packages.
The directory where pg_ctl output will be written in a file named Log-directory (default: "/var/log/postgresql") The defaultīehaviour uses the postgresql-config-file record with the default values for The configuration file to use when running PostgreSQL.
Locale to use as the default when creating the database cluster.Ĭonfig-file (default: (postgresql-config-file)) PostgreSQL package to use for the service. Createdb $MY_USER_LOGIN # Replace appropriately.ĭata type representing the configuration for the
0 kommentar(er)
