Skip to content
GitLab

Draft: Added sql logs

Open Michal Zander requested to merge mzander/sql-logs into develop

Firstly we need to install necessary libraries to build http extension:

apt install -y libcurl4-openssl-dev

apt install -y libpq-dev postgresql-server-dev-12

git clone https://github.com/pramsey/pgsql-http.git

so we should be able to do make and sudo make install then we can CREATE EXTENSION http in our database

Next step will be creating our dockers that collect, send and visualize sent logs by creating a docker-compose.yaml file in selected directory

version: "3"

networks:
  loki:

services:
  loki:
    image: grafana/loki:2.6.0
    ports:
      - "3100:3100"
    command: -config.file=/etc/loki/local-config.yaml
    networks:
      - loki

  grafana:
    image: grafana/grafana:latest
    ports:
      - "3000:3000"
    networks:
      - loki

and to start our dockers we use this command:

docker-compose -f docker-compose.yaml up

in localhost:3000 there is located grafana where we need to setup loki as a source of logs and change url to http://loki:3100

For more information look in #68

Edited by Michal Zander