• Stars
    star
    201
  • Rank 190,057 (Top 4 %)
  • Language
    Shell
  • License
    GNU General Publi...
  • Created over 6 years ago
  • Updated 4 months ago

Reviews

There are no reviews yet. Be the first to send feedback to the community and the maintainers!

Repository Details

PostgreSQL Management Appliance

Intro

Elephant Shed is a web-based PostgreSQL management front-end that bundles several utilities and applications for use with PostgreSQL. It currently manages single-node Linux PostgreSQL servers and appliances.

The main components are:

All PostgreSQL versions are supported via https://apt.postgresql.org.

Supported distributions:

  • Debian Bullseye (11)
  • Debian Buster (10)
  • Debian Stretch (9)
  • Ubuntu Focal (20.04)
  • Ubuntu Bionic (18.04)
  • RHEL/CentOS (7)

Download

Packages, Vagrant boxes, images: https://elephant-shed.io/#download

Documentation

The documentation is located at https://elephant-shed.io/doc/

Screenshots

Portal

The main portal webpage has links to all bundled applications. It also shows the PostgreSQL status, and allows starting/stopping the clusters, backup, and log reports.

Figure: Elephant Shed portal

Cockpit

For managing clusters and services, Cockpit is used.

Figure: Cockpit Cluster Service

Monitoring - Prometheus

Prometheus is a metric based monitoring system for servers and services. It collects metrics from configured targets at given intervals, evaluates rule expressions, displays the results, and can trigger alerts if some condition is observed to be true.

Figure: Prometheus graphing the load

Monitoring - Grafana

Grafana bundles metrics collected by Prometheus and presents them in a dashboard.

Figure: Grafana - PostgreSQL Server Overview

DBA Tool - OmniDB

OmniDB is a management tool for PostgreSQL to help DBAs execute many different tasks. It provides user management, DDL functionality, an interactive SQL shell, and more.

Figure: OmniDB

Backup - pgBackRest

The Elephant Shed comes with a preinstalled backup solution, pgBackRest.

Figure: pgBackRest Backup via Cockpit

Reporting - pgBadger

A pgBadger report is created for each PostgreSQL instance.

Figure: pgBadger overview

Web Terminal - Shell In A Box

Shell In A Box is a convenient web based terminal.

Remote Control - tmate

tmate is a fork of the popular terminal multiplexer tmux, tweaked for instant terminal sharing. It is preconfigured to connect to a relay server and enables the user to share the current terminal with a third party using a secret token.

Figure: tmate

License

