Re: Static PostgreSQL Binaries (Linux + Windows)

Hi all,


I've been busy porting popular open-source software to various
platforms (Linux + Windows) via musl- and/or MinGW- based tools,
as part of a project (and future distro?) called 'xstatic' [1].

All packages are statically linked and have zero dependencies,
they can be easily reproduced and audited, they are best suited
for use in environments where software must behave consistently,
and may have additional performance / safety benefits.

I am pleased to announce the immediate availability of binaries
(and source code / build scripts) for the following releases:

 release  date        location
 -------  ----------  ------------------------------------------
 latest   n/a         https://xstatic.musl.cc/postgresql/
 11.1     2018-11-08  https://xstatic.musl.cc/postgresql-11.1/
 10.6     2018-11-08  https://xstatic.musl.cc/postgresql-10.6/
  9.6.11  2018-11-08  https://xstatic.musl.cc/postgresql-9.6.11/
  9.5.15  2018-11-08  https://xstatic.musl.cc/postgresql-9.5.15/
  9.4.20  2018-11-08  https://xstatic.musl.cc/postgresql-9.4.20/
  9.3.25  2018-11-08  https://xstatic.musl.cc/postgresql-9.3.25/


Within each top-level directory, you will find pertaining to an
architecture/ABI combination such as 'riscv32-linux-musl' (this
is the target platform where binaries should run), either:

(1) Directory tree (browse / download individual binaries); or
    e.g., https://xstatic.musl.cc/postgresql/riscv32-linux-musl/

(2) Tarball containing the above contents, with a sha512sum that
    is verifiable against '/<package>/SHA512SUMS'. Just extract
    and run (or build/link your own software against libraries).


PostgreSQL has been built for the following platforms, however,
not all platforms have been tested (please feel free to help):

  * aarch64-linux-musleabi
  * aarch64_be-linux-musl
  * arm-linux-musleabi
  * arm-linux-musleabihf
  * armeb-linux-musleabi
  * armeb-linux-musleabihf
  * armel-linux-musleabi
  * armel-linux-musleabihf
  * armv5l-linux-musleabihf
  * armv7l-linux-musleabihf
  * armv7m-linux-musleabi
  * armv7r-linux-musleabihf
  * i486-linux-musl
  * i686-linux-musl
  * i686-w64-mingw32
  * m68k-linux-musl
  * microblaze-linux-musl
  * microblazeel-linux-musl
  * mips-linux-musl
  * mips-linux-musln32sf
  * mips-linux-muslsf
  * mips64-linux-musl
  * mips64-linux-musln32
  * mips64-linux-musln32sf
  * mips64el-linux-musl
  * mips64el-linux-musln32
  * mips64el-linux-musln32sf
  * mipsel-linux-musl
  * mipsel-linux-musln32
  * mipsel-linux-musln32sf
  * mipsel-linux-muslsf
  * or1k-linux-musl
  * powerpc-linux-musl
  * powerpc-linux-muslsf
  * powerpc64-linux-musl
  * powerpc64le-linux-musl
  * powerpcle-linux-musl
  * powerpcle-linux-muslsf
  * riscv32-linux-musl
  * riscv64-linux-musl
  * s390x-linux-musl
  * sh2-linux-musl
  * sh2-linux-muslfdpic
  * sh2eb-linux-musl
  * sh2eb-linux-muslfdpic
  * sh4-linux-musl
  * sh4eb-linux-musl
  * x86_64-linux-musl
  * x86_64-linux-muslx32
  * x86_64-w64-mingw32


Quickly testing on Ubuntu 14.04 LTS (GNU/Linux 3.4.98 armv7l):

  $ file ./armv7l-linux-musleabihf/bin/psql 
  psql: ELF 32-bit LSB  executable, ARM, EABI5 version 1 (SYSV),
  statically linked, stripped

  $ ./armv7l-linux-musleabihf/bin/psql --version
  psql (PostgreSQL) 11.1

  $ ./armv7l-linux-musleabihf/bin/psql                         \
        -h pellefant.db.elephantsql.com                        \
        -U abcdefgh
  Password:
  psql (11.1, server 9.5.2)
  Type "help" for help.

  abcdefgh=>


The directory listing looks something like: http://ix.io/1yaV

That said, if you find bugs or encounter issues, please file a
bug report here [2]. Windows support may need tweaking.


Regards,

ZV


[1]: https://xstatic.musl.cc/

[2]: https://git.zv.io/xstatic/builder/issues