PostgreSQL: An Enterprise Database

PostgreSQL is an enterprise-class, relational database management system with proven architecture and more than 30 years of active development.

Crunchy Data advances the PostgreSQL technology ecosystem to provide the most powerful 100% open source enterprise database management system.

DBMS of the Year 2017 DBMS of the Year 2018

DB Engines announced PostgreSQL as the Database Management System of the year in 2017 and 2018 out of 343 monitored systems.

Crunchy Data's Certified PostgreSQL Features and Benefits

Security / Compliance

The Most Stringent Security Accreditations
Capabilities Validated by Common Criteria Certification
  • Enhanced audit logging
  • Identification and authentication notably supports SSL, LDAP, GSSAPI
  • Role based access control (RBAC)
  • Protection of the security functionality
Additional Security Capabilities
  • Row-level security (RLS)
  • Authentication mechanisms
    • Certificate-based authentication (PKI), GSSAPI, LDAP
  • Encryption of data at rest: pgcrypto, OpenSSL is FIPS 140-2 compliant, OS / Hardware encryption solutions
Extensibility from Native Hooks
  • Enhanced audit logging utility
  • PostgreSQL STIG compliance
  • pgAudit can be configured for low level/statement level logging
Common Criteria Logo

High Availability

Crunchy High Availability PostgreSQL can minimize downtime and meet very high uptime requirements.

Supports secure, enterprise-grade deployments in all major public clouds, on-premise infrastructure and hybrid setups

Supports Native Replication that can be leveraged to provide PostgreSQL Master and Standby/Replica configurations

Both Synchronous and Asynchronous replication configuration options to Multiple Read Only Replica Databases

Backup / Restore / Disaster Recovery

pgBackRest provides high performance, enterprise capabilities for physical backups of the database including:

Full, incremental and differential backups to reduce data loss due to the disaster recovery

Parallel backup and restore.

Backup rotation and archive expiration.

Streaming compression, delta restore, checksums, and encrypted backups.

Database Metrics Collection & Monitoring

  • pgMonitor is the open source monitoring solution for key health checks and performance metric collection for PostgreSQL clusters.
  • Track the metrics that matter for making resource and intervention decisions, including:
    • Uptime and availability
    • CPU, RAM, and disk usage
    • Replication lag, transaction wraparound, index bloat, and other statistics to avoid downtime events
    • PostgreSQL utilization metrics
  • Crunchy Data's cloud-native solutions are preconfigured to deploy Prometheus and Grafana based Metrics Collection and Monitoring Solutions with pgMonitor.
Grafana Panel displaying OS, PostgreSQL, etcd, and Prometheus metrics

Administration Tools

Crunchy Certified PostgreSQL includes support for pgAdmin4 – a leading PostgreSQL administration utility that provides:

Powerful query tool with color syntax highlighting

Fast data grid for display and entry of data

Graphical query plan display

Grant wizard for rapid updates to ACLs

Procedural language debugger that supports PL/pgSQL

Create, view, and edit all common PostgreSQL objects and routine maintenance

Geospatial Data Types

Crunchy Certified PostgreSQL comes with the PostGIS geospatial database extender that brings secure, robust mapping and geospatial awareness functionality to your applications.

PostGIS is the foundation for other spatial extensions, such as the pgRouting library that provides geospatial routing functionality and the pgPointCloud library for LIDAR data. PostGIS offers many features rarely found in other competing spatial databases.

learn more

Contact Crunchy Data Today