Static PostgreSQL Binaries (Linux + Windows)

From: Zach van Rijn <me(at)zv(dot)io>
To: pgsql-general(at)lists(dot)postgresql(dot)org
Subject: Static PostgreSQL Binaries (Linux + Windows)
Date: 2019-01-13 03:57:19
Message-ID: 1547351839.4002.17.camel@zv.io
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

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

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Brent Wood 2019-01-13 05:04:30 Re: Static PostgreSQL Binaries (Linux + Windows)
Previous Message Peter Geoghegan 2019-01-12 18:50:59 Re: CREATE COLLATION to match pg_collation data