Managed Databases for PostgreSQL
Accelerate your business by deploying a managed PostgreSQL cluster in just a few clicks. Get an open-source relational database engine that can handle heavy workloads. We will manage the service — including configuration, maintenance, backup, high availability and updates — and you can focus on developing your application features.
Focus on your applications
With our PostgreSQL managed service, you can develop your features more quickly. This service will save you time, as we take care of the database administration and maintenance for you.
Control your budget
We apply transparent pricing to our solutions. You only pay for the use of your PostgreSQL database, which is billed by the hour - giving you a better view of your budget.
Control your data
As part of our trusted cloud, this solution is compliant with the very strictest standards. We ensure that you retain control over your data.
ISO/IEC 27001, 27701 and health data hosting compliance
Our cloud infrastructures and services are ISO/IEC 27001, 27017, 27018 and 27701 certified. These certifications ensure the presence of an information security management system (ISMS) for managing risks, vulnerabilities and implementing business continuity, as well as a privacy information management system (PIMS). Thanks to our health data hosting compliance, you can also host healthcare data securely.
Compare our Managed Databases for PostgreSQL packs
Essential | Business | Enterprise | |
Number of nodes | 1 | 2 nodes included | 3 nodes included |
RAM per node | 7GB to 60GB | 7GB to 60GB | 7GB to 60GB |
Total useful storage | 7GB to 60GB | 80 GB to 2.56 TB | 80 GB to 2.56 TB |
Service Level Agreement (SLA) | No | 99.9% | 99.95% |
Upgrade to a higher solution in 1 click | Yes | Yes | Yes |
Data encryption at rest and in transit (SSL) | Yes | Yes | Yes |
Extensions (PostGIS, PLV8, etc.) | Yes | Yes | Yes |
Performance graph | Yes | Yes | Yes |
Real-time backup to remote location | Yes | Yes | Yes |
Backup retention period | 2 days | 14 days | 30 days |
Point in Time Recovery | Yes | Yes | Yes |
Database forking | Yes | Yes | Yes |
Connection pooling | Yes | Yes | Yes |
Terraform Provider support (more information) | Yes | Yes | Yes |
Private network connectivity (vRack) | Yes | Yes | Yes |
High availability | No | Yes | Yes |
Read-only access to replication nodes | Yes | Yes |
What can I use PostgreSQL for?
Transactional applications
The PostgreSQL database management system (DBMS) is especially optimised for transactional data. Compliant with the ACID properties, it allows fast reading and writing of individual lines, ensuring data integrity when recording transactions. It is commonly used on merchant websites and marketplace software.
Migrating historical databases
Managed Databases for PostgreSQL is a highly available service that includes backups. It also offers several extensions for enterprise deployments. With its rich functionality and resilience, PostgreSQL is an ideal solution for migrating to an open-source database in the cloud.
Geographic information systems (GIS) and applications
With the PostGIS and TimescaleDB extensions, our service supports spatial data management. Storing graphic objects in the database allows your GIS applications to process spatial objects. This makes it easier to adapt them to the specific challenges of your sector, from IoT to transport to industry.
Documentation and guides
Find out how to get started with the Managed Databases for PostgreSQL solution for your Public Cloud project
Find out how to order your Managed Databases For PostgreSQL service via the API
Features
Main features of Managed Databases for PostgreSQL
More than 40 extensions
Employ a number of ready-to-use extensions. They can be useful for enriching the type of data supported, creating indexing methods, or adding new features to your database.
Database forking
Make a copy of your PostgreSQL code base without affecting your database during the production phase. This means you can develop, test, or analyse in a configuration similar to your production environment.
Connection pooling
With this feature, you can maintain optimal performance for your database. Use it to adapt your resources to handle traffic spikes of up to 1,000 connections per pool.
Backup retention
We offer several service plans that meet your test, development and production needs. They each offer different backup retention periods for each of these uses.
Read-only accessibility
By performing your SQL queries with this functionality on your replication nodes, you transfer part of the workload to the replicas. This makes it easier to scale your database reads.
Managed Databases for PostgreSQL offers security and availability
Backups included
Each of our plans includes a backup to preserve the integrity of your data. The backup is performed in real time to a remote location by default. Depending on the plan you have chosen, you can restore your data from an earlier point in time.
High availability
With our Business and Enterprise solutions, several nodes are included in your PostgreSQL cluster by default. Thanks to our contractual service commitments for the Business and Enterprise plans, your database availability is guaranteed.
TLS encryption
PostgreSQL uses the Transport Layer Security/Secure Sockets Layer (TLS/SSL) protocol to encrypt data at rest or in transit, to ensure the confidentiality of your data.
Replication nodes
By replicating your data via these nodes, you ensure redundancy and increase data availability.
Private network connectivity (vRack)
With our Business and Enterprise solutions, you can restrict access to your database service thanks to our private network. You also get up to 2Gbit/s bandwidth.
A PostgreSQL cloud service adapted to business requirements
Get the highest availability
With a cluster of 3 nodes available by default, the Enterprise plan gives you a guaranteed service commitment of 99.95%. You also get an additional guarantee for your most critical deployments.
Dashboard administration
The Managed Databases catalogue offers a dashboard integrated into your Control Panel. You can use it to manage your users and backups, as well as for tracking your query statistics, logs and metrics.
Real-time log visualisation
Analyse or perform diagnostics on your database to optimise the running of your application. You can view up to the last 100 lines of real-time logs.
Automate via Terraform (coming soon)
With Terraform API and tools, you can save time on your deployments by provisioning your SQL databases and their configurations.
Managed Databases for PostgreSQL pricing
You receive a bill at the end of each month, which is calculated based on your hourly database usage. The price depends on the plan you have chosen (Essential, Business or Enterprise).
Other products
FAQ
What is PostgreSQL?
It is an object-orientated, open-source relational database management system (RDBMS). It restructures data by storing and manipulating it. Its main advantages are its high level of integrity and its customisation options. It works on all operating systems, making it a flexible solution.
What is Managed Databases for PostgreSQL?
Managed Databases for PostgreSQL is a Database-as-a-Service (DBaaS). It is provided as a turnkey service, and is distributed between several of our Public Cloud instances. As we take care of its management and administration, your job is made easier. We manage its configuration, maintenance, backup, security and scalability. In short, it is a cloud database service that saves you time.
Can I install PostgreSQL on Public Cloud instances myself?
This is possible once you have downloaded and accepted PostgreSQL’s licence agreement. However, you will also need to perform all the database management and administration yourself. You will therefore not benefit from the features we provide in our turnkey service.
Why is PostgreSQL a popular database?
Organisations choose PostgreSQL to maintain a high level of integrity and customisation for their data. Among other features, it offers excellent reliability for the integrity of your data, robust features, and allows ACID transactions to be carried out via customised procedures.
Is PostgreSQL more efficient than MySQL?
These two database engines offer different advantages. PostgreSQL is particularly useful for processing accounting or transactional data, thanks to its reliability and scalability. MySQL is better known for its scalability and performance. Our solutions offer both of these database management systems, along with Redis and Kafka.
What is the difference between the Essential, Business and Enterprise plans?
These service plans each represent a different PostgreSQL pack on the Public Cloud. Each plan includes various features that suit different applications, including the cluster size, the number of nodes in the cluster, the network, scalability, or even high availability.
Is the data stored in Managed Databases for PostgreSQL shared with third parties?
No. Your service has one or more Public Cloud instances running it. They are equipped with an individual dedicated storage space, so you control your own data.
Can I migrate to nodes with a higher capacity?
Yes, this is possible. If your RAM or storage space requirements increase, you can choose nodes with a higher capacity. However, please note that you cannot return to a lower-capacity node.
Does Managed Databases for PostgreSQL have a backup feature?
Yes. We provide automated backups for each solution. However, the default retention policies differ depending on the chosen plan, so study all our plans before making your choice.
Why do I have to pay to use Managed Databases for PostgreSQL when the service is based on an open-source licence?
We perform all database management and administration tasks for you, so you don’t have to worry about installation, maintenance, security, backups or scalability. It is this managed service that we charge for, so you can hand over these additional tasks.
Can I connect Managed Databases for PostgreSQL to my Bare Metal server?
Yes. You can connect your database to your server via a public or private network. However, you will need to do this yourself, which means that you will also need to manage and administer your database on your own.