diff options
Diffstat (limited to 'nixpkgs/pkgs/servers/sql')
7 files changed, 32 insertions, 61 deletions
diff --git a/nixpkgs/pkgs/servers/sql/postgresql/default.nix b/nixpkgs/pkgs/servers/sql/postgresql/default.nix index 6bf881d52815..427a394873fa 100644 --- a/nixpkgs/pkgs/servers/sql/postgresql/default.nix +++ b/nixpkgs/pkgs/servers/sql/postgresql/default.nix @@ -344,17 +344,6 @@ let }; mkPackages = self: { - # TODO: remove ahead of 23.11 branchoff - # "PostgreSQL 11 will stop receiving fixes on November 9, 2023" - postgresql_11 = self.callPackage generic { - version = "11.21"; - psqlSchema = "11.1"; # should be 11, but changing it is invasive - hash = "sha256-B7CDdHHV3XeyUWazRxjzuhCBa2rWHmkeb8VHzz/P+FA="; - this = self.postgresql_11; - thisAttr = "postgresql_11"; - inherit self; - }; - postgresql_12 = self.callPackage generic { version = "12.16"; psqlSchema = "12"; diff --git a/nixpkgs/pkgs/servers/sql/postgresql/ext/age.nix b/nixpkgs/pkgs/servers/sql/postgresql/ext/age.nix index c0de0c30d5a7..3a1c1c8388be 100644 --- a/nixpkgs/pkgs/servers/sql/postgresql/ext/age.nix +++ b/nixpkgs/pkgs/servers/sql/postgresql/ext/age.nix @@ -6,7 +6,6 @@ let "14" = "sha256-w93Q499sZRk4q85A9yqKQjGUd9Pl8UL8K1D3W7mHRTU="; "13" = "sha256-Sot7FR0oW7kWA680pNCMCmlflu4RfJTSWZn9mrXrpzw="; "12" = "sha256-XezcXoHHLCD1/2OHmKhxome2pdjOsYAfZlpvOoU3aS4="; - "11" = "sha256-ZkNAIMO69BxF3knQ+jcUBVuDgcoZXZccF5O+acpZ81M="; }; in stdenv.mkDerivation rec { diff --git a/nixpkgs/pkgs/servers/sql/postgresql/ext/pg_embedding.nix b/nixpkgs/pkgs/servers/sql/postgresql/ext/pg_embedding.nix new file mode 100644 index 000000000000..a39dcd537275 --- /dev/null +++ b/nixpkgs/pkgs/servers/sql/postgresql/ext/pg_embedding.nix @@ -0,0 +1,30 @@ +{ lib, stdenv, fetchFromGitHub, postgresql }: + +stdenv.mkDerivation rec { + pname = "pg_embedding"; + version = "0.3.6"; + + src = fetchFromGitHub { + owner = "neondatabase"; + repo = pname; + rev = version; + hash = "sha256-NTBxsQB8mR7e/CWwkCEyDiYhi3Nxl/aKgRBwqc0THcI="; + }; + + buildInputs = [ postgresql ]; + + installPhase = '' + install -D -t $out/lib *.so + install -D -t $out/share/postgresql/extension *.sql + install -D -t $out/share/postgresql/extension *.control + ''; + + meta = with lib; { + description = "PostgreSQL extension implementing the HNSW algorithm for vector similarity search"; + homepage = "https://github.com/neondatabase/pg_embedding"; + maintainers = with maintainers; [ ivan ]; + platforms = postgresql.meta.platforms; + license = licenses.asl20; + broken = versionOlder postgresql.version "12"; + }; +} diff --git a/nixpkgs/pkgs/servers/sql/postgresql/ext/pg_hint_plan.nix b/nixpkgs/pkgs/servers/sql/postgresql/ext/pg_hint_plan.nix index d0cf1193fb56..afc5b9fe6506 100644 --- a/nixpkgs/pkgs/servers/sql/postgresql/ext/pg_hint_plan.nix +++ b/nixpkgs/pkgs/servers/sql/postgresql/ext/pg_hint_plan.nix @@ -22,10 +22,6 @@ let version = "1.3.9"; hash = "sha256-64/dlm6e4flCxMQ8efsxfKSlja+Tko0zsghTgLatN+Y="; }; - "11" = { - version = "1.3.9"; - hash = "sha256-8t/HhB/2Kjx4xMItmmKv3g9gba5VCBHdplYtYD/3UhA="; - }; }.${lib.versions.major postgresql.version} or (throw "Source for pg_hint_plan is not available for ${postgresql.version}"); in stdenv.mkDerivation { diff --git a/nixpkgs/pkgs/servers/sql/postgresql/ext/pgaudit.nix b/nixpkgs/pkgs/servers/sql/postgresql/ext/pgaudit.nix index 188451f1b884..f4c03d611f50 100644 --- a/nixpkgs/pkgs/servers/sql/postgresql/ext/pgaudit.nix +++ b/nixpkgs/pkgs/servers/sql/postgresql/ext/pgaudit.nix @@ -22,10 +22,6 @@ let version = "1.4.3"; hash = "sha256-c8/xUFIHalu2bMCs57DeylK0oW0VnQwmUCpdp+tYqk4="; }; - "11" = { - version = "1.3.4"; - hash = "sha256-UEnwD36ejeYWyKRHZ4mPt6/Ru76Gy8s/rgIvmgermiM="; - }; }.${lib.versions.major postgresql.version} or (throw "Source for pgaudit is not available for ${postgresql.version}"); in stdenv.mkDerivation { diff --git a/nixpkgs/pkgs/servers/sql/postgresql/ext/pipelinedb.nix b/nixpkgs/pkgs/servers/sql/postgresql/ext/pipelinedb.nix deleted file mode 100644 index 6403138fd704..000000000000 --- a/nixpkgs/pkgs/servers/sql/postgresql/ext/pipelinedb.nix +++ /dev/null @@ -1,39 +0,0 @@ -{ lib, stdenv, fetchFromGitHub, postgresql, zeromq, openssl, libsodium, libkrb5 }: - -stdenv.mkDerivation rec { - pname = "pipelinedb"; - version = "1.0.0-13"; - - src = fetchFromGitHub { - owner = "pipelinedb"; - repo = pname; - rev = version; - sha256 = "1mnqpvx6g1r2n4kjrrx01vbdx7kvndfsbmm7zbzizjnjlyixz75f"; - }; - - buildInputs = [ postgresql openssl zeromq libsodium libkrb5 ]; - - makeFlags = [ "USE_PGXS=1" ]; - - NIX_LDFLAGS = lib.optionalString stdenv.isDarwin "-lsodium"; - - preConfigure = '' - substituteInPlace Makefile \ - --replace "/usr/lib/libzmq.a" "${zeromq}/lib/libzmq.a" - ''; - - installPhase = '' - mkdir -p $out/bin - install -D -t $out/lib/ pipelinedb.so - install -D -t $out/share/postgresql/extension {pipelinedb-*.sql,pipelinedb.control} - ''; - - meta = with lib; { - description = "High-performance time-series aggregation for PostgreSQL"; - homepage = "https://www.pipelinedb.com/"; - license = licenses.asl20; - platforms = postgresql.meta.platforms; - maintainers = [ maintainers.marsam ]; - broken = versions.major postgresql.version != "11"; - }; -} diff --git a/nixpkgs/pkgs/servers/sql/postgresql/packages.nix b/nixpkgs/pkgs/servers/sql/postgresql/packages.nix index d9d9ce8b09d9..6685602ec3a1 100644 --- a/nixpkgs/pkgs/servers/sql/postgresql/packages.nix +++ b/nixpkgs/pkgs/servers/sql/postgresql/packages.nix @@ -18,6 +18,8 @@ self: super: { pg_ed25519 = super.callPackage ./ext/pg_ed25519.nix { }; + pg_embedding = super.callPackage ./ext/pg_embedding.nix { }; + pg_hint_plan = super.callPackage ./ext/pg_hint_plan.nix { }; pg_ivm = super.callPackage ./ext/pg_ivm.nix { }; @@ -56,8 +58,6 @@ self: super: { pgtap = super.callPackage ./ext/pgtap.nix { }; - pipelinedb = super.callPackage ./ext/pipelinedb.nix { }; - smlar = super.callPackage ./ext/smlar.nix { }; temporal_tables = super.callPackage ./ext/temporal_tables.nix { }; |