suzel / docker-postgrest

REST API for any Postgres database (PostgREST Docker Image)

Sukru Uzel

I'm Sukru. Software developer working with Java, Python, JavaScript, Svelte, and GraphQL.

Get in touch

• Personal Website: sukruuzel.com
• LinkedIn: https://www.linkedin.com/in/sukru-uzel

docker-postgrest's Issues

Using the official container

Hey @suzel thanks for providing this repo to help people out during all that time we didn't have an official postgrest container. Today I released https://hub.docker.com/r/begriffs/postgrest and I'm wondering if you could add a note on your repo to point people to that one? It'll make my maintenance job easier if people are running a standard config.

Also would love your opinion about ways to improve the official Dockerfile.

build error

docker host: ubuntu 18.04 server
docker-compose version: 1.22.0

build process

2018-11-06 10:07:19 [mini@s013 docker-postgrest]$ docker-compose up -d --build
Creating network "docker-postgrest_default" with the default driver
Creating volume "docker-postgrest_postgres-data" with default driver
Pulling postgres (postgres:alpine)...
alpine: Pulling from library/postgres
4fe2ade4980c: Pull complete
08cf8c12f47e: Pull complete
451b995b6a91: Pull complete
4e120c38e0aa: Pull complete
114a638392f1: Pull complete
2d140d950000: Pull complete
7fe210330066: Pull complete
828c56635167: Pull complete
799c2a403e8f: Pull complete
Digest: sha256:c490fe09d5cb1d1cffc8c70bbc5ff0f4837b3f97e4f357d3bea88b9be642fd20
Status: Downloaded newer image for postgres:alpine
Pulling pgweb (sosedoff/pgweb:)...
latest: Pulling from sosedoff/pgweb
605ce1bd3f31: Pull complete
b34496e58e75: Pull complete
Digest: sha256:b88ee27cfd0b155e07ec346eeb9d506a8cc877b1abc5922a9c94487b101c955d
Status: Downloaded newer image for sosedoff/pgweb:latest
Building postgrest
Step 1/9 : FROM ubuntu:latest
latest: Pulling from library/ubuntu
473ede7ed136: Pull complete
c46b5fa4d940: Pull complete
93ae3df89c92: Pull complete
6b1eed27cade: Pull complete
Digest: sha256:29934af957c53004d7fb6340139880d23fb1952505a15d69a03af0d1418878cb
Status: Downloaded newer image for ubuntu:latest
 ---> ea4c82dcd15a
Step 2/9 : LABEL version="1.0" maintainer="Sukru Uzel <[email protected]>"
 ---> Running in c823312e2470
Removing intermediate container c823312e2470
 ---> b36500289e64
Step 3/9 : ARG POSTGREST_VERSION=0.5.1.0
 ---> Running in 006efd8606e5
Removing intermediate container 006efd8606e5
 ---> 24db8a0858d5
