Compose for PostgreSQL
PostgreSQL is an open source object-relational SQL database with both a rich heritage and a pioneering approach to data management. Its extensive SQL support is complemented with a range of powerful enhancements such as indexable JSON document types, publish/subscribe functions and a wide range of drivers for many languages.Try PostgreSQL on Compose free for 30-days
Every PostgreSQL deployment on Compose is built as a highly-available clustered configuration. Primary and secondard servers are kept in sync with monitoring enabling rapid switching between the two in case of failure. Access to the database is also routed through a dual HAproxy nodes at the front end which is also switched on database failover.
Automated backups are made every day and retained for 7 days along with 4 weekly backups and 3 monthly backups. The on-demand option of Compose backups allows up to 10 backups to be made a week. Backups are included at no extra cost and can also be created and retrieved using the Compose API.
As disk usage grows, the Compose platform will automatically allocate extra resources to maintain a 10:1 ratio between storage and memory so your database is always performant. Users can also manually control scaling via the Compose console for specialized workloads or events.
All Compose database deployments offer daily logging and real-time memory usage metrics from the Compose console. The PostgreSQL console includes Compose’s own SQL data browser and editor which lets authorised users access and modify the database from the web.
Incoming connections to PostgreSQL are managed through two SSL enabled HAproxy portals which manages PostgreSQL connections and termination. This portal can also use IP whitelisting to further restrict which clients can connect to the database.
Outgoing connections from the deployment include a Telegraf add-on for exporting PostgreSQL metrics to analysis services and a Syslog-NG add-on for real-time exporting of logs to Loggly, Papertrail and other services.
Two PostgreSQL database servers are configured in Primary/Secondary configuration. A high availability wrapper using etcd manages those nodes, testing availability and switching the roles of the servers in the event of a failiure. Front-end HAproxy modules talk to the current primary at all times.
Each PostgreSQL deployment has PostGIS, the PostgreSQL Geo data extension, adding extensive geo-mapping capabilities to the platform.
We also offer a selection PostgreSQL extensions available to extend the database capabilities, including enhanced indexing, text search and specialized data types.
We currently offer PostgreSQL 9.6.6. All new deployments default to the most recent, stable release. Upgrading to new versions can be done within your account with a few simple clicks.
Serious about security
Security at the database level is made up of many small features: SSL incoming connections with certificate confirmation ensures you are talking to the right server, IP whitelisting gives server side control of allowed clients, mandatory creation of users with passwords, and other best practices ensure the PostgreSQL database is ready for the Internet.
The Compose console for managing and viewing your databases operates with its own account scheme, with multiple sub-users and roles to enable you to control access to your database administration. The Compose account scheme also includes the option to use two factor authentication to ensure the right people are logging in.
All your databases, one platform
Compose makes it easy to deploy your favorite open source databases in minutes into your preferred cloud datacenter on fast SSDs. Everything you need to run a performant database is available through the Compose web console or Compose APIs.
Ready to get started?
Deploy PostgreSQL or any one of our production-ready, cloud hosted databases in minutes with just a few clicks.Try Compose Free for 30 Days