Yandex Managed Service for PostgreSQL

A service for managing clusters of the popular PostgreSQL object-relational DBMS in the Yandex.Cloud infrastructure.

Optimal configuration
You can deploy a ready-to-use cluster in just a few minutes. DB settings are optimized for the selected cluster size and you can change them if necessary.
Easy scaling
If the load on your cluster increases, you can add new servers or increase their capacity in a matter of minutes.
Restore to any point in time
With Point-In-Time Recovery, you can restore your database to any point in time during the last seven days.
Cluster performance diagnostics
New
With a user-friendly interface and intuitive visualization, you can monitor the status of your PostgreSQL cluster and DB load.
Data security
All DBMS connections are encrypted using the TLS protocol, and DB backups are GPG-encrypted. Data is secured in accordance with the requirements of local regulatory, GDPR, and ISO industry standards.
SQL queries in the management console
Visualize the data structure in your PostgreSQL cluster and send SQL queries to databases from the management console.

Implement your projects using Managed Service for PostgreSQL

Using 1C: Enterprise

Yandex.Cloud lets you create PostgreSQL clusters optimized for 1C: Enterprise.

Financial accounting

PostgreSQL is one of the few DBMS that are well suited for use in payment systems. Data replication and recovery, connection encryption, and access control technologies ensure high storage reliability.

Integration with location-based services

Support for various data types and indexing by PostgreSQL, as well as the PostGIS extension, provide features for working with geodata that are not available in other databases.

We'll take care of most of database maintenance

Processes
Managed Service for PostgreSQL
PostgreSQL self‑installation
Data access control
VM deployment
Network configurations
OS and software installation
DBMS updates
Backup and recovery
Data replication setup
Data storage and hardware security
Integration with Yandex.Cloud services
Monitoring tools

Independent control

Control on the Yandex.Cloud side

Getting started

Select the necessary computing capacity and create a ready-to-use PostgreSQL cluster.

Create cluster

Questions and answers

What are the characteristic features of PostgreSQL?

PostgreSQL is an open-source object-relational DBMS that is highly reliable, easy to scale, and often used in financial accounting or as a backend database for web services.

PostgreSQL is an open-source object-relational DBMS that is highly reliable, easy to scale, and often used in financial accounting or as a backend database for web services.

What PostgreSQL versions are available in Yandex.Cloud?

Managed Service for PostgreSQL supports PostgreSQL 10, 11, and 12, as well as PostgreSQL 10 for 1C.

Managed Service for PostgreSQL supports PostgreSQL 10, 11, and 12, as well as PostgreSQL 10 for 1C.

What part of database management and maintenance is Managed Service for PostgreSQL responsible for?

When creating clusters, Managed Service for PostgreSQL allocates resources, installs the DBMS, and creates databases.

For created and running databases, it automatically creates backups and applies fixes and updates to the DBMS.

The service also provides data replication between database hosts (both inside and between availability zones) and automatically switches the load over to a backup replica in the event of a failure.

When creating clusters, Managed Service for PostgreSQL allocates resources, installs the DBMS, and creates databases.

For created and running databases, it automatically creates backups and applies fixes and updates to the DBMS.

The service also provides data replication between database hosts (both inside and between availability zones) and automatically switches the load over to a backup replica in the event of a failure.

Can I work with the database from the management console?

Yes. The service lets you visualize the data structure in your PostgreSQL cluster and send SQL queries to databases from the Yandex.Cloud management console.

Yes. The service lets you visualize the data structure in your PostgreSQL cluster and send SQL queries to databases from the Yandex.Cloud management console.

What can I use the PostgreSQL performance diagnostics tool for?

Our Performance Diagnostics tool helps you answer the following major questions:

  • How many resources did each of the query types consume at a specific point in time?
  • Why did queries made at a particular time take longer to process?
  • How many queries were executed in the DB over a certain period of time, what were these queries, and how long did they take to complete?
  • Comparison of two intervals by the number of queries and their execution time.

The Performance Diagnostics tool stores data for the last 2 weeks.

Our Performance Diagnostics tool helps you answer the following major questions:

  • How many resources did each of the query types consume at a specific point in time?
  • Why did queries made at a particular time take longer to process?
  • How many queries were executed in the DB over a certain period of time, what were these queries, and how long did they take to complete?
  • Comparison of two intervals by the number of queries and their execution time.

The Performance Diagnostics tool stores data for the last 2 weeks.

Get started with Managed Service for PostgreSQL