Hi Florian, What kind of scenario do you have in mind for what you referred to as „internal use“? Do you want to query some information from the database? Could you elaborate on that?
In addition, I’m wondering what does this init sql script do? Create certain databases, schemas, tables etc? Cheers Patrick > Am 22.05.2020 um 19:42 schrieb Florian Micklich <[email protected]>: > > Hiho, > > I want to start implementing a new service for the StreamPipes > installer called postgis which, as the name suggests, uses PostGIS [1]. > > This service is intended for a geo-sink as well as for some internal > use in certain Geo-PE's. > > > Therefore I created already a docker-compose file and also an initial > setup script (for testing I had to comment out some parts) > > > version: "2.0" > > services: > postgis: > image: postgis/postgis > ports: > - 54321:5432 > environment: > POSTGRES_USER: geo_streampipes > POSTGRES_PASSWORD: [LIKEPOSTGRES] > volumes: > - ./scripts/init.sql:/docker-entrypoint-initdb.d/01_init.sql > # extra_hosts: > # - host.docker.internal:${HOST_DOCKER_INTERNAL} > # networks: > # spnet: > > volumes: > postgis: > > # networks: > # spnet: > # external: true > > > So how can this be part of the StreamPipes installer as a service? > > Another option would be to create an own docker "streampipes_postgis" > image and the initial script would be already implemented. > > The own image would be nicer and cleaner in my point of view. > > What do you think? > > > Greetings > Florian >
