31 lines
1 KiB
Nix
31 lines
1 KiB
Nix
|
{ config, pkgs, ... }: {
|
||
|
|
services.postgresql = {
|
||
|
|
extraPlugins = ps: with ps; [
|
||
|
|
pgroonga
|
||
|
|
(pkgs.stdenv.mkDerivation {
|
||
|
|
name = "zulip-dicts";
|
||
|
|
phases = "installPhase";
|
||
|
|
src = pkgs.fetchurl {
|
||
|
|
url = "https://raw.githubusercontent.com/zulip/zulip/dd678465aed915101f9a74054e28535bbdd88ba3/puppet/zulip/files/postgresql/zulip_english.stop";
|
||
|
|
hash = "sha256-F3CmCRkkPURN9Uo7KIFxkajSJsiTYQg1wubKCF2+bAs=";
|
||
|
|
};
|
||
|
|
installPhase = ''
|
||
|
|
mkdir -p $out/share/postgresql/tsearch_data/
|
||
|
|
ln -s ${pkgs.hunspellDicts.en_US}/share/hunspell/en_US.dic $out/share/postgresql/tsearch_data/en_us.dict
|
||
|
|
ln -s ${pkgs.hunspellDicts.en_US}/share/hunspell/en_US.aff $out/share/postgresql/tsearch_data/en_us.affix
|
||
|
|
cp $src $out/share/postgresql/tsearch_data/zulip_english.stop
|
||
|
|
'';
|
||
|
|
})
|
||
|
|
];
|
||
|
|
|
||
|
|
ensureDatabases = [ "zulip" ];
|
||
|
|
ensureUsers = [
|
||
|
|
{
|
||
|
|
name = "zulip";
|
||
|
|
ensureDBOwnership = true;
|
||
|
|
ensureClauses.login = true;
|
||
|
|
}
|
||
|
|
];
|
||
|
|
};
|
||
|
|
}
|