Hi Everyone: question about using a local DB with Docker. In the docs (https://www.prisma.io/docs/run-prisma-server/local-prisma-setup-je3i/#example-docker-compose-setup) it says:

prisma is using the postgres-db container as its database. Instead of referencing the database host via an IP address or URL, it simply references the postgres-db image as the database host:

I can connect to my DB using

docker exec -it postgres psql -U prisma

, but how do I connect via a GUI like Postico? Postico expects a host like this: This gives the error "Hostname not found". Can anyone advise if this is possible?

i believe you would expose the port (3306?) in the docker container, and connect to it directly. Regardless of how prisma connects to it.

Hi Jared: thanks for the help. I set up my docker-compose.yml like this:

version: '3'
services:
  prisma:
    image: prismagraphql/prisma:1.18
    restart: always
    ports:
    - "4466:4466"
    environment:
      PRISMA_CONFIG: |
        port: 4466
        # uncomment the next line and provide the env var PRISMA_MANAGEMENT_API_SECRET=my-secret to activate cluster security
        # managementApiSecret: my-secret
        databases:
          default:
            connector: postgres
            host: localhost
            port: 5432
            user: prisma
            password: prisma
            migrations: true
            rawAccess: true
  postgres:
    image: postgres
    restart: always
    ports:
    - 5432:5432
    environment:
      POSTGRES_USER: prisma
      POSTGRES_PASSWORD: prisma
    volumes:
      - postgres:/var/lib/postgresql/data
volumes:
  postgres:

i can't see what's wrong. Maybe others can chime in on it

in the prisma config, try changing the host from

localhost

to

postgres

@cedric I have done that, and it works. But then I how would I go about accessing my database via Postico?

in postico on your host machine, it should be available at localhost:5432

I tried that but it doesn't work, because postgres is not running on localhost. Postico gives the error:

could not connect to server: Connection refused
	Is the server running on host "localhost" (::1) and accepting
	TCP/IP connections on port 5432?

oh!

trying now 🙂

awesome, yeah that's a super non-intuitive aspect of docker-compose, but yml requires strings with special characters like

:

to be wrapped in quotes

i see, got it

we did it!

🙌

@Jared you told me to use quotes too... my bad 🙂

¯\_(ツ)_/¯