about summary refs log tree commit diff
path: root/nixos/tests
diff options
context:
space:
mode:
authorSavyasachee Jha <genghizkhan91@hawkradius.com>2024-06-15 19:01:08 +0530
committerSavyasachee Jha <genghizkhan91@hawkradius.com>2024-06-15 19:01:08 +0530
commitb9e13e352899150889d45fdb7a50ad89969d50ee (patch)
tree21548f26cf1520eb64e359ffa23587d1f57d5644 /nixos/tests
parent3863fd9a6a72d202d0956cd0edb74d6aab1e37e1 (diff)
nixos/tests/firefly-iii: Use postgres 16
Diffstat (limited to 'nixos/tests')
-rw-r--r--nixos/tests/firefly-iii.nix4
1 files changed, 3 insertions, 1 deletions
diff --git a/nixos/tests/firefly-iii.nix b/nixos/tests/firefly-iii.nix
index 2373ba8360264..f8e4ca4bfe2b4 100644
--- a/nixos/tests/firefly-iii.nix
+++ b/nixos/tests/firefly-iii.nix
@@ -39,12 +39,13 @@ in
         DB_DATABASE = "firefly";
         DB_USERNAME = "firefly";
         DB_PASSWORD_FILE = "/etc/postgres-pass";
+        PGSQL_SCHEMA = "firefly";
       };
     };
 
     services.postgresql = {
       enable = true;
-      package = pkgs.postgresql_15;
+      package = pkgs.postgresql_16;
       authentication = ''
         local all postgres peer
         local firefly firefly password
@@ -52,6 +53,7 @@ in
       initialScript = pkgs.writeText "firefly-init.sql" ''
         CREATE USER "firefly" WITH LOGIN PASSWORD '${db-pass}';
         CREATE DATABASE "firefly" WITH OWNER "firefly";
+        \c firefly
         CREATE SCHEMA AUTHORIZATION firefly;
       '';
     };