A curated list of awesome Greenplum resources, tools 
Greenplum is an advanced, fully featured, open source data platform. It provides powerful and rapid analytics on petabyte scale data volumes. Uniquely geared toward big data analytics, Greenplum Database is powered by the world’s most advanced cost-based query optimizer delivering high analytical query performance on large data volumes. Greenplum.org)
🐘 Contributions welcome. Add links through pull requests or create an issue to start a discussion.
- High-Availability
- Business Intelligence
- Backups
- GUI
- Distributions
- CLI
- Server
- Monitoring
- Extensions
- Optimization
- Utilities
- Language bindings
- Tutorials
- Blogs
- Articles
- Newsletters
- PaaS (PostgreSQL as a Service)
- Docker images
- Videos
- howto
- PgBouncer - Lightweight connection pooler for PostgreSQL
- Tableau - Use Tableau
- gpcrondump - Use gpcrondump to backup databases, data, and objects such as database roles and server configuration files.
- gpBackup - ACreate a Greenplum Database backup for use with the gprestore utility.
- pgAdmin4 - PostgreSQL Administration and Management GUI.
- Adminer - Full-featured database management tool written in PHP.
- OmniDB - Open Source Collaborative Environment For Database Management
- DataGrip - IDE with advanced tool sets and good cross-platform experience (Commercial Software).
- DBeaver - Universal Database Manager with excellent support for PostgreSQL.
- Open Source Greenplum - Ubuntu - The Easiest Way to Get Started with PostgreSQL on Ubuntu.
- Pivotal Greenplum - Minimum set of Windows binaries of the PostgreSQL database. Also made available through NuGet.
- pgcli - Postgres CLI with autocompletion and syntax highlighting
- psql - The built-in PostgreSQL CLI client
- psql2csv - Run a query in psql and output the result as CSV
- apgdiff - Compares two database dump files and creates output with DDL statements that can be used to update old database schema to new one.
- ERAlchemy - ERAlchemy generates Entity Relation (ER) diagram from databases.
- mysql-postgresql-converter - Lanyrd's MySQL to PostgreSQL conversion script.
- ora2pg - Perl module to export an Oracle database schema to a PostgreSQL compatible schema.
- pg_activity - top like application for PostgreSQL server activity monitoring.
- pg-formatter - A PostgreSQL SQL syntax beautifier (Node.js).
- pganalyze - PostgreSQL Performance Monitoring (Commercial Software).
- pgbadger - Fast PostgreSQL Log Analyzer.
- PgBouncer - Lightweight connection pooler for PostgreSQL.
- pgCenter - Provides convenient interface to various statistics, management task, reloading services, viewing log files and canceling or terminating database backends.
- pgclimb - Export data from PostgreSQL into different data formats.
- pgfutter - Import CSV and JSON into PostgreSQL the easy way.
- PGInsight - CLI tool to easily dig deep inside your PostgreSQL database.
- pgloader - Loads data into PostgreSQL using the COPY streaming protocol, and does so with separate threads for reading and writing data.
- pgpool-II - Middleware that provides connection pooling, replication, load balancing and limiting exceeding connections.
- pgsync - Tool to sync PostgreSQL data to your local machine.
- PGXN client - Command line tool to interact with the PostgreSQL Extension Network
- postgresql-metrics - Tool that extracts and provides metrics for your PostgreSQL database.
- PostgREST - Serves a fully RESTful API from any existing PostgreSQL database.
- pREST - Serve a RESTful API from any PostgreSQL database (Golang)
- PostGraphQL - A GraphQL schema created by reflection over a PostgreSQL schema.
- yoke - PostgreSQL high-availability cluster with auto-failover and automated cluster recovery.
- pglistend - A lightweight PostgresSQL
LISTEN/NOTIFYdaemon built on top ofnode-postgres. - ZSON - PostgreSQL extension for transparent JSONB compression
- pg_bulkload - It's a high speed data loading utility for PostgreSQL.
- pg_migrate - Manage PostgreSQL codebases and make VCS simple.
- sqitch - Tool for managing versioned schema deployment
- pgmigrate - CLI tool to evolve schema migrations, developed by Yandex
- pgcmp - Tool to compare database schemas, with capability to accept some persistent differences
- greenplum-downloader - Tool to download Greenplum files from Pivotal Network
- greenplum-dockers - Tool to build Greenplum docker files
- Common Lisp: Postmodern
- Elixir: postgrex
- Go: pgx
- Java: PostgreSQL JDBC Driver
- .Net/.Net Core: Npgsql
- Node: node-postgres, pg-promise
- Perl: DBD-Pg
- PHP: Pomm, pecl/pq
- Ruby: pg
- Rust: rust-postgresql
- Backup and recover a PostgreSQL DB using gpcrondump - Tutorial about to backup and restore data for Greenplum using gpcrondump.
- Data loading using gpfdist - Tutorial about loading data into Greenplum using GpfdistService.
- Using Greenplum and Apache Spark via JDBC
- Using Greenplum-Spark connector
- Using Greenplum and pgAdmin4
- Using Streamsets to load data from Kafka into Greenplum
- Using Greenplum to access Minio - distributed object storage via S3 Protocol
- Greenplum.org Blog - Blog aggregation service for Greenplum.org.
- Pivotal Guru blog
- Pivotal Greenplum blog
-
Using Greenplum PXF to access Minio distributed object storage server
-
Using Greenplum PXF to access Minio distributed object storage server
-
Parallel access to external data sources from Greenplum DB using PXF
- Pivotaldata - Greenplum official image. Based on the official Greenplum 4.3.7.x.
- Open source GPDB 5 on Ubuntu - Open Source GPDB 5.x installed on Ubuntu container.
- postgres - Official postgres container (from Docker)
- Greenplum Youtube channel - Greenplum related videos
- PGConf US Youtube channel - Conference videos
- Backup and restore Greenplum database
- How to use Greenplum-Spark connector
- How to download Pivotal Greenplum via automated tool or See this link
TBD