diff options
Diffstat (limited to 'nixpkgs/pkgs/servers/sql/postgresql/default.nix')
-rw-r--r-- | nixpkgs/pkgs/servers/sql/postgresql/default.nix | 224 |
1 files changed, 224 insertions, 0 deletions
diff --git a/nixpkgs/pkgs/servers/sql/postgresql/default.nix b/nixpkgs/pkgs/servers/sql/postgresql/default.nix new file mode 100644 index 000000000000..2b440f78e99d --- /dev/null +++ b/nixpkgs/pkgs/servers/sql/postgresql/default.nix @@ -0,0 +1,224 @@ +let + + generic = + # dependencies + { stdenv, lib, fetchurl, makeWrapper + , glibc, zlib, readline, openssl, icu, systemd, libossp_uuid + , pkgconfig, libxml2, tzdata + + # This is important to obtain a version of `libpq` that does not depend on systemd. + , enableSystemd ? (lib.versionAtLeast version "9.6" && !stdenv.isDarwin) + + # for postgreql.pkgs + , this, self, newScope, buildEnv + + # source specification + , version, sha256, psqlSchema + }: + let + atLeast = lib.versionAtLeast version; + icuEnabled = atLeast "10"; + + in stdenv.mkDerivation rec { + pname = "postgresql"; + inherit version; + + src = fetchurl { + url = "mirror://postgresql/source/v${version}/${pname}-${version}.tar.bz2"; + inherit sha256; + }; + + outputs = [ "out" "lib" "doc" "man" ]; + setOutputFlags = false; # $out retains configureFlags :-/ + + buildInputs = + [ zlib readline openssl libxml2 makeWrapper ] + ++ lib.optionals icuEnabled [ icu ] + ++ lib.optionals enableSystemd [ systemd ] + ++ lib.optionals (!stdenv.isDarwin) [ libossp_uuid ]; + + nativeBuildInputs = lib.optionals icuEnabled [ pkgconfig ]; + + enableParallelBuilding = !stdenv.isDarwin; + + buildFlags = [ "world" ]; + + NIX_CFLAGS_COMPILE = "-I${libxml2.dev}/include/libxml2"; + + # Otherwise it retains a reference to compiler and fails; see #44767. TODO: better. + preConfigure = "CC=${stdenv.cc.targetPrefix}cc"; + + configureFlags = [ + "--with-openssl" + "--with-libxml" + "--sysconfdir=/etc" + "--libdir=$(lib)/lib" + "--with-system-tzdata=${tzdata}/share/zoneinfo" + (lib.optionalString enableSystemd "--with-systemd") + (if stdenv.isDarwin then "--with-uuid=e2fs" else "--with-ossp-uuid") + ] ++ lib.optionals icuEnabled [ "--with-icu" ]; + + patches = + [ (if atLeast "9.4" then ./patches/disable-resolve_symlinks-94.patch else ./patches/disable-resolve_symlinks.patch) + (if atLeast "9.6" then ./patches/less-is-more-96.patch else ./patches/less-is-more.patch) + (if atLeast "9.6" then ./patches/hardcode-pgxs-path-96.patch else ./patches/hardcode-pgxs-path.patch) + ./patches/specify_pkglibdir_at_runtime.patch + ./patches/findstring.patch + ] ++ lib.optional stdenv.isLinux ./patches/socketdir-in-run.patch; + + installTargets = [ "install-world" ]; + + LC_ALL = "C"; + + postConfigure = + let path = if atLeast "9.6" then "src/common/config_info.c" else "src/bin/pg_config/pg_config.c"; in + '' + # Hardcode the path to pgxs so pg_config returns the path in $out + substituteInPlace "${path}" --replace HARDCODED_PGXS_PATH $out/lib + ''; + + postInstall = + '' + moveToOutput "lib/pgxs" "$out" # looks strange, but not deleting it + moveToOutput "lib/libpgcommon*.a" "$out" + moveToOutput "lib/libpgport*.a" "$out" + moveToOutput "lib/libecpg*" "$out" + + # Prevent a retained dependency on gcc-wrapper. + substituteInPlace "$out/lib/pgxs/src/Makefile.global" --replace ${stdenv.cc}/bin/ld ld + + if [ -z "''${dontDisableStatic:-}" ]; then + # Remove static libraries in case dynamic are available. + for i in $out/lib/*.a $lib/lib/*.a; do + name="$(basename "$i")" + ext="${stdenv.hostPlatform.extensions.sharedLibrary}" + if [ -e "$lib/lib/''${name%.a}$ext" ] || [ -e "''${i%.a}$ext" ]; then + rm "$i" + fi + done + fi + ''; + + postFixup = lib.optionalString (!stdenv.isDarwin && stdenv.hostPlatform.libc == "glibc") + '' + # initdb needs access to "locale" command from glibc. + wrapProgram $out/bin/initdb --prefix PATH ":" ${glibc.bin}/bin + ''; + + doCheck = !stdenv.isDarwin; + # autodetection doesn't seem to able to find this, but it's there. + checkTarget = "check"; + + preCheck = + # On musl, comment skip the following tests, because they break due to + # ! ERROR: could not load library "/build/postgresql-11.5/tmp_install/nix/store/...-postgresql-11.5-lib/lib/libpqwalreceiver.so": Error loading shared library libpq.so.5: No such file or directory (needed by /build/postgresql-11.5/tmp_install/nix/store/...-postgresql-11.5-lib/lib/libpqwalreceiver.so) + # See also here: + # https://git.alpinelinux.org/aports/tree/main/postgresql/disable-broken-tests.patch?id=6d7d32c12e073a57a9e5946e55f4c1fbb68bd442 + if stdenv.hostPlatform.isMusl then '' + substituteInPlace src/test/regress/parallel_schedule \ + --replace "subscription" "" \ + --replace "object_address" "" + '' else null; + + doInstallCheck = false; # needs a running daemon? + + disallowedReferences = [ stdenv.cc ]; + + passthru = { + inherit readline psqlSchema; + + pkgs = let + scope = { postgresql = this; }; + newSelf = self // scope; + newSuper = { callPackage = newScope (scope // this.pkgs); }; + in import ./packages.nix newSelf newSuper; + + withPackages = postgresqlWithPackages { + inherit makeWrapper buildEnv; + postgresql = this; + } + this.pkgs; + }; + + meta = with lib; { + homepage = "https://www.postgresql.org"; + description = "A powerful, open source object-relational database system"; + license = licenses.postgresql; + maintainers = with maintainers; [ ocharles thoughtpolice danbst globin ]; + platforms = platforms.unix; + knownVulnerabilities = optional (!atLeast "9.4") + "PostgreSQL versions older than 9.4 are not maintained anymore!"; + }; + }; + + postgresqlWithPackages = { postgresql, makeWrapper, buildEnv }: pkgs: f: buildEnv { + name = "postgresql-and-plugins-${postgresql.version}"; + paths = f pkgs ++ [ + postgresql + postgresql.lib + postgresql.man # in case user installs this into environment + ]; + buildInputs = [ makeWrapper ]; + + # We include /bin to ensure the $out/bin directory is created, which is + # needed because we'll be removing the files from that directory in postBuild + # below. See #22653 + pathsToLink = ["/" "/bin"]; + + # Note: the duplication of executables is about 4MB size. + # So a nicer solution was patching postgresql to allow setting the + # libdir explicitely. + postBuild = '' + mkdir -p $out/bin + rm $out/bin/{pg_config,postgres,pg_ctl} + cp --target-directory=$out/bin ${postgresql}/bin/{postgres,pg_config,pg_ctl} + wrapProgram $out/bin/postgres --set NIX_PGLIBDIR $out/lib + ''; + + passthru.version = postgresql.version; + passthru.psqlSchema = postgresql.psqlSchema; + }; + +in self: { + + postgresql_9_5 = self.callPackage generic { + version = "9.5.22"; + psqlSchema = "9.5"; + sha256 = "03v4d4nr9f86y0i1j5jmvfan5w8y4ga1mar59lhcnj3jl5q58ma8"; + this = self.postgresql_9_5; + inherit self; + }; + + postgresql_9_6 = self.callPackage generic { + version = "9.6.18"; + psqlSchema = "9.6"; + sha256 = "16crr2a1sl97aiacqzd0bk56yl1abq6blc0c6qpx5rl5ny1c4zji"; + this = self.postgresql_9_6; + inherit self; + }; + + postgresql_10 = self.callPackage generic { + version = "10.13"; + psqlSchema = "10.0"; # should be 10, but changing it is invasive + sha256 = "1qal0yp7a90yzya7hl56gsmw5fvacplrdhpn7h9gnbyr1i2iyw2d"; + this = self.postgresql_10; + inherit self; + }; + + postgresql_11 = self.callPackage generic { + version = "11.8"; + psqlSchema = "11.1"; # should be 11, but changing it is invasive + sha256 = "1qksqyayxmnccmbapg3ajsw9pjgqva0inxjhx64rqd6ckhrg9wpa"; + this = self.postgresql_11; + inherit self; + }; + + postgresql_12 = self.callPackage generic { + version = "12.3"; + psqlSchema = "12"; + sha256 = "0hfg3n7rlz96579cj3z1dh2idl15rh3wfvn8jl31jj4h2yk69vcl"; + this = self.postgresql_12; + inherit self; + }; + +} |