-
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 ]
-
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
-
Whether to enable Enable preconfigured PostgreSQL.
Type
boolean
Default
false
Example
true
-
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
[ ]
Example
-
The major version of PostgreSQL to use (10, 11, 12, 13, 14).
Type
string
Default
Example
-
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
Example
-
Whether to enable PostgreSQL Server.
Type
boolean
Default
false
Example
true
-
Whether to enable PostgreSQL dumps.
Type
boolean
Default
false
Example
true
-
Whether to enable local postgresql integration.
Type
boolean
Default
false
Example
true
-
A list of extra arguments to pass to the {command}pg_receivewal command.
Type
list of string
Default
[ ]
Example
[
"--no-sync"
]
-
Ensures that the specified users exist.
The PostgreSQL users will be identified using peer authentication. This authenticates the Unix user with the
same name only, and that without the need for a password.
This option will never delete existing users or remove DB ownership of databases
once granted with ensureDBOwnership = true;. This means that this must be
cleaned up manually when changing after changing the config in here.
Type
list of (submodule)
Default
[ ]
Example
[
{
name = "nextcloud";
}
{
name = "superuser";
ensureDBOwnership = true;
}
]
-
Defines the mapping from system users to database users.
See the auth doc.
Type
strings concatenated with "\n"
Default
""
Example
''
map-name-0 system-username-0 database-username-0
map-name-1 system-username-1 database-username-1
''
-
The postgresql package to use.
Type
package
Default
pkgs.postgresql
Example
postgresql_15
-
PostgreSQL database name for the git.sr.ht service,
used if is true.
Type
string
Default
"git.sr.ht"
Example
-
The postgresql package to use.
Type
package
Default
pkgs.postgresql
Example
postgresql_15