| services.postgresql.enable | Whether to enable PostgreSQL Server.
|
| services.postgresql.enableJIT | Whether to enable JIT support.
|
| services.postgresql.package | The package being used by postgresql.
|
| services.postgresql.initdbArgs | Additional arguments passed to initdb during data dir
initialisation.
|
| services.immich.database.enable | Whether to enable the postgresql database for use with immich
|
| services.postgresql.checkConfig | Check the syntax of the configuration file at compile time
|
| services.postgresql.dataDir | The data directory for PostgreSQL
|
| services.postgresql.finalPackage | The postgresql package that will effectively be used in the system
|
| services.postgresql.initialScript | A file containing SQL statements to execute on first startup.
|
| services.postgresql.enableTCPIP | Whether PostgreSQL should listen on all network interfaces
|
| services.postgresql.identMap | Defines the mapping from system users to database users
|
| services.postgresql.extensions | List of PostgreSQL extensions to install.
|
| services.postgresql.settings | PostgreSQL configuration
|
| services.postgresql.ensureUsers | Ensures that the specified users exist
|
| services.postgresql.ensureDatabases | Ensures that the specified databases exist
|
| services.hockeypuck.settings | Configuration file for hockeypuck, here you can override
certain settings (loglevel and
openpgp.db.dsn) by just setting those values
|
| services.postgresql.systemCallFilter | Configures the syscall filter for postgresql.service
|
| services.postgresql.authentication | Defines how users authenticate themselves to the server
|
| services.postgresqlBackup.backupAll | Backup all databases using pg_dumpall
|
| services.postgresql.ensureUsers.*.ensureDBOwnership | Grants the user ownership to a database with the same name
|
| services.postgresql.settings.port | The port on which PostgreSQL listens.
|
| services.postgresqlBackup.enable | Whether to enable PostgreSQL dumps.
|
| services.postgresql.ensureUsers.*.name | Name of the user to ensure.
|
| services.postgresqlBackup.startAt | This option defines (see systemd.time for format) when the
databases should be dumped
|
| services.postgresql.systemCallFilter.<name>.enable | Whether to enable ‹name› in postgresql's syscall filter.
|
| services.postgresqlBackup.location | Path of directory where the PostgreSQL database dumps will be placed.
|
| services.postgresqlBackup.databases | List of database names to dump.
|
| services.postgresqlBackup.pgdumpAllOptions | Command line options for pg_dumpall
|
| services.postgresqlBackup.pgdumpOptions | Command line options for pg_dump
|
| services.postgresqlWalReceiver.receivers | PostgreSQL WAL receivers
|
| services.postgresqlBackup.compression | The type of compression to use on the generated database dump.
|
| services.postgresql.ensureUsers.*.ensureClauses | An attrset of clauses to grant to the user
|
| services.postgresql.systemCallFilter.<name>.priority | Set the priority of the system call filter setting
|
| services.postgresqlBackup.compressionLevel | The compression level used when compression is enabled.
gzip accepts levels 1 to 9. zstd accepts levels 1 to 19.
|
| services.postgresqlWalReceiver.receivers.<name>.extraArgs | A list of extra arguments to pass to the pg_receivewal command.
|
| services.postgresqlWalReceiver.receivers.<name>.postgresqlPackage | The postgresql package to use.
|
| services.postgresql.ensureUsers.*.ensureClauses.inherit | Grants the user created inherit permissions
|
| services.postgresql.ensureUsers.*.ensureClauses.login | Grants the user, created by the ensureUser attr, login permissions
|
| services.postgresql.ensureUsers.*.ensureClauses.createdb | Grants the user, created by the ensureUser attr, createdb permissions
|
| services.postgresqlWalReceiver.receivers.<name>.directory | Directory to write the output to.
|
| services.postgresqlWalReceiver.receivers.<name>.compress | Enables gzip compression of write-ahead logs, and specifies the compression level
(0 through 9, 0 being no compression and 9 being best compression)
|
| services.postgresqlWalReceiver.receivers.<name>.slot | Require pg_receivewal to use an existing replication slot (see
Section 26.2.6 of the PostgreSQL manual)
|
| services.postgresql.ensureUsers.*.ensureClauses.bypassrls | Grants the user, created by the ensureUser attr, replication permissions
|
| services.postgresql.ensureUsers.*.ensureClauses.superuser | Grants the user, created by the ensureUser attr, superuser permissions
|
| services.postgresqlWalReceiver.receivers.<name>.statusInterval | Specifies the number of seconds between status packets sent back to the server
|
| services.postgresqlWalReceiver.receivers.<name>.connection | Specifies parameters used to connect to the server, as a connection string
|
| services.postgresqlWalReceiver.receivers.<name>.environment | Environment variables passed to the service
|
| services.postgresql.settings.log_line_prefix | A printf-style string that is output at the beginning of each log line
|
| services.postgresql.ensureUsers.*.ensureClauses.createrole | Grants the user, created by the ensureUser attr, createrole permissions
|
| services.postgresql.ensureUsers.*.ensureClauses.replication | Grants the user, created by the ensureUser attr, replication permissions
|
| services.postgresqlWalReceiver.receivers.<name>.synchronous | Flush the WAL data to disk immediately after it has been received
|
| services.postgresql.settings.shared_preload_libraries | List of libraries to be preloaded.
|