Open knedlsepp opened 2 years ago
To imperatively get me out of this I did now run
echo "create extension if not exists pgcrypto" | runuser -u postgres -- psql hydra
It seems to me that maybe we need something similar to https://github.com/NixOS/hydra/commit/8a0a5ec3a3200d4f4d4d38f87d0afdb49f092b39
I have hit the same issue with NixOS 22.05 (not beta)
And I can confirm that the imperative method suggested worked for me as well, thanks :smile:
The alternative is to use a recent postgresql (as in the nixos test for hydra), which contains this function without requiring an extension:
{ pkgs, ... }: {
services.postgresql.package = pkgs.postgresql_14;
}
The alternative is to use a recent postgresql (as in the nixos test for hydra)
@lheckemann Will postgres automatically transform its state such that it's compatible with the new version on service restart?
Describe the bug I did upgrade my CI box from NixOS-21.11 to NixOS 22.05 beta with a hydra service based on the
package = pkgs.hydra-unstable;
and get the following error:Hydra Server:
pkgs.hydra-unstable