The Elephant Shed itself is licensed under the GPLv3 (https://www.gnu.org/licenses/gpl-3.0.html).

All bundled components are Free/Open-Source software with a known and approved open source license.

Support

Elephant Shed is an open source project, developed and maintained by credativ.

For the Elephant Shed PostgreSQL appliance, credativ offers comprehensive technical support with service level agreements, which are also available on 365 days a year and 24 hours a day as an option.

Installation and integration support, as well as an introduction in Elephant Shed PostgreSQL appliance is of course also part of credativ's services. If you are interested, please feel free to contact us.

More Repositories

1

sqlreduce

Reduce verbose SQL queries to minimal examples
Python
47
star
2

plutono

Fork of Grafana keeping the Apache License
TypeScript
42
star
3

omdb-postgresql

PostgreSQL Schema for OMDB
PLpgSQL
39
star
4

informix_fdw

Foreign Data Wrapper for Informix Databases
C
28
star
5

pg_snakeoil

The PostgreSQL Antivirus #pgSnakeOil
C
25
star
6

pg_checksums

Activate/deactivate/verify checksums in offline Postgres clusters
Perl
25
star
7

pg_backup_ctl

A shell script to manage PostgreSQL archiving and basebackups
Shell
24
star
8

postgresql-common

Debian's PostgreSQL cluster management wrapper (Mirror)
Perl
18
star
9

toastinfo

Show storage structure of varlena datatypes in PostgreSQL
C
16
star
10

ansible-playbook-patroni-debian

Ansible playbook for a Debian-based Patroni HA PostgreSQL cluster
15
star
11

puppet-ssh-hiera

puppet module to manage ssh users and keys from a hiera backend
Ruby
14
star
12

postfix-ldap-schema

Simple LDAP schema for Postfix which provides the types needed by http://www.postfix.org/LDAP_README.html
12
star
13

pg_cloudconfig

Tool to set optimized defaults for PostgreSQL in virtualized environments
Python
10
star
14

vali

Fork of Loki keeping the Apache License
Go
10
star
15

azure-manage

Python
9
star
16

apt-snapper

Wrapper script to take snapper snapshots from package manager hooks
Shell
8
star
17

icingaweb2-module-azure

Importer plugin module for IcingaWeb2 Director plugin to connect to Microsoft Azure API
PHP
5
star
18

limux-gosa

Perl
5
star
19

pgapi

REST API for PostgreSQL clusters
Python
4
star
20

kprinter4

C++
4
star
21

db2fce

DB2 compatibility environment for PostgreSQL
PLpgSQL
4
star
22

pg_xlog_location_diff

Backport of function pg_xlog_location_diff() from PostgreSQL 9.2.
C
3
star
23

check_ganeti

Nagios/Icinga plugin for checking the health of your Ganeti cluster
Perl
3
star
24

milter-regex

C
3
star
25

pglogcheck

PostgreSQL Log Analyzer
Perl
2
star
26

puppet-postfix

postfix module for puppet with multi-instance support
Puppet
2
star
27

puppet-network

puppet module to handle various network configuration stuff
Ruby
2
star
28

puppet-websvn

puppet module to manage websvn
Ruby
2
star
29

gitlab-remote

Commandline interface for gitlab to easily work with multiple repositories
Python
2
star
30

pg_xlog_analyzer

Generates statistics about PostgreSQL xlog segments using pg_xlogdump.
Python
2
star
31

postgresql-lts

PostgreSQL long term support development
C
2
star
32

server-info-tty

Small python tool to display some facts on a given server on a TTY.
Python
1
star
33

linux-ftools

This is a fork of the linux-ftools command line tools from https://code.google.com/p/linux-ftools/.
Shell
1
star
34

puppet-stdpackages

simple puppet module to install some standard packages
Puppet
1
star
35

puppet-ntp-hiera

puppet module to manage ntp configuration from hiera
Ruby
1
star
36

puppet-bind

puppet module to manage bind
Ruby
1
star
37

puppet-nfs

puppet module to manage an nfs server
Puppet
1
star
38

puppet-vim

Simple vim puppet module
Ruby
1
star
39

puppet-dsh

puppet module to ensure dsh and manage group files
Ruby
1
star
40

credativ-postgresql-keyring

Keyring for https://packages.credativ.com/public/postgresql/
1
star
41

puppet-ferm

simple puppet module to manage ferm with a static config
Ruby
1
star
42

pkg-rt-extension-notifyowners

Debian packaging for RT-Extension-NotifyOwners
Perl
1
star
43

dh-make-puppet

a simple tool for debianizing of puppet modules
Shell
1
star
44

puppet-puppet_managed

a custom parser function which allows adding managed by puppet headers
Ruby
1
star
45

pkg-libbusiness-hours-perl

Debian packaging for libbusiness-hours-perl
Perl
1
star
46

pkg-anysyncd

packaging for anysyncd (https://github.com/formorer/AnySyncd)
Perl
1
star
47

centos-updatetypes

this script will compare a given rpm-list to a repositories xml'file and list packages with possible updates.
Python
1
star
48

puppet-keepalived

puppet module to manage keepalived
Ruby
1
star
49

puppet-rbldnsd

puppet module to manage rbldnsd
Puppet
1
star
50

plsh-mtb

PostgreSQL multi-tenant backup based on PL/SH and Korn Shell
Shell
1
star
51

check-pgbackrest

Python
1
star
52

puppet-example42lib

Fork of the example42 lib files in their puppi module
Ruby
1
star