Re: Static PostgreSQL Binaries (Linux + Windows)

Than you. nice to hear from you . Would be able to share the build scripts
with community? are they open source?

Regards,
Pratik Parikh

On Sat, Jan 12, 2019 at 10:57 PM Zach van Rijn <me(at)zv(dot)io> wrote:

> 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
>
>
>

--
Pratik Parikh
- Mantra - Keep It Simple and Straightforward