646b892680
Some checks failed
Periodic Merges (6h) / master → staging-nixos (push) Failing after 12m50s
Periodic Merges (6h) / master → staging-next (push) Failing after 12m54s
Periodic Merges (24h) / merge-base(master,staging) → haskell-updates (push) Failing after 11m54s
Periodic Merges (6h) / staging-next → staging (push) Failing after 12m13s
Periodic Merges (24h) / staging-next-25.05 → staging-25.05 (push) Failing after 13m24s
Periodic Merges (24h) / release-25.05 → staging-next-25.05 (push) Failing after 14m28s
85 lines
2.4 KiB
Nix
85 lines
2.4 KiB
Nix
{
|
|
curl,
|
|
fetchFromGitHub,
|
|
fetchpatch,
|
|
lib,
|
|
lz4,
|
|
postgresql,
|
|
postgresqlBuildExtension,
|
|
postgresqlTestExtension,
|
|
}:
|
|
|
|
postgresqlBuildExtension (finalAttrs: {
|
|
pname = "citus";
|
|
version = "13.0.3";
|
|
|
|
src = fetchFromGitHub {
|
|
owner = "citusdata";
|
|
repo = "citus";
|
|
tag = "v${finalAttrs.version}";
|
|
hash = "sha256-tQ2YkMUeziz+dhfXtfuK0x8PWH3vfoJiVbE+YvQ/Gzc=";
|
|
};
|
|
|
|
patches = [
|
|
# Even though this commit is on main since Sep 2023, it hasn't made its way to the release-13.0 branch, yet.
|
|
# https://github.com/citusdata/citus/pull/7221
|
|
# Fixes build for PG 16 + 17 on darwin
|
|
(fetchpatch {
|
|
url = "https://github.com/citusdata/citus/commit/0f28a69f12418d211ffba5f7ddd222fd0c47daeb.patch";
|
|
hash = "sha256-8JAM+PUswzbdlAZUpRApgO0eBsMbUHFdFGsdATsG88I=";
|
|
})
|
|
];
|
|
|
|
buildInputs = [
|
|
curl
|
|
lz4
|
|
];
|
|
|
|
passthru.tests.extension = postgresqlTestExtension {
|
|
inherit (finalAttrs) finalPackage;
|
|
postgresqlExtraSettings = ''
|
|
shared_preload_libraries=citus
|
|
'';
|
|
sql = ''
|
|
CREATE EXTENSION citus;
|
|
|
|
CREATE TABLE examples (
|
|
id bigserial,
|
|
shard_key int,
|
|
PRIMARY KEY (id, shard_key)
|
|
);
|
|
|
|
SELECT create_distributed_table('examples', 'shard_key');
|
|
|
|
INSERT INTO examples (shard_key) SELECT shard % 10 FROM generate_series(1,1000) shard;
|
|
'';
|
|
asserts = [
|
|
{
|
|
query = "SELECT count(*) FROM examples";
|
|
expected = "1000";
|
|
description = "Distributed table can be queried successfully.";
|
|
}
|
|
];
|
|
};
|
|
|
|
meta = {
|
|
# "Our soft policy for Postgres version compatibility is to support Citus'
|
|
# latest release with Postgres' 3 latest releases."
|
|
# https://www.citusdata.com/updates/v12-0/#deprecated_features
|
|
broken =
|
|
lib.versionOlder postgresql.version "15"
|
|
||
|
|
# PostgreSQL 18 support issue upstream: https://github.com/citusdata/citus/issues/7978
|
|
# Check after next package update.
|
|
lib.warnIf (finalAttrs.version != "13.0.3") "Is postgresql18Packages.citus still broken?" (
|
|
lib.versionAtLeast postgresql.version "18"
|
|
);
|
|
description = "Distributed PostgreSQL as an extension";
|
|
homepage = "https://www.citusdata.com/";
|
|
changelog = "https://github.com/citusdata/citus/blob/${finalAttrs.src.rev}/CHANGELOG.md";
|
|
license = lib.licenses.agpl3Only;
|
|
maintainers = [ ];
|
|
inherit (postgresql.meta) platforms;
|
|
};
|
|
})
|