pg_journal: init at 0.2.0 & fixed some PostgreSQL plugins related issues #44379
Conversation
PostgreSQL plugins need to link with the configured version of the
postgresql package otherwise the server will crash with an error like:
FATAL: incompatible library
"/nix/store/...-postgresql-and-plugins-10.4/lib/pg_journal.so":
version mismatch
DETAIL: Server is version 10, library is version 9.6.
To fix this we'll override every plugin by setting postgresql to the
configured package. Note that this does require every plugin to have
postgresql in its arguments but every plugin already needs this.
…gins derivation
This is needed because some PostgreSQL plugins don't have a bin
directory. If only these plugins are listed in cfg.extraPlugins
buildEnv will turn $out/bin into a symbolic link to ${pg}/bin. Lateron
we try to rm $out/bin/{pg_config,postgres,pg_ctl} which will then fail
because $out/bin will be read-only.
For logging PostgreSQL messages to the systemd journal
|
@GrahamcOfBorg test postgresql |
|
@thoughtpolice this will probably conflict with your #38698. |
|
@thoughtpolice it's probably best to rebase my work on your #38698 right?
|
|
@basvandijk Yes, I think rebasing it would be appropriate, thank you! I can actually integrate your changes into my branch directly... In the mean time maybe I should just add my own name to the maintainers field so I'm CC'd in the future... and get done pushing that work in. :) |
|
@basvandijk These changes are now incorporated in my branch in #38698, but I didn't include the PostgreSQL tests you added for |
|
@thoughtpolice thank you! Closing in favour of #38698. |
Motivation for this change
Triggered by Discourse: Q: Services logging to stderr preferred over logging to syslog? I packaged the
pg_journalplugin that logs PostgreSQL messages to the systemd journal.Things done
packaged
pg_journalat version 0.2.0 (including some patches)fixed some PostgreSQL plugins related issues.
sandboxinnix.confon non-NixOS)nix-shell -p nox --run "nox-review wip"./result/bin/)nix path-info -Sbefore and after)CC @ocharles as maintainer of the
postgresqlpackage. Ollie, what do you think?