sameersbn / docker-postgresql

Dockerfile to build a PostgreSQL container image which can be linked to other containers.
MIT License
1.05k stars 467 forks source link

docker container die when run with `DB_EXTENSION=uuid-ossp` #133

Open nyotiemon opened 4 years ago

nyotiemon commented 4 years ago

docker-compose:

version: '3.3'
services:
    postgre-10-2:
      image: sameersbn/postgresql:10-2
      restart: always
      container_name: pgdb
      network_mode: "host"
      ports:
        - "5432:5432"
      environment:
        - DEBUG=true
        - PG_TRUST_LOCALNET=true
        - DB_EXTENSION=uuid-ossp
      volumes:
        - /home/user/docker/postgre/vol:/var/lib/postgresql

log from docker logs pgdb:

...
‣ Loading uuid-ossp extension...
+ for extension in $(awk -F',' '{for (i = 1 ; i <= NF ; i++) print $i}' <<< "${DB_EXTENSION}")
+ echo '‣ Loading uuid-ossp extension...'
+ psql -U postgres -d postgres -c 'CREATE EXTENSION IF NOT EXISTS uuid-ossp;'

log from docker events:

2019-12-03T15:12:41.191052596+08:00 container create d8e2bd02581bb83dff57ed8b6fb87dba528d32f71413b9311ef47d9a640aa2d5 (com.docker.compose.config-hash=786a351522d7020c2dcd1c172158fa0decb44da978cf17c63e872b761fcc22ae, com.docker.compose.container-number=1, com.docker.compose.oneoff=False, com.docker.compose.project=postgre, com.docker.compose.service=postgre-10-2, com.docker.compose.version=1.24.0, image=sameersbn/postgresql:10-2, maintainer=sameer@damagehead.com, name=pgdb)
2019-12-03T15:12:41.450095699+08:00 network connect 5bef42660ab09450e831718926ee8f2f2547bdc3c6cb3c45104762848e8e30af (container=d8e2bd02581bb83dff57ed8b6fb87dba528d32f71413b9311ef47d9a640aa2d5, name=host, type=host)
2019-12-03T15:12:42.126997069+08:00 container start d8e2bd02581bb83dff57ed8b6fb87dba528d32f71413b9311ef47d9a640aa2d5 (com.docker.compose.config-hash=786a351522d7020c2dcd1c172158fa0decb44da978cf17c63e872b761fcc22ae, com.docker.compose.container-number=1, com.docker.compose.oneoff=False, com.docker.compose.project=postgre, com.docker.compose.service=postgre-10-2, com.docker.compose.version=1.24.0, image=sameersbn/postgresql:10-2, maintainer=sameer@damagehead.com, name=pgdb)
2019-12-03T15:12:44.959592293+08:00 container die d8e2bd02581bb83dff57ed8b6fb87dba528d32f71413b9311ef47d9a640aa2d5 (com.docker.compose.config-hash=786a351522d7020c2dcd1c172158fa0decb44da978cf17c63e872b761fcc22ae, com.docker.compose.container-number=1, com.docker.compose.oneoff=False, com.docker.compose.project=postgre, com.docker.compose.service=postgre-10-2, com.docker.compose.version=1.24.0, exitCode=1, image=sameersbn/postgresql:10-2, maintainer=sameer@damagehead.com, name=pgdb)
2019-12-03T15:12:45.149794923+08:00 network disconnect 5bef42660ab09450e831718926ee8f2f2547bdc3c6cb3c45104762848e8e30af (container=d8e2bd02581bb83dff57ed8b6fb87dba528d32f71413b9311ef47d9a640aa2d5, name=host, type=host)
2019-12-03T15:12:46.358351218+08:00 network connect 5bef42660ab09450e831718926ee8f2f2547bdc3c6cb3c45104762848e8e30af (container=d8e2bd02581bb83dff57ed8b6fb87dba528d32f71413b9311ef47d9a640aa2d5, name=host, type=host)
2019-12-03T15:12:47.028189059+08:00 container start d8e2bd02581bb83dff57ed8b6fb87dba528d32f71413b9311ef47d9a640aa2d5 (com.docker.compose.config-hash=786a351522d7020c2dcd1c172158fa0decb44da978cf17c63e872b761fcc22ae, com.docker.compose.container-number=1, com.docker.compose.oneoff=False, com.docker.compose.project=postgre, com.docker.compose.service=postgre-10-2, com.docker.compose.version=1.24.0, image=sameersbn/postgresql:10-2, maintainer=sameer@damagehead.com, name=pgdb)
2019-12-03T15:12:48.460662744+08:00 container kill d8e2bd02581bb83dff57ed8b6fb87dba528d32f71413b9311ef47d9a640aa2d5 (com.docker.compose.config-hash=786a351522d7020c2dcd1c172158fa0decb44da978cf17c63e872b761fcc22ae, com.docker.compose.container-number=1, com.docker.compose.oneoff=False, com.docker.compose.project=postgre, com.docker.compose.service=postgre-10-2, com.docker.compose.version=1.24.0, image=sameersbn/postgresql:10-2, maintainer=sameer@damagehead.com, name=pgdb, signal=15)
2019-12-03T15:12:49.352485145+08:00 container die d8e2bd02581bb83dff57ed8b6fb87dba528d32f71413b9311ef47d9a640aa2d5 (com.docker.compose.config-hash=786a351522d7020c2dcd1c172158fa0decb44da978cf17c63e872b761fcc22ae, com.docker.compose.container-number=1, com.docker.compose.oneoff=False, com.docker.compose.project=postgre, com.docker.compose.service=postgre-10-2, com.docker.compose.version=1.24.0, exitCode=1, image=sameersbn/postgresql:10-2, maintainer=sameer@damagehead.com, name=pgdb)
2019-12-03T15:12:49.574709710+08:00 network disconnect 5bef42660ab09450e831718926ee8f2f2547bdc3c6cb3c45104762848e8e30af (container=d8e2bd02581bb83dff57ed8b6fb87dba528d32f71413b9311ef47d9a640aa2d5, name=host, type=host)
2019-12-03T15:12:50.928353376+08:00 container stop d8e2bd02581bb83dff57ed8b6fb87dba528d32f71413b9311ef47d9a640aa2d5 (com.docker.compose.config-hash=786a351522d7020c2dcd1c172158fa0decb44da978cf17c63e872b761fcc22ae, com.docker.compose.container-number=1, com.docker.compose.oneoff=False, com.docker.compose.project=postgre, com.docker.compose.service=postgre-10-2, com.docker.compose.version=1.24.0, image=sameersbn/postgresql:10-2, maintainer=sameer@damagehead.com, name=pgdb)
2019-12-03T15:12:51.044218120+08:00 container destroy d8e2bd02581bb83dff57ed8b6fb87dba528d32f71413b9311ef47d9a640aa2d5 (com.docker.compose.config-hash=786a351522d7020c2dcd1c172158fa0decb44da978cf17c63e872b761fcc22ae, com.docker.compose.container-number=1, com.docker.compose.oneoff=False, com.docker.compose.project=postgre, com.docker.compose.service=postgre-10-2, com.docker.compose.version=1.24.0, image=sameersbn/postgresql:10-2, maintainer=sameer@damagehead.com, name=pgdb)

The extension is working fine, it is only missing double-quote on it due to dash ("-") character.

> psql -h localhost -U postgres -d postgres -c 'CREATE EXTENSION IF NOT EXISTS "uuid-ossp";'
CREATE EXTENSION

update: running with --env 'DB_EXTENSION="uuid-ossp" will solve the issue as well.