onjin / docker-alpine-postgres Goto Github PK
View Code? Open in Web Editor NEWMinimal PostgreSQL images based on Alpine Linux
Home Page: https://hub.docker.com/r/onjin/alpine-postgres/
Minimal PostgreSQL images based on Alpine Linux
Home Page: https://hub.docker.com/r/onjin/alpine-postgres/
Related to #6 -- when the 9.4
tag was updated and started failing, our first thought was to update our compose file to use 9.4.9
. But despite what the README on Docker Hub says, which shows tags for patch level (9.4.N
) and minor level (9.4
) versions, Docker Hub tags page shows only minor level versions, and we were unable to docker pull
any previous patch level versions.
With minor level version tags which are updated semi-frequently, we are at the mercy of our builds or deployments breaking not only from changes to PostgreSQL itself (which we might assume are backwards compatible) but also any other changes to the build, as seen in #6.
Please could you change your build process to ensure that patch level builds are always tags, and that those tags are permanent -- if we tag 9.4.9
, we expect to always get the same build.
I was about to say that it looks like this is what the official postgres image does, and when I checked their tags page on Docker Hub I noticed that they also have alpine builds, now.
Does that make your repository redundant now? Are you going to still maintain your repository when the official repository also has alpine builds?
Thank you for offering your container!
I tried to set locale to cs_CZ.UTF-8
- in docker-compose.yml
- by setting LANG=cs_CZ.UTF-8
, but it seems it doesn't have any effect - records are still sorted as with EN locale. Also, I don't see using LANG
variable in the whole repo.
The current 9.4 image is faulty. When run PostgreSQL fails to start due to libssl errors, and contrary to the claim on the Hub listing page that it includes postgres version 9.4.9 the 9.4 Dockerfile itself installs 9.4.11.
ยป docker run --rm -it onjin/alpine-postgres:9.4
Error loading shared library libssl.so.1.0.0: No such file or directory (needed by /usr/local/bin/postgres)
Error loading shared library libcrypto.so.1.0.0: No such file or directory (needed by /usr/local/bin/postgres)
Error relocating /usr/local/bin/postgres: BIO_new_mem_buf: symbol not found
Error relocating /usr/local/bin/postgres: BIO_s_socket: symbol not found
Error relocating /usr/local/bin/postgres: SSL_renegotiate: symbol not found
Error relocating /usr/local/bin/postgres: SSL_set_bio: symbol not found
Error relocating /usr/local/bin/postgres: X509_STORE_load_locations: symbol not found
Error relocating /usr/local/bin/postgres: BIO_free: symbol not found
Error relocating /usr/local/bin/postgres: SSL_CTX_set_client_CA_list: symbol not found
Error relocating /usr/local/bin/postgres: DH_check: symbol not found
Error relocating /usr/local/bin/postgres: SSL_get_current_compression: symbol not found
Error relocating /usr/local/bin/postgres: DH_size: symbol not found
Error relocating /usr/local/bin/postgres: SSL_CTX_set_verify: symbol not found
Error relocating /usr/local/bin/postgres: SSL_ctrl: symbol not found
Error relocating /usr/local/bin/postgres: SSL_load_error_strings: symbol not found
Error relocating /usr/local/bin/postgres: EC_KEY_new_by_curve_name: symbol not found
Error relocating /usr/local/bin/postgres: OBJ_sn2nid: symbol not found
Error relocating /usr/local/bin/postgres: EC_KEY_free: symbol not found
etc
docker build --no-cache --tag posgres/9.6.2-alpine https://github.com/onjin/docker-alpine-postgres.git#master:9.6
result:
(46/46) Installing wget (1.18-r2)
Executing busybox-1.25.1-r0.trigger
Executing ca-certificates-20161130-r1.trigger
OK: 206 MiB in 55 packages
gpg: directory '/root/.gnupg' created
gpg: new configuration file '/root/.gnupg/dirmngr.conf' created
gpg: new configuration file '/root/.gnupg/gpg.conf' created
gpg: keybox '/root/.gnupg/pubring.kbx' created
gpg: keyserver receive failed: Address not available
The command '/bin/sh -c apk update && apk add build-base readline-dev openssl-dev zlib-dev libxml2-dev glib-lang wget gnupg ca-certificates libssl1.0 && gpg --keyserver pool.sks-keyservers.net --recv-keys B42F6819007F00F88E364FD4036A9C25BF357DD4 && gpg --list-keys --fingerprint --with-colons | sed -E -n -e 's/^fpr:::::::::([0-9A-F]+):$/\1:6:/p' | gpg --import-ownertrust && wget -O /usr/local/bin/gosu "https://github.com/tianon/gosu/releases/download/1.7/gosu-amd64" && wget -O /usr/local/bin/gosu.asc "https://github.com/tianon/gosu/releases/download/1.7/gosu-amd64.asc" && gpg --verify /usr/local/bin/gosu.asc && rm /usr/local/bin/gosu.asc && chmod +x /usr/local/bin/gosu && mkdir -p /docker-entrypoint-initdb.d && wget ftp://ftp.postgresql.org/pub/source/v$PG_VERSION/postgresql-$PG_VERSION.tar.bz2 -O /tmp/postgresql-$PG_VERSION.tar.bz2 && tar xvfj /tmp/postgresql-$PG_VERSION.tar.bz2 -C /tmp && cd /tmp/postgresql-$PG_VERSION && ./configure --enable-integer-datetimes --enable-thread-safety --prefix=/usr/local --with-libedit-preferred --with-openssl && make world && make install world && make -C contrib install && cd /tmp/postgresql-$PG_VERSION/contrib && make && make install && apk --purge del build-base openssl-dev zlib-dev libxml2-dev wget gnupg ca-certificates && rm -r /tmp/postgresql-$PG_VERSION* /var/cache/apk/*' returned a non-zero code: 2
Love the image! Small issue when trying to use it - seems there's a permissions issue in the latest one?
postgres_1 | FATAL: data directory "/var/lib/postgresql/data" has group or world access
postgres_1 | DETAIL: Permissions should be u=rwx (0700).
I believe you're missing this in your entrypoint somewhere. I don't have the time to debug it myself but figured I'd leave a note - would be cool to see it patched up!
chmod 700 "$PGDATA"
A declarative, efficient, and flexible JavaScript library for building user interfaces.
๐ Vue.js is a progressive, incrementally-adoptable JavaScript framework for building UI on the web.
TypeScript is a superset of JavaScript that compiles to clean JavaScript output.
An Open Source Machine Learning Framework for Everyone
The Web framework for perfectionists with deadlines.
A PHP framework for web artisans
Bring data to life with SVG, Canvas and HTML. ๐๐๐
JavaScript (JS) is a lightweight interpreted programming language with first-class functions.
Some thing interesting about web. New door for the world.
A server is a program made to process requests and deliver data to clients.
Machine learning is a way of modeling and interpreting data that allows a piece of software to respond intelligently.
Some thing interesting about visualization, use data art
Some thing interesting about game, make everyone happy.
We are working to build community through open source technology. NB: members must have two-factor auth.
Open source projects and samples from Microsoft.
Google โค๏ธ Open Source for everyone.
Alibaba Open Source for everyone
Data-Driven Documents codes.
China tencent open source team.