Skip to content

a9s PostgreSQL for PCF

This documentation describes the a9s PostgreSQL service. a9s PostgreSQL enables on-demand provisioning of VM-based, dedicated PostgreSQL servers and clusters. Developers can create instances of a PostgreSQL server or cluster using Apps Manager or the Cloud Foundry Command Line interface (cf CLI) and bind these instances to an application. Depending on your service plan, a service instance may be associated with a single, dedicated VM or a set of VMs consisting of multiple VMs containing a PostgreSQL replica set cluster.

a9s-postgresql-image

Overview

a9s PostgreSQL enables on-demand provisioning of VM-based, dedicated PostgreSQL servers and clusters. Developers can create instances of a PostgreSQL server or cluster using Apps Manager or the Cloud Foundry Command Line interface (cf CLI), and bind these instances to an application. Depending on the chosen service plan, a service instance may be associated with a single, dedicated virtual machine, or a set of VMs consisting of multiple virtual machines comprising a cluster of PostgreSQL servers.

Current Features

a9s PostgreSQL includes the following key features:

Feature Benefit
On­-Demand Service Instance Provisioning a9s PostgreSQL deploys PostgreSQL instances automatically. Developers can provision a single-VM PostgreSQL server or a multi-VM PostgreSQL Replica Set using a single command.
Service Instance Isolation Each PostgreSQL server runs on a dedicated VM to ensure bad neighborhood protection in order to be aligned with enterprise security requirements.

a9s PostgreSQL uses Cloud Foundry security groups to prevent network connections being established by unauthorized applications.
High Availability The Replication Manager for PostgreSQL ensures high availability.
The Consul-based internal DNS ensures that the connected application always connects to a working node.
The clustered data service plans are spread across several infrastructure availability zones, which enables very short failover times and a strong resilience of individual infrastructure hosts or even entire availability zones.
Smoke Tests a9s PostgreSQL contains a post-deploy smoke tests errand that runs a series of basic test against your installation to ensure that it is configured properly.
Service Instance Capacity Upgrade Cloud Foundry Service Plan updates allow upgrades to the RAM, CPU and storage capacity for your PostgreSQL instances.
Logging and Monitoring Each PostgreSQL service instance provides log messages and PostgreSQL-specific metrics to one or more syslog/graphite endpoints. You can configure the syslog/graphite endpoint to receive logging and monitoring information.
Deployment Updater This errand automatically updates the stemcell and all provisioned a9s PostgreSQL service instances to their lastest version.
Backup Manager The Backup Manager does regular backup of your instances and offers endpoints to backup instantly and restore backups.
Service Guard The Service Guard creates Cloud Foundry security groups for your service instance VMs.

When the IP address of a service instance changes, the guard updates the security group. The Service Guard also restarts the application instances bound to the affected service instance. The instances of one application are restarted one by one to avoid downtime.

Service Plans

Specification of a9s PostgreSQL service plans:

Attribute xs s10 m50 s10_ha m m150_ha
High Availability
(number of nodes)
no
(1)
no
(1)
no
(1)
yes
(3)
yes
(3)
yes
(3)
Number of vCPUs 2 2 2 2 2 2
RAM 0.5 GB 2 GB 4 GB 2 GB 4 GB 4 GB
Disk * 3 GB 10 GB 50 GB 10 GB 50 GB 150 GB
Connections 110 128 250 128 230 250
Logging no yes yes yes yes yes

For example, one backing service instance of size m is high available (consists of 3 nodes), has 2 vCPUs, 4 GB RAM, 50 GB disk, up to 230 connections and logging component.

* Total virtual disk size. You cannot use the whole disk for your data. For more information, refer Disk Alerts.


Last update: July 6, 2023

Except where otherwise noted, content on this site is licensed under the Development License Agreement.