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
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.
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
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