BigSQL Components

DevOps Tools

PostGIS 2.3.3-1 New! Jul 13 Spatial & Geographic objects
pgAdmin3 1.23.0b  Jun 8 Fat client Dev Tool for PG
pgAdmin4 Web 1.6 New! Jul 13 Developers web console (included with pgDevops)
pgDevOps 1.6-3 New! Aug 10 Dev & Ops Web App (includes pgAdmin4 Web)
PGC (pgcli) 3.2.9 New! Sep 18 CLI for Provisioning & Management
pgBadger 9.2 New! Jul 31 SQL Performance Analyzer
plProfiler 3.2-1  Apr 15 Stored Proc Performance Profiler
plDebugger 9.6  Stored Procedure Debugger
pgRepack 1.3.4  Reorg tables w/ minimal locks
pgBulkload 3.1.13  High speed data loading
pgPartMan 3.0.2 New! Sep 8 Table Partitioning
OpenSSH 0.18 New! Jul 31 Native SSH server and client tools for Windows
WebTTY 1.2  Terminal from Browser over HTTPS
pgAgent 3.4.1  Mar 23 Job Scheduling

Legacy RDBMS Migration & Tools

ora2pg 18.2 New! Sep 18 Oracle migration
OraFCE 3.4.0 New! Jul 10 Oracle's compatibility functions & packages
OracleFDW 1.5.0  Oracle integration
TDS FDW 1.0.8  Sybase/SQLServer integration
pgTSQL 9.5 Sybase/SQLServer compatibility
MySQL FDW 2.3.0 New! Sep 21 MySQL Interop

High Availability, Backup & Replication Solutions

Slony-I 2.2.6 New! Sep 21 Enterprise-level replication system
Patroni 1.3.3 New! Aug 31 Failover and/or Disaster Recovery without application programming changes
pgBackRest 1.23 New! Sep 18 Reliable backup & restore that seamlessly scales to large workloads
pgBouncer 1.7.2 Connection Pooler

Advanced Security

Audit 1.1.1 New! Sep 7 Detailed logging for government, financial, or ISO requirements
SetUser 1.4.0 New! Aug 31 Privilege escalation with enhanced logging and control

Big Data Integration & Interoperability

CassandraFDW 3.0.1  Robust Cassandra interoperability
HadoopFDW 2.1.0 Hive Queries
Cstore FDW 1.5  Optimized Row Columnar (ORC) Store

Stored Procedure Languages

Python 2.7.13 PL/Python stored functions
Perl PL/Perl stored functions
Java 1.5.0 PL/Java stored functions
TCL 8.6 PL/Tcl stored functions
javascript 1.5.3  PL/V8 stored functions.
R PL/R stored functions.

Client Connectors

You do not retrieve these client libraries with our server-side pgcli. Instead use approriate client specific tools such as maven for java, pip for python, nuget for .NET, or gems for ruby.
pgjdbc 42.1.4 New! Aug 1 PostgreSQL JDBC Driver
psycopg2 New! Jul 24 Python DB Adapter (uses libpq)
pg8000 1.11.0 New! Aug 16 Python DB Adapter (pure python)
npgsql 3.2.5 New! Jul 22 .NET Data Provider for PG
ruby-pg 0.21.0  Ruby interface to PostgreSQL
psqlodbc 9.6.500 New! Sep 5 PostgreSQL ODBC Driver
C* JDBC 2.1-2 Cassandra JDBC Driver