PostgreSQL: Difference between revisions
Add link to nixos manual for postgres upgrades |
Reference the PostgreSQL upgrading procedure in the NixOS manual |
||
| Line 114: | Line 114: | ||
=== Set the Postgresql versions === | === Set the Postgresql versions === | ||
By default, NixOS uses whatever Postgres version shipped as default for your [https://search.nixos.org/options?show=system.stateVersion system.stateVersion]. To use a different or more recent version, you can set | By default, NixOS uses whatever Postgres version shipped as default for your [https://search.nixos.org/options?show=system.stateVersion system.stateVersion]. | ||
To use a different or more recent version, you can manually set one of the [https://search.nixos.org/packages?query=postgresql_ available Nixpkgs Postgresql versions]: | |||
<syntaxhighlight lang="nix"> | <syntaxhighlight lang="nix"> | ||
| Line 124: | Line 126: | ||
</syntaxhighlight> | </syntaxhighlight> | ||
Note that changing the package version does not trigger any automatic migrations of your existing databases | Note that changing the package version does not trigger any automatic migrations of your existing databases — follow https://nixos.org/manual/nixos/stable/#module-services-postgres-upgrading to migrate existing databases. | ||
=== Security === | === Security === | ||