There is a way in windows to access to the database?

Setup and configuration
1

Hello, I’m recently new in chirpstack and I want to know if there is a way to connect to the chirpstack database via postgres SQL in windows.

I’m using Docker in order to install and manage the servers. Also I’m using Kitematic to see the configuration in a better way.

Using Kitematic I try to set a published IP:PORT in order to connect, but it causes a crash in the server and stop working properly, so I’m a bit lost in order to what to do.

2

Well… yes there is in the docker-compose.yml file there is a configuration for postgresql, yo have to establish the ports like this:
postgresql:

    image: postgres:9.6-alpine

    ports:

      - '5433:5432'

    environment:

      - POSTGRES_PASSWORD=root

    volumes:

      - ./configuration/postgresql/initdb:/docker-entrypoint-initdb.d

      - postgresqldata:/var/lib/postgresql/data
1 Like