diff options
author | Edmund Wu <fangkazuto@gmail.com> | 2019-08-09 15:08:42 -0400 |
---|---|---|
committer | Edmund Wu <fangkazuto@gmail.com> | 2019-08-09 15:11:24 -0400 |
commit | 18d176dc20fff81e1f6ede31488804fc71b81f30 (patch) | |
tree | 38e1ccb7bbed63d9591272aa9f3cfb799f1d34a8 /nixos/modules/services | |
parent | ddf38a8241089d79c3bcd1777781b6438ab88d84 (diff) | |
download | nixlib-18d176dc20fff81e1f6ede31488804fc71b81f30.tar nixlib-18d176dc20fff81e1f6ede31488804fc71b81f30.tar.gz nixlib-18d176dc20fff81e1f6ede31488804fc71b81f30.tar.bz2 nixlib-18d176dc20fff81e1f6ede31488804fc71b81f30.tar.lz nixlib-18d176dc20fff81e1f6ede31488804fc71b81f30.tar.xz nixlib-18d176dc20fff81e1f6ede31488804fc71b81f30.tar.zst nixlib-18d176dc20fff81e1f6ede31488804fc71b81f30.zip |
nixos/postgresql: fix quoted queries
Diffstat (limited to 'nixos/modules/services')
-rw-r--r-- | nixos/modules/services/databases/postgresql.nix | 4 |
1 files changed, 2 insertions, 2 deletions
diff --git a/nixos/modules/services/databases/postgresql.nix b/nixos/modules/services/databases/postgresql.nix index 7ff899970ccd..10250bb5193a 100644 --- a/nixos/modules/services/databases/postgresql.nix +++ b/nixos/modules/services/databases/postgresql.nix @@ -330,13 +330,13 @@ in fi '' + optionalString (cfg.ensureDatabases != []) '' ${concatMapStrings (database: '' - $PSQL -tAc "SELECT 1 FROM pg_database WHERE datname = '${database}'" | grep -q 1 || $PSQL -tAc "CREATE DATABASE ${database}" + $PSQL -tAc "SELECT 1 FROM pg_database WHERE datname = '${database}'" | grep -q 1 || $PSQL -tAc 'CREATE DATABASE "${database}"' '') cfg.ensureDatabases} '' + '' ${concatMapStrings (user: '' $PSQL -tAc "SELECT 1 FROM pg_roles WHERE rolname='${user.name}'" | grep -q 1 || $PSQL -tAc "CREATE USER ${user.name}" ${concatStringsSep "\n" (mapAttrsToList (database: permission: '' - $PSQL -tAc "GRANT ${permission} ON ${database} TO ${user.name}" + $PSQL -tAc 'GRANT ${permission} ON ${database} TO ${user.name}' '') user.ensurePermissions)} '') cfg.ensureUsers} ''; |