Re: Static PostgreSQL Binaries (Linux + Windows)

Does this support extensions such as Postgis & Timescale?

Brent Wood

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

[cid:image419b22(dot)PNG(at)6e8846bb(dot)46b21a94]<http://www.niwa.co.nz>

Brent Wood
Principal Technician - GIS and Spatial Data Management
Programme Leader - Environmental Information Delivery
T +64-4-386-0529

National Institute of Water & Atmospheric Research Ltd (NIWA)
301 Evans Bay Parade, Greta Point, Wellington
Connect with NIWA: niwa.co.nz<https://www.niwa.co.nz> Facebook<https://www.facebook.com/nzniwa> Twitter<https://twitter.com/niwa_nz> LinkedIn<https://www.linkedin.com/company/niwa> Instagram<https://www.instagram.com/niwa_science>

To ensure compliance with legal requirements and to maintain cyber security standards, NIWA's IT systems are subject to ongoing monitoring, activity logging and auditing. This monitoring and auditing service may be provided by third parties. Such third parties can access information transmitted to, processed by and stored on NIWA's IT systems.

________________________________________
From: Zach van Rijn <me(at)zv(dot)io>
Sent: Sunday, January 13, 2019 16:57
To: pgsql-general(at)lists(dot)postgresql(dot)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