[*] PostgreSQL

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.

Icons/concept/App/App Script Created with Sketch.

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.

Icons/concept/Clock/Clock Available Created with Sketch.

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.

Icons/concept/padlock/padlock Closed Created with Sketch.

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.

Icons/concept/Page/Page Certificate Created with Sketch.

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

 

View prices for Managed Databases for PostgreSQL

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

Get started

Find out how to get started with the Managed Databases for PostgreSQL solution for your Public Cloud project

Order your Managed Databases service via API

Find out how to order your Managed Databases For PostgreSQL service via the API

Your questions answered

Read our frequently asked questions

Automated deployment

Our databases are integrated into the OVHcloud Terraform Provider.

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.

Pricing Public Cloud

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 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.