temBoard

PostgreSQL Remote Control

Jean-Paul Argudo

17th march 2017

temBoard

… PostgreSQL Remote Control

Who am I ?

  • Jean-Paul Argudo (“jpa”)
  • using and advocating PostgreSQL since 2000
  • PostgreSQL France co-founder (2004)
  • and then PostgreSQL Europe (2008)
  • CEO @dalibo since 2005

The need

  • manage production PostgreSQL servers
  • all-in one web platform
  • easy, extensible, pluggable
  • PostgreSQL licence

# Let’s connect

# Dashboard

# Activity

# Overview (“Supervision”)

# Configuration

# Reload parameter

Restart

pg_hba.conf

# SAFER pg_hba.conf :-)

# pg_ident.conf

# Notifications

Setup

  • Users : global / local admin
  • “Instances” == PostgreSQL servers
  • Users & “Instances” groups

Instances

Work In Progress

  • Automated alerting mechanism
  • Maintenance plugin
  • PITR plugin (pitrery)
  • Rewrite of the whole interface!

Architecture

temboard-agent

  • Daemon / Scheduler / Workers
  • Python 2.6/2.7 & PostgreSQL >= 9.4
  • embedded HTTPS server (SimpleHTTPServer)
  • embedded PostgreSQL connector
  • REST API / .ini config file

temboard

  • web interface
  • Python 2.7
  • dependencies: psycopg2 / tornado / SQLAlchemy
  • bootstrap3 / jquery / Chart.JS / dygraph
  • Plugins architecture / .ini config file

repository

  • meta-data and metrics storage
  • requires >= PostgreSQL 9.5

Caveats

  • Linux support only
  • PostgreSQL >= 9.4 on monitored PGs
  • Python 3 : planned
  • WIP for version 1.0 : few weeks to go

# More information

# Questions?