i have nix-2.0.4 + postgresql-10.4 install on readhat 7 server.
but the directory /nix/store/zzrphwnp8kzv4s5r4z1nqzn8hbnlsm7b-postgresql-10.4/share/extension/ is read-only filesystem, i can’t copy the plugin into it.
i look into the service module solution, it use override to solve it. but i have no root rights, so what’s the right way to do it under this situation.
it seems i can build a postgresqlAnPlugins package, then copy postgres package and extension into it?
how can i implement in stdenv.mkDerivation? can someone offer me an example?
I was investigating the same thing and discovered that there’s a passthru on postgresql called withPackages that lets you do this easily. For example to build a version with cstore_fdw (obviously not what you’d do in production but it demonstrates it):