Managed Databases for PostgreSQL
Accelerate your business by deploying a managed PostgreSQL cluster. 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 complies with strict standards. We ensure that you retain control over your data.
Standardized APIs
Use Kubernetes for container orchestration with tools like Kubectl to manage your cloud resources, allowing you to program your cloud resources using the tools that best suit your needs.
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 specially optimized for transactional data. Compliant with the ACID properties, it allows fast reading and writing of individual lines, better-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 analyze 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 commitment to service excellence in the Business and Enterprise plans, which translates to a consistently reliable database availability.
TLS encryption
PostgreSQL uses the Transport Layer Security/Secure Sockets Layer (TLS/SSL) protocol to encrypt data at rest or in transit, to better ensure the confidentiality of your data.
Replication nodes
By replicating your data via these nodes, you can create redundancies 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 2Gbps bandwidth.
A PostgreSQL cloud service adapted to business requirements
99.95% availability
With a cluster of 3 nodes available by default, the Enterprise plan gives you a service commitment of 99.95%. You also get additional commitments for your most critical deployments.
Dashboard administration
The Managed Databases catalog 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 visualization
Analyze or perform diagnostics on your database to optimize 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).
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 customization 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 license 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?
Organizations choose PostgreSQL to maintain a high level of integrity and customization 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 customized 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 license?
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.