vpicavet / docker-pggis Goto Github PK

As of today's phusion/baseimage ...

/bin/sh: 1: sudo: not found
The command '/bin/sh -c echo "deb http://apt.postgresql.org/pub/repos/apt/ wheezy-pgdg main 9.5" > /etc/apt/sources.list.d/pgdg.list && wget --quiet -O - https://www.postgresql.org/media/keys/ACCC4CF8.asc | sudo apt-key add -' returned a non-zero code: 127

Attempting to build the docker returns an error with the default Ubuntu package of CGAL. Adding in a step to compile and install CGAL 4.3 from source resolves the issue.

The issue on the Mac is similar to the documented problem where the database comes up the first time, but the second time just leaves a trail of ......... as it tries to load.

On the Mac under boot2docker (or docker-machine) the issue was identified as boot2docker/boot2docker#581 which has to deal with file system UID mappings to the host file system. Alas the documented workaround of using a shell script to connect and fix things doesn't work.

Punting for now, but thought I'd save someone some time who tried this and got stuck. My workaround is the native Postgres.app distribution http://postgresapp.com/ (and some kind of native equivalent on AWS as the server side).

After successfully downloading the container, I did run it with provided command, however, I could not connect to it with local psql because of error:

psql: server closed the connection unexpectedly
    This probably means the server terminated abnormally
    before or while processing the request.

I saw no errors in docker logs
I am running:
latest Docker
Linux Mint (equivalent to Ubuntu 14.04)
psql 9.3.4

Building docker image fails.
Docker version 1.3.2, build 39fa2fa

//usr/local/lib/libSFCGAL.so.1: undefined reference to `vtable for boost::unit_test::unit_test_log_t'
collect2: error: ld returned 1 exit status
make[2]: *** [raster2pgsql] Error 1
make[2]: Leaving directory `/postgis-2.1.3/raster/loader'
make[1]: *** [rtloader] Error 2
make[1]: Leaving directory `/postgis-2.1.3/raster'
make: *** [all] Error 1
2014/11/26 17:07:28 The command [/bin/sh -c cd postgis-2.1.3 && make -j3 && make install] returned a non-zero code: 2

Getting the following when I try to log in with psql -h localhost -p 49153 -d pggis -U pggis --password

➜  ~  psql -h localhost -p 49153 -d pggis -U pggis --password
Password for user pggis:
psql: #

Am I dropping out of the psql client, or am I entering a password incorrectly?

The image build fails for me. This is the error I get:

Step 35 : RUN    /etc/init.d/postgresql start &&    psql --command "CREATE USER pggis WITH SUPERUSER PASSWORD 'pggis';" &&    createdb -T template0 -E UTF8 -O pggis pggis
 ---> Running in ffce12721066
/bin/sh: 1: /etc/init.d/postgresql: Permission denied
2014/08/27 17:58:47 The command [/bin/sh -c /etc/init.d/postgresql start &&    psql --command "CREATE USER pggis WITH SUPERUSER PASSWORD 'pggis';" &&    createdb -T template0 -E UTF8 -O pggis pggis] returned a non-zero code: 126

So it looks like the "postgres" user is not allowed to run /etc/init.d/postgresql in my case.

I use Ubuntu 14.04 and stock docker 0.9.1. I do not run docker.io as root, my user is in the docker group (see https://docs.docker.com/installation/binaries/#giving-non-root-access).