High Availability

High availability is a necessary capability for enterprise production database workloads. Crunchy Data has the technology and expertise necessary to design, deploy and support open source PostgreSQL solution for enterprise high availability requirements on a variety of platforms and built to suite unique enterprise infrastructure requirements.

Crunchy Data provides a variety of trusted high availability reference architectures for bare-metal, cloud and hybrid deployment models. Crunchy Data High Availability solutions leverage tried and tested open source technology that is delivered and supported pursuant to Crunchy Secure Enterprise Support.

Contact us to learn more about Crunchy Data High Availability solutions using Pacemaker and Corosync in for bare metal, virtualized and Container environments.

Learn more about Crunchy Data High Availability solutions leveraging OpenShift and Kubernetes container platform environments to ensure the most protection for your data.

Learn more about Crunchy Data High Availability solutions for Pivotal Cloud Foundry Tile.

High Performance Backup

Backup and Disaster Recovery are critical parts of any production infrastructure. Crunchy Data has the technology and expertise to design, deploy and support high performance backup and restore solutions for PostgreSQL. Crunchy Data provides enterprise packages and support for pgBackRest, the leading high performance PostgreSQL Backup and Restore system that can seamlessly scale up to the largest databases and workloads. pgBackRest includes support for versions down to 8.3, since older versions of PostgreSQL are still regularly utilized. Capabilities include:

Full, Incremental, & Differential Backups. Full, differential, and incremental backups are supported. pgBackRest is not susceptible to the time resolution issues of rsync, making differential and incremental backups completely safe.

Parallel Backup & Restore. Compression is usually the bottleneck during backup operations but, even with now ubiquitous multi-core servers, most database backup solutions are still single-process. pgBackRest solves the compression bottleneck with parallel processing. Utilizing multiple cores for compression makes it possible to achieve 1TB/hr raw throughput even on a 1Gb/s link. More cores and a larger pipe lead to even higher throughput.

Backup Rotation & Archive Expiration. Retention polices can be set for full and differential backups to create coverage for any timeframe. WAL archive can be maintained for all backups or strictly for the most recent backups. In the latter case WAL required to make older backups consistent will be maintained in the archive.

Monitoring

Crunchy Data provides the technology and expertise necessary to design, deploy and support PostgreSQL monitoring and alerting solutions for enterprise PostgreSQL database environments - whether on bare metal or in the cloud.

In connection with Crunchy Secure Enterprise PostgreSQL Support, Crunchy Data PostgreSQL engineers collaborate with enterprise PostgreSQL users to identify monitoring and alerts configuration most suitable to the enterprises requirements and PostgreSQL environment. Once appropriate statistics are identified for monitoring and alerting, Crunchy PostgreSQL engineers assist the enterprise in configuring appropriate open source software stacks to integrate with the Enterprises existing IT monitoring and alerting solutions in order to efficiently provide the Enterprise with the best possible information on occurrences within your infrastructure.

Crunchy Data provides trusted open source packages of leading monitoring solutions as well as 24x7 enterprise support.

Learn more about Crunchy Data monitoring solutions using open source software such as Icinga2, Prometheus and Grafana.

Geospatial Data Management

PostgreSQL and PostGIS provide enterprises with a leading open source solution that implements the Open Geospatial Consortium (OGC) standard in order to support complex geospatial data environments. Enterprises can easily add geospatial data to your applications with PostGIS, the leading open source geospatial extension to PostgreSQL. With Crunchy Certified PostgreSQL, PostGIS comes pre-installed and ready to use as the GIS database for a variety of leading proprietary and open source GIS solutions.

Moreover, with our enterprise PostgreSQL support, we create custom packages to fit your specific needs by leveraging open source software such as the OpenGeo Suite or alternative proprietary solutions such as Esri. Full enterprise support is offered, allowing enterprises to run secure, high-performance and highly reliable environments with trusted open source PostgreSQL in even the most sophisticated geospatial environments.

Database-as-a-Service

Many enterprises are leveraging various combinations of public / private cloud and platform technologies to deploy database as a service capabilities. Crunchy Data has developed technologies and solutions that provide internal operations teams with the ability to enable developers to efficiently and securely provision PostgreSQL. Crunchy Data provides both on premise and cloud agnostic solutions that address enterprise production requirements such as:

  • Backup, Restore and Disaster Recovery
  • High Availability
  • Automated Failover
  • Integrated Administration Dashboard
  • Database Monitoring

For enterprises deploying to a public or private cloud, Crunchy Data provides Cloud Native solutions for leading platform technologies such as Kubernetes and Cloud Foundry.

Compliance

Crunchy Data was founded to bring open source PostgreSQL to enterprise - including highly regulated - use cases including Government, Financial Services and Healthcare environments. In order to ensure that Crunchy Certified PostgreSQL provides enterprises with the confidence that open source PostgreSQL can be deployed in such environments, Crunchy Data has received Common Criteria Evaluation Assurance Level (EAL) 2+ certification, an international standard for computer security certification - representing the first commercially available open source database management system to receive such certification.

In addition, Crunchy Data collaborated with the Defense Information Systems Agency to author a Security Technical Implementation Guide for PostgreSQL (STIG) - with requirements based on NIST 800-53 - representing the first open source database STIG published by the DISA.

PostgreSQL STIG provides guidance on the configuration of PostgreSQL to address requirements associated with:

  • Auditing
  • Logging
  • Data Encryption at Rest
  • Data Encryption Over the Wire
  • Access Controls
  • Administration
  • Authentication
  • Protecting against SQL Injection

Crunchy Certified PostgreSQL eases STIG compliance as a securely hardened distribution of PostgreSQL, packaged along with security enhancing audit logging extensions. Security enhancements and support ensure regulated enterprises and enterprises with advanced security requirements can confidently deploy open source PostgreSQL.

For those regulated enterprises in the healthcare industry, Crunchy Data provides HIPAA compliant enterprise PostgreSQL support. Crunchy Data support is designed from the ground up to ensure the integrity of customer data - including protected health information (PHI) - and implements appropriate administrative and technical safeguards consistent with regulatory requirements. We are able to meet the requirements of even the most security-sensitive enterprises, making the privacy and security of your data our highest priority.

CRUNCHY CERTIFIED POSTGRESQL

Crunchy Certified PostgreSQL is a 100% open source distribution of PostgreSQL - a powerful, open source, object-relational database system, packaged and commercially supported by Crunchy Data. Our distribution includes the latest version of the open source PostgreSQL database as well as additional open source extensions that allow organizations to deploy and manage PostgreSQL in today’s complex IT infrastructure environments.

ENTERPRISE POSTGRESQL SUPPORT

For Enterprise customers that have deployed PostgreSQL in support of their data management requirements, we offer a combination of on demand, 24/7 Crunchy PostgreSQL Expertise, access to the knowledge base and capability of the PostgreSQL Global Development Community, and finally, convenient access to security patches, software updates, efficient troubleshooting and bug fixes for your PostgreSQL deployment. True PostgreSQL Support.

Contact Us for More Information Crunchy Data Announces PostgreSQL STIG