mirror of
https://github.com/NixOS/nixpkgs.git
synced 2025-07-13 13:40:28 +03:00
41c5662cbe
This avoids restarting the postgresql server, when only ensureDatabases or ensureUsers have been changed. It will also allow to properly wait for recovery to finish later. To wait for "postgresql is ready" in other services, we now provide a postgresql.target. Resolves #400018 Co-authored-by: Marcel <me@m4rc3l.de>
60 lines
1.6 KiB
Nix
60 lines
1.6 KiB
Nix
{ lib, pkgs, ... }:
|
|
{
|
|
name = "pgbouncer";
|
|
|
|
meta = with lib.maintainers; {
|
|
maintainers = [ _1000101 ];
|
|
};
|
|
|
|
nodes = {
|
|
one =
|
|
{ pkgs, ... }:
|
|
{
|
|
systemd.services.postgresql-setup = {
|
|
postStart = ''
|
|
${pkgs.postgresql}/bin/psql -U postgres -c "ALTER ROLE testuser WITH LOGIN PASSWORD 'testpass'";
|
|
${pkgs.postgresql}/bin/psql -U postgres -c "ALTER DATABASE testdb OWNER TO testuser;";
|
|
'';
|
|
};
|
|
|
|
services = {
|
|
postgresql = {
|
|
enable = true;
|
|
ensureDatabases = [ "testdb" ];
|
|
ensureUsers = [ { name = "testuser"; } ];
|
|
authentication = ''
|
|
local testdb testuser scram-sha-256
|
|
'';
|
|
};
|
|
|
|
pgbouncer = {
|
|
enable = true;
|
|
openFirewall = true;
|
|
settings = {
|
|
pgbouncer = {
|
|
listen_addr = "localhost";
|
|
auth_type = "scram-sha-256";
|
|
auth_file = builtins.toFile "pgbouncer-users.txt" ''
|
|
"testuser" "testpass"
|
|
'';
|
|
};
|
|
databases = {
|
|
test = "host=/run/postgresql port=5432 auth_user=testuser dbname=testdb";
|
|
};
|
|
};
|
|
};
|
|
};
|
|
};
|
|
};
|
|
|
|
testScript = ''
|
|
start_all()
|
|
one.wait_for_unit("default.target")
|
|
one.require_unit_state("pgbouncer.service", "active")
|
|
|
|
# Test if we can make a query through PgBouncer
|
|
one.wait_until_succeeds(
|
|
"psql 'postgres://testuser:testpass@localhost:6432/test' -c 'SELECT 1;'"
|
|
)
|
|
'';
|
|
}
|