Re: Static PostgreSQL Binaries (Linux + Windows) - Mailing list pgsql-general

Does this support extensions such as Postgis & Timescale?

Brent Wood

Programme leader: Environmental Information Delivery
NIWA
DDI:  +64 (4) 3860529

________________________________________
From: Zach van Rijn <me@zv.io>
Sent: Sunday, January 13, 2019 16:57
To: pgsql-general@lists.postgresql.org
Subject: 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