What is IBM Cloud Databases for PostgreSQL?
IBM Cloud™ Databases for PostgreSQL is a PostgreSQL cloud database deployment comprised of a primary and secondary database server surrounded by a Patroni-based high availability configuration. Accessing the database is managed through a single Kubernetes Nodeport, behind which one or more HAProxy instances handle all the traffic. What is PostgreSQL? PostgreSQL is an object-relational SQL database, complemented by powerful enhancements like indexable JSON, publish/subscribe functions and drivers. For a detailed look at the database, see "PostgreSQL Explained."
IBM Cloud™ Databases for PostgreSQL is a PostgreSQL cloud database deployment comprised of a primary and secondary database server surrounded by a Patroni-based high availability configuration. Accessing the database is managed through a single Kubernetes Nodeport, behind which one or more HAProxy instances handle all the traffic.
What is PostgreSQL?
PostgreSQL is an object-relational SQL database, complemented by powerful enhancements like indexable JSON, publish/subscribe functions and drivers. For a detailed look at the database, see "PostgreSQL Explained."
Databases for PostgreSQL features
Fully managed PostgreSQL
PostgreSQL-as-a-service allows developers to focus on building applications rather than handling high availability, point-in-time backups, logging, monitoring, scaling, hardware setup and software patching. We provide out-of-the-box integration with IBM Identity and Access Management and IBM Activity Tracker to extend access control and auditing. Databases for PostgreSQL is also automatically integrated into IBM Log Analysis with LogDNA, allowing you to access, debug and troubleshoot your database logs directly from the LogDNA console.
Every IBM Cloud Databases for PostgreSQL deployment is built as a highly-available clustered configuration. All deployments leverage multiple availability zones, with three data centers in a given region, where available , for a 99.99% SLA. Access to the database is also routed through a single endpoint for easy driver configuration and seamless database failover handling.
All data is encrypted at rest and in motion. You can leverage integrations with IBM Key Protect to bring your own encryption key for disk storage. All data-in-transit uses TLS connections, and data-at-rest is encrypted by default, always. Database backups are also automatically encrypted at rest. The ability to set IP whitelists and integrations with IBM Identity and Access Management plus IBM Cloud Activity Tracker provides further access and audit control. The service is SOC 2 Type 1 certified and HIPAA ready.
Databases for PostgreSQL allows you to scale disk and RAM independently to best fit your application requirements. You can also add read replicas to your managed PostgreSQL deployments to offload traffic from your leader database. Read replicas provide increased availability of your data in disaster-recovery situations, allowing for greater business continuity and enhanced performance.
Go from whiteboard to production quickly with a management console, CLI and REST API. The management console supports features such as database settings and backup administration, while the CLI and API support database lifecycle events like provisioning, deletion, user creation and scaling. The service also provides cloud-native administration options, with an IBM Cloud CLI plug-in.
Databases for PostgreSQL is billed hourly and helps enable you to separately scale disk, RAM and vCPUs for each of your deployments. No need to migrate instance classes to accommodate growth.
Web and mobile apps
Build massively scalable enterprise applications that can handle millions of users.
Build sophisticated analytics applications or easily visualize and derive insights from your relational data.
Location and mapping
PostGIS is enabled out of the box, which allows for the handling of geographic objects in Databases for PostgreSQL. For example, applications can perform customer cohort geolocation to deliver highly targeted ad campaigns, offers, and sales.
Move your existing databases to the IBM Cloud while consolidating license costs, retiring servers and cleaning up database sprawl.
Run PostgreSQL hosted in a hyper-protect environment that enables you to retain your data in a fully encrypted client database, without the need for specialized skills.
A managed Kubernetes offering that delivers powerful tools, an intuitive user experience and built-in security for rapid delivery of applications.