PostgreSQL

Description

PostgreSQL is a powerful, open source object-relational database system that uses and extends the SQL language combined with many features that safely store and scale the most complicated data workloads. The origins of PostgreSQL date back to 1986 as part of the POSTGRES project at the University of California at Berkeley and has more than 35 years of active development on the core platform.

Start in a container

Execute:

./tools/infrastructure/scripts/install_infrastructure.bash \
  --tool=postgresql \
  --install-type=docker

Start natively

Execute:

./tools/infrastructure/scripts/install_infrastructure.bash \
  --tool=postgresql \
  --install-type=native

Credentials

What comes up with it

The compose file applies two SQL files at first start: tools/infrastructure/docker/config/postgresql/init.sql creates the dc and dc_files tables the postgres Destination writes into, and tools/infrastructure/sql/kpi_views.sql adds the KPI views the Grafana dashboards read.