As @thoughtpolice is short on time, I took this into my hands. I plan to change PG to pg11 by Feb 25 (before feature freeze).
So far, this was done:
- pg11 was added
- naming schema was changed (postgresql100 was deprecated)
- files reordered (postgresql: minor rearrangements by thoughtpolice · Pull Request #54344 · NixOS/nixpkgs · GitHub)
This is awaiting merge
-
postgresql.pkgs.*andpostgresql.withPackages(postgresql: reorganize package and its extensions by danbst · Pull Request #54319 · NixOS/nixpkgs · GitHub) - fix postgis, not that it is broken, but rather one of it’s dependecies did break regularly, so I pinned it (postgresql: cleanup postgis by danbst · Pull Request #54396 · NixOS/nixpkgs · GitHub)
After all this is merged, PG11 can be set as default. I don’t do any deprecations for NixOS, will only update docs and examples. The example above will look like
services.postgresql = {
enable = true;
dataDir = "/data/pgsql";
package = pkgs.postgresql_11;
# this will be supported as well
# package = pkgs.postgresql_11.withPackages (ps: [ ps.pg_repack ]);
extraPlugins = with pkgs.postgresql_11.pkgs;
[ cstore_fdw
pg_cron
pg_hll
pg_jobmon
pg_repack
pg_topn
pgtap
plv8
postgis
timescaledb
];
extraConfig = "shared_preload_libraries = 'timescaledb'";
};