BigSQL Components

DevOps Tools

PostGIS 2.3.1 New! Dec 14 Spatial & Geographic objects
pgAdmin3 1.23.0a New! Oct 20 Fat client Dev Tool for PG
pgAdmin4 1.1 New! Nov 8 Developers web console
bam2 1.6.3 New! Oct 27 BigSQL DevOps Manager
PGC (pgcli) 3.0.2 New! Nov 8 CLI for Provisioning & Management
pgBadger 9.0  SQL Performance Analyzer
plProfiler 3.1 New! Nov 23 Stored Proc Performance Profiler
plDebugger 9.6.0 New! Dec 28 Stored Procedure Debugger
pgRepack 1.3.4 New! Nov 8 Reorg tables w/ minimal locks
pgBulkload 3.1.12 New! Dec 14 High speed data loading
pgPartMan 2.6.3 New! Jan 11 Table Partitioning
OpenSSH 0.0.6.0 Coming! January 2017 Native SSH server and client tools for Windows
WebTTY 1.2 New! Jan 11 Terminal from Browser over HTTPS
pgAgent 3.4.1a Coming! January 2017 Job Scheduling
 

Legacy RDBMS Migration & Tools

ora2pg 17.6 New! Nov 23 Oracle migration
OraFCE 3.3.1  Oracle's compatibility functions & packages
OracleFDW 1.5.0  Oracle integration
TDS FDW 1.0.8 New! Nov 23 Sybase/SQLServer integration
pgTSQL 9.5 Sybase/SQLServer compatibility
MySQL FDW 2.1.2 MySQL Interop
 

High Availability

Slony-I 2.2.5 Enterprise-level replication system
pgHA 2.1 Failover and/or Disaster Recovery without application programming changes
pgBackRest 1.12 New! Dec 28 Reliable backup & restore that seamlessly scales to large workloads
pgBouncer 1.7.2 Connection Pooler
 

Advanced Security

Audit 1.1.0 New! Dec 28 Detailed logging for government, financial, or ISO requirements
SetUser 1.1.0 New! Dec 28 Privilege escalation with enhanced logging and control

Big Data Integration & Interoperability

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

Stored Procedure Languages

Python 2.7.12 PL/Python stored functions
Perl 5.20.3.3 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 8.3.0.16 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 9.4-1212 New! Nov 2 PostgreSQL JDBC Driver
psycopg2 2.6.2 Python DB Adapter (uses libpq)
pg8000 1.10.6  Python DB Adapter (pure python)
npgsql 3.1.9 New! Nov 20 .NET Data Provider for PG
ruby-pg 0.18.4 Ruby interface to PostgreSQL
psqlodbc 9.5.400  PostgreSQL ODBC Driver
C* JDBC 2.1-2 Cassandra JDBC Driver