Step 4/9 : RUN apt-get -qq update &&   apt-get -qq install -y --no-install-recommends libpq5 &&   apt-get -qq clean &&   rm -rf /var/lib/apt/lists/* /tmp/* /var/tmp/*
 ---> Running in f190e9ddc4b7
debconf: delaying package configuration, since apt-utils is not installed
Selecting previously unselected package libsqlite3-0:amd64.
(Reading database ... 4038 files and directories currently installed.)
Preparing to unpack .../00-libsqlite3-0_3.22.0-1_amd64.deb ...
Unpacking libsqlite3-0:amd64 (3.22.0-1) ...
Selecting previously unselected package libssl1.1:amd64.
Preparing to unpack .../01-libssl1.1_1.1.0g-2ubuntu4.1_amd64.deb ...
Unpacking libssl1.1:amd64 (1.1.0g-2ubuntu4.1) ...
Selecting previously unselected package libkrb5support0:amd64.
Preparing to unpack .../02-libkrb5support0_1.16-2build1_amd64.deb ...
Unpacking libkrb5support0:amd64 (1.16-2build1) ...
Selecting previously unselected package libk5crypto3:amd64.
Preparing to unpack .../03-libk5crypto3_1.16-2build1_amd64.deb ...
Unpacking libk5crypto3:amd64 (1.16-2build1) ...
Selecting previously unselected package libkeyutils1:amd64.
Preparing to unpack .../04-libkeyutils1_1.5.9-9.2ubuntu2_amd64.deb ...
Unpacking libkeyutils1:amd64 (1.5.9-9.2ubuntu2) ...
Selecting previously unselected package libkrb5-3:amd64.
Preparing to unpack .../05-libkrb5-3_1.16-2build1_amd64.deb ...
Unpacking libkrb5-3:amd64 (1.16-2build1) ...
Selecting previously unselected package libgssapi-krb5-2:amd64.
Preparing to unpack .../06-libgssapi-krb5-2_1.16-2build1_amd64.deb ...
Unpacking libgssapi-krb5-2:amd64 (1.16-2build1) ...
Selecting previously unselected package libroken18-heimdal:amd64.
Preparing to unpack .../07-libroken18-heimdal_7.5.0+dfsg-1_amd64.deb ...
Unpacking libroken18-heimdal:amd64 (7.5.0+dfsg-1) ...
Selecting previously unselected package libasn1-8-heimdal:amd64.
Preparing to unpack .../08-libasn1-8-heimdal_7.5.0+dfsg-1_amd64.deb ...
Unpacking libasn1-8-heimdal:amd64 (7.5.0+dfsg-1) ...
Selecting previously unselected package libheimbase1-heimdal:amd64.
Preparing to unpack .../09-libheimbase1-heimdal_7.5.0+dfsg-1_amd64.deb ...
Unpacking libheimbase1-heimdal:amd64 (7.5.0+dfsg-1) ...
Selecting previously unselected package libhcrypto4-heimdal:amd64.
Preparing to unpack .../10-libhcrypto4-heimdal_7.5.0+dfsg-1_amd64.deb ...
Unpacking libhcrypto4-heimdal:amd64 (7.5.0+dfsg-1) ...
Selecting previously unselected package libwind0-heimdal:amd64.
Preparing to unpack .../11-libwind0-heimdal_7.5.0+dfsg-1_amd64.deb ...
Unpacking libwind0-heimdal:amd64 (7.5.0+dfsg-1) ...
Selecting previously unselected package libhx509-5-heimdal:amd64.
Preparing to unpack .../12-libhx509-5-heimdal_7.5.0+dfsg-1_amd64.deb ...
Unpacking libhx509-5-heimdal:amd64 (7.5.0+dfsg-1) ...
Selecting previously unselected package libkrb5-26-heimdal:amd64.
Preparing to unpack .../13-libkrb5-26-heimdal_7.5.0+dfsg-1_amd64.deb ...
Unpacking libkrb5-26-heimdal:amd64 (7.5.0+dfsg-1) ...
Selecting previously unselected package libheimntlm0-heimdal:amd64.
Preparing to unpack .../14-libheimntlm0-heimdal_7.5.0+dfsg-1_amd64.deb ...
Unpacking libheimntlm0-heimdal:amd64 (7.5.0+dfsg-1) ...
Selecting previously unselected package libgssapi3-heimdal:amd64.
Preparing to unpack .../15-libgssapi3-heimdal_7.5.0+dfsg-1_amd64.deb ...
Unpacking libgssapi3-heimdal:amd64 (7.5.0+dfsg-1) ...
Selecting previously unselected package libsasl2-modules-db:amd64.
Preparing to unpack .../16-libsasl2-modules-db_2.1.27~101-g0780600+dfsg-3ubuntu2_amd64.deb ...
Unpacking libsasl2-modules-db:amd64 (2.1.27~101-g0780600+dfsg-3ubuntu2) ...
Selecting previously unselected package libsasl2-2:amd64.
Preparing to unpack .../17-libsasl2-2_2.1.27~101-g0780600+dfsg-3ubuntu2_amd64.deb ...
Unpacking libsasl2-2:amd64 (2.1.27~101-g0780600+dfsg-3ubuntu2) ...
Selecting previously unselected package libldap-common.
Preparing to unpack .../18-libldap-common_2.4.45+dfsg-1ubuntu1_all.deb ...
Unpacking libldap-common (2.4.45+dfsg-1ubuntu1) ...
Selecting previously unselected package libldap-2.4-2:amd64.
Preparing to unpack .../19-libldap-2.4-2_2.4.45+dfsg-1ubuntu1_amd64.deb ...
Unpacking libldap-2.4-2:amd64 (2.4.45+dfsg-1ubuntu1) ...
Selecting previously unselected package libpq5:amd64.
Preparing to unpack .../20-libpq5_10.5-0ubuntu0.18.04_amd64.deb ...
Unpacking libpq5:amd64 (10.5-0ubuntu0.18.04) ...
Setting up libldap-common (2.4.45+dfsg-1ubuntu1) ...
Setting up libsasl2-modules-db:amd64 (2.1.27~101-g0780600+dfsg-3ubuntu2) ...
Setting up libsasl2-2:amd64 (2.1.27~101-g0780600+dfsg-3ubuntu2) ...
Setting up libroken18-heimdal:amd64 (7.5.0+dfsg-1) ...
Setting up libkrb5support0:amd64 (1.16-2build1) ...
Processing triggers for libc-bin (2.27-3ubuntu1) ...
Setting up libssl1.1:amd64 (1.1.0g-2ubuntu4.1) ...
debconf: unable to initialize frontend: Dialog
debconf: (TERM is not set, so the dialog frontend is not usable.)
debconf: falling back to frontend: Readline
debconf: unable to initialize frontend: Readline
debconf: (Can't locate Term/ReadLine.pm in @INC (you may need to install the Term::ReadLine module) (@INC contains: /etc/perl /usr/local/lib/x86_64-linux-gnu/perl/5.26.1 /usr/local/share/perl/5.26.1 /usr/lib/x86_64-linux-gnu/perl5/5.26 /usr/share/perl5 /usr/lib/x86_64-linux-gnu/perl/5.26 /usr/share/perl/5.26 /usr/local/lib/site_perl /usr/lib/x86_64-linux-gnu/perl-base) at /usr/share/perl5/Debconf/FrontEnd/Readline.pm line 7.)
debconf: falling back to frontend: Teletype
Setting up libheimbase1-heimdal:amd64 (7.5.0+dfsg-1) ...
Setting up libsqlite3-0:amd64 (3.22.0-1) ...
Setting up libkeyutils1:amd64 (1.5.9-9.2ubuntu2) ...
Setting up libk5crypto3:amd64 (1.16-2build1) ...
Setting up libwind0-heimdal:amd64 (7.5.0+dfsg-1) ...
Setting up libasn1-8-heimdal:amd64 (7.5.0+dfsg-1) ...
Setting up libhcrypto4-heimdal:amd64 (7.5.0+dfsg-1) ...
Setting up libhx509-5-heimdal:amd64 (7.5.0+dfsg-1) ...
Setting up libkrb5-3:amd64 (1.16-2build1) ...
Setting up libkrb5-26-heimdal:amd64 (7.5.0+dfsg-1) ...
Setting up libheimntlm0-heimdal:amd64 (7.5.0+dfsg-1) ...
Setting up libgssapi-krb5-2:amd64 (1.16-2build1) ...
Setting up libgssapi3-heimdal:amd64 (7.5.0+dfsg-1) ...
Setting up libldap-2.4-2:amd64 (2.4.45+dfsg-1ubuntu1) ...
Setting up libpq5:amd64 (10.5-0ubuntu0.18.04) ...
Processing triggers for libc-bin (2.27-3ubuntu1) ...
Removing intermediate container f190e9ddc4b7
 ---> 153076e0f670
Step 5/9 : RUN BUILD_DEPS="curl ca-certificates xz-utils" &&   apt-get -qq update &&   apt-get -qq install -y --no-install-recommends $BUILD_DEPS &&   cd /tmp &&   curl -SLO https://github.com/begriffs/postgrest/releases/download/v${POSTGREST_VERSION}/postgrest-v${POSTGREST_VERSION}-ubuntu.tar.xz &&   tar -xJvf postgrest-v${POSTGREST_VERSION}-ubuntu.tar.xz &&   mv postgrest /usr/local/bin/postgrest &&   cd / &&   apt-get -qq purge --auto-remove -y $BUILD_DEPS &&   apt-get -qq clean &&   rm -rf /var/lib/apt/lists/* /tmp/* /var/tmp/*
 ---> Running in 8476ddbfd12a
debconf: delaying package configuration, since apt-utils is not installed
Selecting previously unselected package openssl.
(Reading database ... 4183 files and directories currently installed.)
Preparing to unpack .../0-openssl_1.1.0g-2ubuntu4.1_amd64.deb ...
Unpacking openssl (1.1.0g-2ubuntu4.1) ...
Selecting previously unselected package ca-certificates.
Preparing to unpack .../1-ca-certificates_20180409_all.deb ...
Unpacking ca-certificates (20180409) ...
Selecting previously unselected package xz-utils.
Preparing to unpack .../2-xz-utils_5.2.2-1.3_amd64.deb ...
Unpacking xz-utils (5.2.2-1.3) ...
Selecting previously unselected package libpsl5:amd64.
Preparing to unpack .../3-libpsl5_0.19.1-5build1_amd64.deb ...
Unpacking libpsl5:amd64 (0.19.1-5build1) ...
Selecting previously unselected package libnghttp2-14:amd64.
Preparing to unpack .../4-libnghttp2-14_1.30.0-1ubuntu1_amd64.deb ...
Unpacking libnghttp2-14:amd64 (1.30.0-1ubuntu1) ...
Selecting previously unselected package librtmp1:amd64.
Preparing to unpack .../5-librtmp1_2.4+20151223.gitfa8646d.1-1_amd64.deb ...
Unpacking librtmp1:amd64 (2.4+20151223.gitfa8646d.1-1) ...
Selecting previously unselected package libcurl4:amd64.
Preparing to unpack .../6-libcurl4_7.58.0-2ubuntu3.5_amd64.deb ...
Unpacking libcurl4:amd64 (7.58.0-2ubuntu3.5) ...
Selecting previously unselected package curl.
Preparing to unpack .../7-curl_7.58.0-2ubuntu3.5_amd64.deb ...
Unpacking curl (7.58.0-2ubuntu3.5) ...
Setting up libnghttp2-14:amd64 (1.30.0-1ubuntu1) ...
Setting up libpsl5:amd64 (0.19.1-5build1) ...
Setting up librtmp1:amd64 (2.4+20151223.gitfa8646d.1-1) ...
Processing triggers for libc-bin (2.27-3ubuntu1) ...
Setting up xz-utils (5.2.2-1.3) ...
update-alternatives: using /usr/bin/xz to provide /usr/bin/lzma (lzma) in auto mode
update-alternatives: warning: skip creation of /usr/share/man/man1/lzma.1.gz because associated file /usr/share/man/man1/xz.1.gz (of link group lzma) doesn't exist
update-alternatives: warning: skip creation of /usr/share/man/man1/unlzma.1.gz because associated file /usr/share/man/man1/unxz.1.gz (of link group lzma) doesn't exist
update-alternatives: warning: skip creation of /usr/share/man/man1/lzcat.1.gz because associated file /usr/share/man/man1/xzcat.1.gz (of link group lzma) doesn't exist
update-alternatives: warning: skip creation of /usr/share/man/man1/lzmore.1.gz because associated file /usr/share/man/man1/xzmore.1.gz (of link group lzma) doesn't exist
update-alternatives: warning: skip creation of /usr/share/man/man1/lzless.1.gz because associated file /usr/share/man/man1/xzless.1.gz (of link group lzma) doesn't exist
update-alternatives: warning: skip creation of /usr/share/man/man1/lzdiff.1.gz because associated file /usr/share/man/man1/xzdiff.1.gz (of link group lzma) doesn't exist
update-alternatives: warning: skip creation of /usr/share/man/man1/lzcmp.1.gz because associated file /usr/share/man/man1/xzcmp.1.gz (of link group lzma) doesn't exist
update-alternatives: warning: skip creation of /usr/share/man/man1/lzgrep.1.gz because associated file /usr/share/man/man1/xzgrep.1.gz (of link group lzma) doesn't exist
update-alternatives: warning: skip creation of /usr/share/man/man1/lzegrep.1.gz because associated file /usr/share/man/man1/xzegrep.1.gz (of link group lzma) doesn't exist
update-alternatives: warning: skip creation of /usr/share/man/man1/lzfgrep.1.gz because associated file /usr/share/man/man1/xzfgrep.1.gz (of link group lzma) doesn't exist
Setting up openssl (1.1.0g-2ubuntu4.1) ...
Setting up ca-certificates (20180409) ...
debconf: unable to initialize frontend: Dialog
debconf: (TERM is not set, so the dialog frontend is not usable.)
debconf: falling back to frontend: Readline
debconf: unable to initialize frontend: Readline
debconf: (Can't locate Term/ReadLine.pm in @INC (you may need to install the Term::ReadLine module) (@INC contains: /etc/perl /usr/local/lib/x86_64-linux-gnu/perl/5.26.1 /usr/local/share/perl/5.26.1 /usr/lib/x86_64-linux-gnu/perl5/5.26 /usr/share/perl5 /usr/lib/x86_64-linux-gnu/perl/5.26 /usr/share/perl/5.26 /usr/local/lib/site_perl /usr/lib/x86_64-linux-gnu/perl-base) at /usr/share/perl5/Debconf/FrontEnd/Readline.pm line 7.)
debconf: falling back to frontend: Teletype
Updating certificates in /etc/ssl/certs...
133 added, 0 removed; done.
Setting up libcurl4:amd64 (7.58.0-2ubuntu3.5) ...
Setting up curl (7.58.0-2ubuntu3.5) ...
Processing triggers for ca-certificates (20180409) ...
Updating certificates in /etc/ssl/certs...
0 added, 0 removed; done.
Running hooks in /etc/ca-certificates/update.d...
done.
Processing triggers for libc-bin (2.27-3ubuntu1) ...
  % Total    % Received % Xferd  Average Speed   Time    Time     Time  Current
                                 Dload  Upload   Total   Spent    Left  Speed
100   164    0   164    0     0    180      0 --:--:-- --:--:-- --:--:--   180
100     9    0     9    0     0      7      0 --:--:--  0:00:01 --:--:--     7
xz: (stdin): File format not recognized
tar: Child returned status 1
tar: Error is not recoverable: exiting now
ERROR: Service 'postgrest' failed to build: The command '/bin/sh -c BUILD_DEPS="curl ca-certificates xz-utils" &&   apt-get -qq update &&   apt-get -qq install -y --no-install-recommends $BUILD_DEPS &&   cd /tmp &&   curl -SLO https://github.com/begriffs/postgrest/releases/download/v${POSTGREST_VERSION}/postgrest-v${POSTGREST_VERSION}-ubuntu.tar.xz &&   tar -xJvf postgrest-v${POSTGREST_VERSION}-ubuntu.tar.xz &&   mv postgrest /usr/local/bin/postgrest &&   cd / &&   apt-get -qq purge --auto-remove -y $BUILD_DEPS &&   apt-get -qq clean &&   rm -rf /var/lib/apt/lists/* /tmp/* /var/tmp/*' returned a non-zero code: 2
2018-11-06 10:09:07 [mini@s013 docker-postgrest]$

any suggestions ??

Out of date

Current release is 4.2 https://github.com/begriffs/postgrest/releases/tag/v0.4.2.0