-
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
-
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
-
The major version of PostgreSQL to use (14, 15, 16, 17, 18).
-
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
-
Whether to enable ‹name› in postgresql's syscall filter.
Type
boolean
Default
false
Example
true
Declarations
- /nix/store/p4wndq0zv9ag7s48ayx8gybpky31g958-nixpkgs-f2e671e0e21/nixos/modules/services/databases/postgresql.nix
-
Whether to enable PostgreSQL Server.
Type
boolean
Default
false
Example
true
Declarations
- /nix/store/p4wndq0zv9ag7s48ayx8gybpky31g958-nixpkgs-f2e671e0e21/nixos/modules/services/databases/postgresql.nix
-
Whether to enable PostgreSQL dumps.
Type
boolean
Default
false
Example
true
Declarations
- /nix/store/p4wndq0zv9ag7s48ayx8gybpky31g958-nixpkgs-f2e671e0e21/nixos/modules/services/backup/postgresql-backup.nix
-
PostgreSQL package to use.
Plugins can be enabled like this pkgs.postgresql_14.withPackages (p: [ p.pg_safeupdate p.postgis ]).
Type
package
Example
pkgs.postgresql_14
Declarations
- /nix/store/p4wndq0zv9ag7s48ayx8gybpky31g958-nixpkgs-f2e671e0e21/nixos/modules/services/cluster/patroni/default.nix
-
Command line options for pg_dump. This options is not used if
config.services.postgresqlBackup.backupAll is enabled. Note that
config.services.postgresqlBackup.backupAll is also active, when no
databases where specified.
Type
strings concatenated with " "
Default
"-C"
Declarations
- /nix/store/p4wndq0zv9ag7s48ayx8gybpky31g958-nixpkgs-f2e671e0e21/nixos/modules/services/backup/postgresql-backup.nix
-
Additional Munin plugins to activate. Keys are the name of the plugin
symlink, values are the path to the underlying plugin script. You
can use the same plugin script multiple times (e.g. for wildcard
plugins).
Note that these plugins do not participate in autoconfiguration. If
you want to autoconfigure additional plugins, use
{option}services.munin-node.extraAutoPlugins.
Plugins enabled in this manner take precedence over autoconfigured
plugins.
Plugins will be copied into the Nix store, and it will attempt to
modify them to run properly by fixing hardcoded references to
/bin, /usr/bin,
/sbin, and /usr/sbin.
Type
attribute set of absolute path
Default
{ }
Example
{
zfs_usage_bigpool = /src/munin-contrib/plugins/zfs/zfs_usage_;
zfs_usage_smallpool = /src/munin-contrib/plugins/zfs/zfs_usage_;
zfs_list = /src/munin-contrib/plugins/zfs/zfs_list;
};
Declarations
- /nix/store/p4wndq0zv9ag7s48ayx8gybpky31g958-nixpkgs-f2e671e0e21/nixos/modules/services/monitoring/munin.nix
-
A file containing SQL statements to execute on first startup.
Type
null or absolute path
Default
null
Example
pkgs.writeText "init-sql-script" ''
alter user postgres with password 'myPassword';
'';
Declarations
- /nix/store/p4wndq0zv9ag7s48ayx8gybpky31g958-nixpkgs-f2e671e0e21/nixos/modules/services/databases/postgresql.nix
-
Whether to enable Configure local PostgreSQL database server for meet.
Type
boolean
Default
false
Example
true
Declarations
- /nix/store/p4wndq0zv9ag7s48ayx8gybpky31g958-nixpkgs-f2e671e0e21/nixos/modules/services/web-apps/lasuite-meet.nix
-
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
absolute path
Default
"/var/lib/postgresql/${config.services.patroni.postgresqlPackage.psqlSchema}"
Example
"/var/lib/postgresql/14"
Declarations
- /nix/store/p4wndq0zv9ag7s48ayx8gybpky31g958-nixpkgs-f2e671e0e21/nixos/modules/services/cluster/patroni/default.nix
-
Command line options for pg_dumpall. This options is not used if
config.services.postgresqlBackup.backupAll is disabled.
Type
strings concatenated with " "
Default
""
Declarations
- /nix/store/p4wndq0zv9ag7s48ayx8gybpky31g958-nixpkgs-f2e671e0e21/nixos/modules/services/backup/postgresql-backup.nix