Introduction

PGSQL is the PostgreSQL Community Distribution that is developer friendly and cross-platform. We fully embrace core PostgreSQL and it's rich community based eco-system of enterprise-class extensions.

For releases through pg13, we support EL7+ as well as Ubuntu 16.04+. Starting with pg14, we only support EL8 (Redhat/Rocky/CentOS) & Ubuntu 20.04+. We are built with optimized and secure static binaries that also run on several other Linux flavors (your mileage may vary).
 

 

Download & Usage

 
We run in a sandboxed environment that is perfect for running in a container, on bare metal, or in the cloud environment of your choice.
 
Install as non-root user:
 

Usage sample:


Rock-Solid PostgreSQL
   v14beta2 24-Jun
New in 2021
v13.3-2 13-May
New in 2020
v12.7-2 13-May
New in 2019
v11.12-2 13-May
New in 2018
v10.17 13-May
New in 2017
v9.6.22 13-May
New in 2016

Oracle Compatibility & Migration
  Oracle to PG  v22.1 1-Jul
Migrate from Oracle to PG
  OracleFDW  v2.3.0 24-Sep
Oracle from PG
  Instant Client  v21.1 17-Mar
Oracle Instant Client & SQLPlus
  OraFCE  v3.15.1 6-May
Ora Built-in Packages
 
  pgOSQL  v0.1 20-Jul
PL/SQL® Compatibility
  PlusQL  v0.1 20-Jul
SQL*PLUS® Compatible CLI

Advanced Postgres Apps
  TimescaleDB  v2.3.1 7-Jul
Time Series Data
  Patroni  v2.1.0 6-Jul
Postgres HA Template
  pgLogical  v2.3.4 3-May
Logical Replication
  PostGIS  v3.1.3 2-Jul
Spatial Extensions
 
  Citus  v10.1.0 16-Jul
Multi Node Data & Queries
  pgBackRest  v2.34 7-Jun
Backup & Restore
  pgAudit  v1.5.0 21-Sep
Audit Logging
  Anonymizer  v0.9.0 3-Jul
Anonymization & Masking
 

Optimization & Analysis
  PL/Profiler  v4.1 23-Aug-19
Stored Procedure Profiler
  pgPool2  v4.2.3 19-May
Clustering Tool
  pgBouncer  v1.15.0 14-Jun
Lightweight Connection Pooler
  pgBulkLoad  v3.1.18 1-Jun
High Speed Data Loading
 
  pgRepack  v1.4.6 30-Sep
Remove Table/Index Bloat
  pgPartman  v4.5.1 13-May
Partition Managemnt
  pgCron  v1.3.1 30-Mar
Scheduler as Background Worker
  Analyzer  v2.1 8-May
Analyzer
 
  Archivist  v4.1.2 20-Dec
Archive Workloads
  QualStats  v2.0.3 4-Jun
WHERE Clause Stats
  StatKcache  v2.2.0 10-Dec
Filesystem Stats
  WaitSampling  v1.1.3 27-Jan
Stats for Wait Events
 
  HypoPG  v1.3.1 22-Jun
Hypothetical Indexes
  pgBadger  v11.5 18-Feb
Performance Reporting

Data Integration
  Debezium  v1.6.0 30-Jun
Stream DB Changes
  PgRedis  v2.0 20-Jun
Leverage Redis as a Hi-speed cache
  wal2json  v2.3 9-Aug
Output plugin for logical decoding
  MongoFDW  v5.2.9 14-Jun
MongoDB from PG
 
  ElasticSearchFDW  v0.11.1 9-Apr
ElasticSearch from PG
  MySQL FDW  v2.6.0 2-May
MySQL & MariaDB from PG
  TDS FDW  v2.0.2 26-Sep
SQL Server & Sybase from PG
  CassandraFDW  v3.1.5 30-Dec-19
Cassandra from PG
 
  HiveFDW  v4.0 27-Sep
Big Data Queries from PG
  FixedDecimal  v1.1.0 19-Nov
Much faster than NUMERIC
  Multicorn  v1.4.1 12-Apr
Python FDW Library

Database Developers
  PL/pgSQL  v13 13-Feb
Postgres Procedural Language
  PL/Debugger  v2.0 24-Feb
Procedural Language Debugger
  psqlODBC  v13.01 2-May
ODBC Driver
  PL/Python  v13 13-Feb
Python3 Stored Procedures
 
  PL/Perl  v13 13-Feb
Perl Stored Procedures
  PL/Java  v1.6.2 27-Nov
Java Stored Procedures

Management & Monitoring
  pgAdmin 4  v5.5 15-Jul
PG Admin
  OmniDB  v2.17.0 5-Dec-19
OmniDB

Hybrid & Multi-Cloud
  Kubernetes  v1.21 9-Apr
HA clusters using MicroK8s

Foreign Datastores
  Kafka  v2.7.1 10-May
Streaming Platform
  Redis 6.2.4  v6.2 1-Jun
Hi-Speed Cache
  MariaDB 10.6.3  v10.6x 5-Jul
MySQL Replacement
  SQL Svr 15  v15.0.4138 10-Jun
Microsoft SQL Server 2019
 
  MongoDB 5.0  v5.0 13-Jul
Document Database
  ElasticSearch 7.13.4  v7.x 20-Jul
Search and Analytics Engine
  Oracle  v19.3c 1-May
Oracle Database


© 2021 PGSQL.IO denis@lussier.io