Can't ssh to postgres container in multi image mode

Build Environment Databases
1

I would like to ssh to my Postgres container and not only my primary app container.
How can I do that, CircleCi only offer me one IP on the web interface.

38
Screen Shot 2018-08-24 at 17.17.38.png2696×780 97.2 KB

My job :

  test:                                                                                                                                                                 
    resource_class: xlarge
    working_directory: /usr/src/app/
    docker:
      - image: auchandirect/hive:${CIRCLE_SHA1}
        auth:
          username: $DOCKER_USER
          password: $DOCKER_PASS
        environment:
          DB: XX
          DB_USER: X
          DB_PASSWORD: XX

      - image: postgres:10.1
        environment:
          POSTGRES_USER: XX
          POSTGRES_DB: XX
          POSTGRES_PASSWORD: XX
2

You cannot SSH to secondary containers by design. To do so, you’d have to have permissions on the Docker host, but that has access to all customers’ builds, so that’s a no-go. :smiley_cat:

I don’t know the Postgres image, but bear in mind it may not even have a running shell on it, never mind an SSH server - Docker containers often don’t have either.

What do you want to achieve by shelling to the database container? Maybe the problem can be attacked in a different way.

3

I wanted to get the postgres logs.
I thought the logs from the web interface were just a snapshot at a certain point of a time, in fact they are constantly refreshed. Thx.

4

Gotcha. Assuming the console output of secondary containers is shown in the UI, perhaps there is a way to redirect the logs to stdout? You have a command key within your images, so you can start up Postgres with whatever options you like.