All Projects → credativ → Elephant Shed

credativ / Elephant Shed

Licence: gpl-3.0
PostgreSQL Management Appliance

Projects that are alternatives of or similar to Elephant Shed

Go Notify
An email automation solution, written in Golang.
Stars: ✭ 143 (-2.05%)
Mutual labels:  postgres, prometheus, grafana
Pgwatch2
PostgreSQL metrics monitor/dashboard
Stars: ✭ 960 (+557.53%)
Mutual labels:  postgresql, postgres, grafana
Wal G
Archival and Restoration for Postgres
Stars: ✭ 1,974 (+1252.05%)
Mutual labels:  postgresql, postgres, backup
Barman
Barman - Backup and Recovery Manager for PostgreSQL
Stars: ✭ 1,044 (+615.07%)
Mutual labels:  postgresql, postgres, backup
Wal E
Continuous Archiving for Postgres
Stars: ✭ 3,313 (+2169.18%)
Mutual labels:  postgresql, postgres, backup
Grafana
The open and composable observability and data visualization platform. Visualize metrics, logs, and traces from multiple sources like Prometheus, Loki, Elasticsearch, InfluxDB, Postgres and many more.
Stars: ✭ 45,930 (+31358.9%)
Mutual labels:  postgres, prometheus, grafana
Sqlcell
SQLCell is a magic function for the Jupyter Notebook that executes raw, parallel, parameterized SQL queries with the ability to accept Python values as parameters and assign output data to Python variables while concurrently running Python code. And *much* more.
Stars: ✭ 145 (-0.68%)
Mutual labels:  postgresql, postgres
Backy2
backy2: Deduplicating block based backup software for ceph/rbd, image files and devices
Stars: ✭ 126 (-13.7%)
Mutual labels:  postgresql, backup
Pg stat monitor
PostgreSQL Statistics Collector
Stars: ✭ 145 (-0.68%)
Mutual labels:  postgresql, postgres
Bricks
A standard library for microservices.
Stars: ✭ 142 (-2.74%)
Mutual labels:  postgres, prometheus
Postgres Showcase
Postgres features showcase (commented SQL samples) for beginners
Stars: ✭ 121 (-17.12%)
Mutual labels:  postgresql, postgres
Postgres Operator
Production PostgreSQL for Kubernetes, from high availability Postgres clusters to full-scale database-as-a-service.
Stars: ✭ 2,166 (+1383.56%)
Mutual labels:  postgresql, postgres
Postgres Operator
Postgres operator creates and manages PostgreSQL clusters running in Kubernetes
Stars: ✭ 2,194 (+1402.74%)
Mutual labels:  postgresql, postgres
Timescaledb
An open-source time-series SQL database optimized for fast ingest and complex queries. Packaged as a PostgreSQL extension.
Stars: ✭ 12,211 (+8263.7%)
Mutual labels:  postgresql, postgres
Postgres Meta
A RESTful API for managing your Postgres. Fetch tables, add roles, and run queries
Stars: ✭ 146 (+0%)
Mutual labels:  postgresql, postgres
Backup Manager
Database backup manager for dumping to and restoring databases from S3, Dropbox, FTP, SFTP, and Rackspace Cloud
Stars: ✭ 1,589 (+988.36%)
Mutual labels:  postgresql, backup
Swarmprom
Docker Swarm instrumentation with Prometheus, Grafana, cAdvisor, Node Exporter and Alert Manager
Stars: ✭ 1,739 (+1091.1%)
Mutual labels:  prometheus, grafana
Ozo
OZO is a C++17 Boost.Asio based header-only library for asyncronous communication with PostgreSQL DBMS.
Stars: ✭ 138 (-5.48%)
Mutual labels:  postgresql, postgres
Go Cache
This project encapsulates multiple db servers, redis、ledis、memcache、file、memory、nosql、postgresql
Stars: ✭ 143 (-2.05%)
Mutual labels:  postgresql, postgres
Laravel Scout Postgres
PostgreSQL Full Text Search Engine for Laravel Scout
Stars: ✭ 140 (-4.11%)
Mutual labels:  postgresql, postgres

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:

Supported PostgreSQL versions, via https://apt.postgresql.org:

  • 11
  • 10
  • 9.6
  • 9.5
  • 9.4

Supported distributions:

  • Debian Stretch (9)
  • 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.

Note that the project description data, including the texts, logos, images, and/or trademarks, for each open source project belongs to its rightful owner. If you wish to add or remove any projects, please contact us at [email protected].