-
List of PostgreSQL plugins.
Type
(function that evaluates to a(n) list of path) or (list of path) convertible to it
Default
Example
ps: with ps; [ postgis pg_repack ]
Declarations
-
Whether to enable Automatically migrate old data dir when major version of PostgreSQL
changes, using fc-postgresql/pg_upgrade.
The old data dir will be kept and has to be removed manually later.
You can run sudo -u postgres fc-postgresql prepare-autoupgrade
to
create the new data dir before upgrading PostgreSQL to reduce downtime
and the risk of failure. You have to add databases to expectedDatabases
or disable checkExpectedDatabases
to make this work.
.
Type
boolean
Default
false
Example
true
Declarations
-
Whether to enable Enable preconfigured PostgreSQL.
Type
boolean
Default
false
Example
true
Declarations
-
Check that only the databases specified by expectedDatabases
(and the standard internal databases) are present.
This is enabled by default and prevents auto-upgrades affecting
unexpected databases.
Type
boolean
Default
true
Declarations
-
The major version of PostgreSQL to use (10, 11, 12, 13, 14).
-
List of databases that are expected to be present before upgrading.
If more databases are found, the upgrade will not run.
Type
list of string
Default
[ ]
Declarations
-
Whether to enable PostgreSQL dumps.
Type
boolean
Default
false
Example
true
Declarations
-
Whether to enable local postgresql integration.
Type
boolean
Default
false
Example
true
Declarations
-
Whether to enable PostgreSQL Server.
Type
boolean
Default
false
Example
true
Declarations
-
Specifies parameters used to connect to the server, as a connection string.
See Section 34.1.1 of the PostgreSQL manual for more information.
Because {command}pg_receivewal
doesn't connect to any particular database in the cluster,
database name in the connection string will be ignored.
Type
string
Example
"postgresql://user@somehost"
Declarations
-
The compression level used when compression is enabled.
gzip accepts levels 1 to 9. zstd accepts levels 1 to 19.
Type
integer between 1 and 19 (both inclusive)
Default
6
Declarations
-
List of libraries to be preloaded.
Type
null or (string or (list of string) convertible to it)
Default
null
Example
[ "auto_explain" "anon" ]
Declarations
-
PostgreSQL database name for the builds.sr.ht service,
used if is true
.
Type
string
Default
"builds.sr.ht"
Declarations
-
The data directory for PostgreSQL. If left as the default value
this directory will automatically be created before the PostgreSQL server starts, otherwise
the sysadmin is responsible for ensuring the directory exists with appropriate ownership
and permissions.
Type
path
Default
"/var/lib/postgresql/${config.services.patroni.postgresqlPackage.psqlSchema}"
Example
"/var/lib/postgresql/14"
Declarations
-
Grants the user, created by the ensureUser attr, replication permissions. From the postgres docs:
A role must explicitly be given permission to initiate
streaming replication (except for superusers, since those
bypass all permission checks). A role used for streaming
replication must have LOGIN permission as well. To create
such a role, use CREATE ROLE name REPLICATION LOGIN.
More information on postgres roles can be found here
Type
null or boolean
Default
null
: do not set. For newly created roles, use PostgreSQL's default. For existing roles, do not touch this clause.
Declarations