[Yandex Cloud documentation](../index.md) > Yandex Managed Service for PostgreSQL > Managed Service for PostgreSQL # Yandex Managed Service for PostgreSQL Managed Service for PostgreSQL helps you deploy and maintain PostgreSQL server clusters in the Yandex Cloud infrastructure. Managed Service for PostgreSQL supports PostgreSQL versions 14, 15, 16, 17, and 18, and PostgreSQL versions 14, 15, 16, 17, and 18 for 1C. The Yandex Cloud infrastructure is protected pursuant to the following standards: This service is subject to a service level agreement. The service level is set out in the document titled Yandex Managed Databases Service Level. # Yandex Managed Service for PostgreSQL - [Getting started](quickstart.md) ## Step-by-step guides - [All guides](operations/index.md) ### Clusters - [Getting information on existing clusters](operations/cluster-list.md) - [Creating a cluster](operations/cluster-create.md) - [Updating cluster settings](operations/update.md) - [Stopping and starting a cluster](operations/cluster-stop.md) - [Managing PostgreSQL hosts](operations/hosts.md) - [Migrating hosts to a different availability zone](operations/host-migration.md) - [Managing replication slots](operations/replication-slots.md) - [Managing backups](operations/cluster-backups.md) - [Managing backup policies](operations/backup-retention-policies.md) - [Managing disk space](operations/storage-space.md) - [Managing cluster access](operations/cluster-access.md) - [Maintenance](operations/cluster-maintenance.md) - [Updating the PostgreSQL version](operations/cluster-version-update.md) - [Deleting a cluster](operations/cluster-delete.md) ### Connection - [Pre-configuration](operations/connect/index.md) - [FQDNs of hosts](operations/connect/fqdn.md) - [Connecting from applications](operations/connect/clients.md) - [Code examples](operations/connect/code-examples.md) ### Databases - [SQL queries in Yandex WebSQL](operations/web-sql-query.md) - [Copying and populating a table](operations/copy-write-data.md) - [Managing databases](operations/databases.md) ### PostgreSQL users - [Managing database users](operations/cluster-users.md) - [Assigning privileges and roles](operations/grant.md) ### PostgreSQL extensions and dictionaries - [Managing extensions](operations/extensions/cluster-extensions.md) - [pg_cron](operations/extensions/pg_cron.md) - [pg_repack](operations/extensions/pg_repack.md) - [pgaudit](operations/extensions/pgaudit.md) - [pgcrypto](operations/extensions/pgcrypto.md) - [postgresql_anonymizer](operations/extensions/pg_anon.md) - [Hunspell dictionaries for full-text search](operations/extensions/hunspell.md) ### Logs and monitoring - [Viewing cluster logs](operations/cluster-logs.md) - [Performance diagnostics](operations/performance-diagnostics.md) - [Cluster and host status monitoring](operations/monitoring.md) - [Connecting to DataLens](operations/datalens-connect.md) ## Tutorials - [All tutorials](tutorials/index.md) - [Creating a PostgreSQL cluster for 1C](tutorials/1c-postgresql.md) - [Creating a cluster of 1C:Enterprise Linux servers with a Managed Service for PostgreSQL cluster](tutorials/1c-postgresql-linux.md) - [Exporting a database to Yandex Data Processing](tutorials/sqoop.md) - [Troubleshooting cluster performance](tutorials/performance-problems.md) - [Performance analysis and optimization](tutorials/profiling.md) - [Setting up a connection from a container in Serverless Containers](tutorials/container-connect.md) - [Delivering data to Yandex Managed Service for Apache Kafka® using Yandex Data Transfer](tutorials/cdc-data-transfer.md) - [Delivering data to Yandex Managed Service for YDB using Yandex Data Transfer](tutorials/data-transfer-ydb.md) - [Delivering data to Yandex Managed Service for Apache Kafka® using Debezium](tutorials/cdc-debezium.md) - [PostgreSQL change data capture and delivery to YDS](tutorials/mpg-to-yds.md) - [Delivering data from Yandex Managed Service for Apache Kafka® using Yandex Data Transfer](tutorials/mkf-to-mpg.md) - [Transferring data from Yandex Object Storage using Yandex Data Transfer](tutorials/object-storage-to-postgresql.md) - [Configuring a fault-tolerant architecture in Yandex Cloud](tutorials/fault-tolerance.md) ### Creating a Joomla website with a PostgreSQL database - [Overview](tutorials/joomla-postgresql/index.md) - [Management console](tutorials/joomla-postgresql/console.md) - [Terraform](tutorials/joomla-postgresql/terraform.md) - [Monitoring the status of geographically distributed devices](tutorials/datalens.md) - [Writing load balancer logs to PostgreSQL](tutorials/logging.md) - [Creating an MLFlow server for logging experiments and artifacts](tutorials/mlflow-datasphere.md) - [Working with data using Query](tutorials/yq-postgre.md) - [Federated data queries using Query](tutorials/yq-federative-queries.md) - [Fixing string sorting issues after upgrading glibc](tutorials/glibc-collation-issues.md) - [Writing data from a device to a database](tutorials/data-recording.md) - [Connecting to Managed Service for PostgreSQL from a PySpark job in Yandex Managed Service for Apache Spark™ using a Yandex Lockbox secret](tutorials/job-pyspark-secret-access.md) - [Configuring permissions for access to a secret created by Connection Manager for a Managed Service for PostgreSQL user](tutorials/conn-man-secret-access.md) ### Replication and migration - [Logical replication in PostgreSQL](tutorials/replication-overview.md) - [Migrating a database to Managed Service for PostgreSQL](tutorials/data-migration.md) - [Migrating a database from Managed Service for PostgreSQL](tutorials/outbound-replication.md) - [Migrating a Managed Service for PostgreSQL cluster to another version](tutorials/postgresql-versions.md) - [Creating an Amazon RDS logical replica for PostgreSQL in Managed Service for PostgreSQL](tutorials/logical-replica-from-rds.md) - [Migrating a database from Yandex Managed Service for PostgreSQL to Yandex Object Storage](tutorials/mpg-to-objstorage.md) - [Migrating data from Yandex Managed Service for MySQL® to Managed Service for PostgreSQL using Yandex Data Transfer](tutorials/mmy-to-mpg.md) - [Migrating data from Managed Service for PostgreSQL to Yandex Managed Service for MySQL® using Yandex Data Transfer](tutorials/mpg-to-mmy.md) - [Migrating data from AWS RDS for PostgreSQL to Managed Service for PostgreSQL using Yandex Data Transfer](tutorials/rds-to-mpg.md) - [Migrating a database from Greenplum® to PostgreSQL](tutorials/greenplum-to-postgresql.md) - [Migrating data from Managed Service for PostgreSQL to Managed Service for OpenSearch using Yandex Data Transfer](tutorials/postgresql-to-opensearch.md) - [Asynchronously replicating data from PostgreSQL to ClickHouse®](tutorials/rdbms-to-clickhouse.md) ## Concepts - [Resource relationships](concepts/index.md) ### Host classes - [Active host classes](concepts/instance-types.md) #### Archive - [Before June 1, 2020](concepts/instance-types-archive/instance-types-01062020.md) - [Before June 20, 2023](concepts/instance-types-archive/instance-types-20062023.md) - [Using deprecated host classes](concepts/using-deprecated-instances.md) - [Planning a cluster topology](concepts/planning-cluster-topology.md) - [High availability clusters](concepts/high-availability.md) - [Networking in Managed Service for PostgreSQL](concepts/network.md) - [Quotas and limits](concepts/limits.md) - [Storage in Managed Service for PostgreSQL](concepts/storage.md) - [Backups](concepts/backup.md) - [Assigning roles](concepts/roles.md) - [Managing connections](concepts/pooling.md) - [Load balancer for hosts](concepts/load-balancer.md) - [Replication](concepts/replication.md) - [Maintenance](concepts/maintenance.md) - [Supported clients](concepts/supported-clients.md) - [PostgreSQL settings](concepts/settings-list.md) - [Indexes](concepts/indexes.md) - [SQL command limits](concepts/sql-limits.md) - [Upgrading the PostgreSQL major version](concepts/upgrade.md) - [PostgreSQL versioning policy](concepts/update-policy.md) - [Access management](security/index.md) - [Pricing policy](pricing.md) ## CLI reference - [Overview](cli-ref/index.md) ### backup - [Overview](cli-ref/backup/index.md) - [delete](cli-ref/backup/delete.md) - [get](cli-ref/backup/get.md) - [list](cli-ref/backup/list.md) ### backup-retention-policy - [Overview](cli-ref/backup-retention-policy/index.md) - [create](cli-ref/backup-retention-policy/create.md) - [delete](cli-ref/backup-retention-policy/delete.md) - [list](cli-ref/backup-retention-policy/list.md) ### cluster - [Overview](cli-ref/cluster/index.md) - [add-access-binding](cli-ref/cluster/add-access-binding.md) - [add-labels](cli-ref/cluster/add-labels.md) - [backup](cli-ref/cluster/backup.md) - [create](cli-ref/cluster/create.md) - [delete](cli-ref/cluster/delete.md) - [get](cli-ref/cluster/get.md) - [list](cli-ref/cluster/list.md) - [list-access-bindings](cli-ref/cluster/list-access-bindings.md) - [list-backups](cli-ref/cluster/list-backups.md) - [list-logs](cli-ref/cluster/list-logs.md) - [list-operations](cli-ref/cluster/list-operations.md) - [move](cli-ref/cluster/move.md) - [remove-access-binding](cli-ref/cluster/remove-access-binding.md) - [remove-labels](cli-ref/cluster/remove-labels.md) - [reschedule-maintenance](cli-ref/cluster/reschedule-maintenance.md) - [restore](cli-ref/cluster/restore.md) - [set-access-bindings](cli-ref/cluster/set-access-bindings.md) - [start](cli-ref/cluster/start.md) - [start-failover](cli-ref/cluster/start-failover.md) - [stop](cli-ref/cluster/stop.md) - [stream-logs](cli-ref/cluster/stream-logs.md) - [update](cli-ref/cluster/update.md) - [update-config](cli-ref/cluster/update-config.md) - [connect](cli-ref/connect.md) ### database - [Overview](cli-ref/database/index.md) - [create](cli-ref/database/create.md) - [delete](cli-ref/database/delete.md) - [get](cli-ref/database/get.md) - [list](cli-ref/database/list.md) - [update](cli-ref/database/update.md) ### hosts - [Overview](cli-ref/hosts/index.md) - [add](cli-ref/hosts/add.md) - [delete](cli-ref/hosts/delete.md) - [list](cli-ref/hosts/list.md) - [update](cli-ref/hosts/update.md) - [update-config](cli-ref/hosts/update-config.md) ### repack - [Overview](cli-ref/repack/index.md) - [launch](cli-ref/repack/launch.md) - [list-running](cli-ref/repack/list-running.md) - [terminate](cli-ref/repack/terminate.md) ### resource-preset - [Overview](cli-ref/resource-preset/index.md) - [get](cli-ref/resource-preset/get.md) - [list](cli-ref/resource-preset/list.md) ### user - [Overview](cli-ref/user/index.md) - [create](cli-ref/user/create.md) - [delete](cli-ref/user/delete.md) - [get](cli-ref/user/get.md) - [grant-permission](cli-ref/user/grant-permission.md) - [list](cli-ref/user/list.md) - [revoke-permission](cli-ref/user/revoke-permission.md) - [update](cli-ref/user/update.md) ### v0 - [Overview](cli-ref/v0/index.md) #### backup - [Overview](cli-ref/v0/backup/index.md) - [delete](cli-ref/v0/backup/delete.md) - [get](cli-ref/v0/backup/get.md) - [list](cli-ref/v0/backup/list.md) #### backup-retention-policy - [Overview](cli-ref/v0/backup-retention-policy/index.md) - [create](cli-ref/v0/backup-retention-policy/create.md) - [delete](cli-ref/v0/backup-retention-policy/delete.md) - [list](cli-ref/v0/backup-retention-policy/list.md) #### cluster - [Overview](cli-ref/v0/cluster/index.md) - [add-access-binding](cli-ref/v0/cluster/add-access-binding.md) - [add-labels](cli-ref/v0/cluster/add-labels.md) - [backup](cli-ref/v0/cluster/backup.md) - [create](cli-ref/v0/cluster/create.md) - [delete](cli-ref/v0/cluster/delete.md) - [get](cli-ref/v0/cluster/get.md) - [list](cli-ref/v0/cluster/list.md) - [list-access-bindings](cli-ref/v0/cluster/list-access-bindings.md) - [list-backups](cli-ref/v0/cluster/list-backups.md) - [list-logs](cli-ref/v0/cluster/list-logs.md) - [list-operations](cli-ref/v0/cluster/list-operations.md) - [move](cli-ref/v0/cluster/move.md) - [remove-access-binding](cli-ref/v0/cluster/remove-access-binding.md) - [remove-labels](cli-ref/v0/cluster/remove-labels.md) - [reschedule-maintenance](cli-ref/v0/cluster/reschedule-maintenance.md) - [restore](cli-ref/v0/cluster/restore.md) - [set-access-bindings](cli-ref/v0/cluster/set-access-bindings.md) - [start](cli-ref/v0/cluster/start.md) - [start-failover](cli-ref/v0/cluster/start-failover.md) - [stop](cli-ref/v0/cluster/stop.md) - [stream-logs](cli-ref/v0/cluster/stream-logs.md) - [update](cli-ref/v0/cluster/update.md) - [update-config](cli-ref/v0/cluster/update-config.md) - [connect](cli-ref/v0/connect.md) #### database - [Overview](cli-ref/v0/database/index.md) - [create](cli-ref/v0/database/create.md) - [delete](cli-ref/v0/database/delete.md) - [get](cli-ref/v0/database/get.md) - [list](cli-ref/v0/database/list.md) - [update](cli-ref/v0/database/update.md) #### hosts - [Overview](cli-ref/v0/hosts/index.md) - [add](cli-ref/v0/hosts/add.md) - [delete](cli-ref/v0/hosts/delete.md) - [list](cli-ref/v0/hosts/list.md) - [update](cli-ref/v0/hosts/update.md) - [update-config](cli-ref/v0/hosts/update-config.md) #### repack - [Overview](cli-ref/v0/repack/index.md) - [launch](cli-ref/v0/repack/launch.md) - [list-running](cli-ref/v0/repack/list-running.md) - [terminate](cli-ref/v0/repack/terminate.md) #### resource-preset - [Overview](cli-ref/v0/resource-preset/index.md) - [get](cli-ref/v0/resource-preset/get.md) - [list](cli-ref/v0/resource-preset/list.md) #### user - [Overview](cli-ref/v0/user/index.md) - [create](cli-ref/v0/user/create.md) - [delete](cli-ref/v0/user/delete.md) - [get](cli-ref/v0/user/get.md) - [grant-permission](cli-ref/v0/user/grant-permission.md) - [list](cli-ref/v0/user/list.md) - [revoke-permission](cli-ref/v0/user/revoke-permission.md) - [update](cli-ref/v0/user/update.md) - [Terraform reference](tf-ref.md) ## API reference - [API authentication](api-ref/authentication.md) ### gRPC - [Overview](api-ref/grpc/index.md) #### BackupRetentionPolicy - [Overview](api-ref/grpc/BackupRetentionPolicy/index.md) - [Get](api-ref/grpc/BackupRetentionPolicy/get.md) - [List](api-ref/grpc/BackupRetentionPolicy/list.md) - [Create](api-ref/grpc/BackupRetentionPolicy/create.md) - [Delete](api-ref/grpc/BackupRetentionPolicy/delete.md) #### Backup - [Overview](api-ref/grpc/Backup/index.md) - [Get](api-ref/grpc/Backup/get.md) - [List](api-ref/grpc/Backup/list.md) - [Delete](api-ref/grpc/Backup/delete.md) #### Cluster - [Overview](api-ref/grpc/Cluster/index.md) - [Get](api-ref/grpc/Cluster/get.md) - [List](api-ref/grpc/Cluster/list.md) - [Create](api-ref/grpc/Cluster/create.md) - [Update](api-ref/grpc/Cluster/update.md) - [Delete](api-ref/grpc/Cluster/delete.md) - [Start](api-ref/grpc/Cluster/start.md) - [Stop](api-ref/grpc/Cluster/stop.md) - [Move](api-ref/grpc/Cluster/move.md) - [Backup](api-ref/grpc/Cluster/backup.md) - [Restore](api-ref/grpc/Cluster/restore.md) - [RescheduleMaintenance](api-ref/grpc/Cluster/rescheduleMaintenance.md) - [StartFailover](api-ref/grpc/Cluster/startFailover.md) - [ListLogs](api-ref/grpc/Cluster/listLogs.md) - [StreamLogs](api-ref/grpc/Cluster/streamLogs.md) - [ListOperations](api-ref/grpc/Cluster/listOperations.md) - [ListBackups](api-ref/grpc/Cluster/listBackups.md) - [ListHosts](api-ref/grpc/Cluster/listHosts.md) - [AddHosts](api-ref/grpc/Cluster/addHosts.md) - [DeleteHosts](api-ref/grpc/Cluster/deleteHosts.md) - [UpdateHosts](api-ref/grpc/Cluster/updateHosts.md) - [ListAccessBindings](api-ref/grpc/Cluster/listAccessBindings.md) - [SetAccessBindings](api-ref/grpc/Cluster/setAccessBindings.md) - [UpdateAccessBindings](api-ref/grpc/Cluster/updateAccessBindings.md) #### Database - [Overview](api-ref/grpc/Database/index.md) - [Get](api-ref/grpc/Database/get.md) - [List](api-ref/grpc/Database/list.md) - [Create](api-ref/grpc/Database/create.md) - [Update](api-ref/grpc/Database/update.md) - [Delete](api-ref/grpc/Database/delete.md) #### ManagedRepack - [Overview](api-ref/grpc/ManagedRepack/index.md) - [ListRunningRepacks](api-ref/grpc/ManagedRepack/listRunningRepacks.md) - [LaunchRepack](api-ref/grpc/ManagedRepack/launchRepack.md) - [TerminateRepack](api-ref/grpc/ManagedRepack/terminateRepack.md) #### Operation - [Overview](api-ref/grpc/Operation/index.md) - [Get](api-ref/grpc/Operation/get.md) - [Cancel](api-ref/grpc/Operation/cancel.md) #### PerformanceDiagnostics - [Overview](api-ref/grpc/PerformanceDiagnostics/index.md) - [ListRawSessionStates](api-ref/grpc/PerformanceDiagnostics/listRawSessionStates.md) - [ListRawStatements](api-ref/grpc/PerformanceDiagnostics/listRawStatements.md) #### ResourcePreset - [Overview](api-ref/grpc/ResourcePreset/index.md) - [Get](api-ref/grpc/ResourcePreset/get.md) - [List](api-ref/grpc/ResourcePreset/list.md) #### User - [Overview](api-ref/grpc/User/index.md) - [Get](api-ref/grpc/User/get.md) - [List](api-ref/grpc/User/list.md) - [Create](api-ref/grpc/User/create.md) - [Update](api-ref/grpc/User/update.md) - [Delete](api-ref/grpc/User/delete.md) - [GrantPermission](api-ref/grpc/User/grantPermission.md) - [RevokePermission](api-ref/grpc/User/revokePermission.md) #### Versions - [Overview](api-ref/grpc/Versions/index.md) - [List](api-ref/grpc/Versions/list.md) ### REST - [Overview](api-ref/index.md) #### BackupRetentionPolicy - [Overview](api-ref/BackupRetentionPolicy/index.md) - [Get](api-ref/BackupRetentionPolicy/get.md) - [List](api-ref/BackupRetentionPolicy/list.md) - [Create](api-ref/BackupRetentionPolicy/create.md) - [Delete](api-ref/BackupRetentionPolicy/delete.md) #### Backup - [Overview](api-ref/Backup/index.md) - [Get](api-ref/Backup/get.md) - [List](api-ref/Backup/list.md) - [Delete](api-ref/Backup/delete.md) #### Cluster - [Overview](api-ref/Cluster/index.md) - [Get](api-ref/Cluster/get.md) - [List](api-ref/Cluster/list.md) - [Create](api-ref/Cluster/create.md) - [Update](api-ref/Cluster/update.md) - [Delete](api-ref/Cluster/delete.md) - [Start](api-ref/Cluster/start.md) - [Stop](api-ref/Cluster/stop.md) - [Move](api-ref/Cluster/move.md) - [Backup](api-ref/Cluster/backup.md) - [Restore](api-ref/Cluster/restore.md) - [RescheduleMaintenance](api-ref/Cluster/rescheduleMaintenance.md) - [StartFailover](api-ref/Cluster/startFailover.md) - [ListLogs](api-ref/Cluster/listLogs.md) - [StreamLogs](api-ref/Cluster/streamLogs.md) - [ListOperations](api-ref/Cluster/listOperations.md) - [ListBackups](api-ref/Cluster/listBackups.md) - [ListHosts](api-ref/Cluster/listHosts.md) - [AddHosts](api-ref/Cluster/addHosts.md) - [DeleteHosts](api-ref/Cluster/deleteHosts.md) - [UpdateHosts](api-ref/Cluster/updateHosts.md) - [ListAccessBindings](api-ref/Cluster/listAccessBindings.md) - [SetAccessBindings](api-ref/Cluster/setAccessBindings.md) - [UpdateAccessBindings](api-ref/Cluster/updateAccessBindings.md) #### Database - [Overview](api-ref/Database/index.md) - [Get](api-ref/Database/get.md) - [List](api-ref/Database/list.md) - [Create](api-ref/Database/create.md) - [Update](api-ref/Database/update.md) - [Delete](api-ref/Database/delete.md) #### ManagedRepack - [Overview](api-ref/ManagedRepack/index.md) - [ListRunningRepacks](api-ref/ManagedRepack/listRunningRepacks.md) - [LaunchRepack](api-ref/ManagedRepack/launchRepack.md) - [TerminateRepack](api-ref/ManagedRepack/terminateRepack.md) #### Operation - [Overview](api-ref/Operation/index.md) - [Get](api-ref/Operation/get.md) - [Cancel](api-ref/Operation/cancel.md) #### ResourcePreset - [Overview](api-ref/ResourcePreset/index.md) - [Get](api-ref/ResourcePreset/get.md) - [List](api-ref/ResourcePreset/list.md) #### User - [Overview](api-ref/User/index.md) - [Get](api-ref/User/get.md) - [List](api-ref/User/list.md) - [Create](api-ref/User/create.md) - [Update](api-ref/User/update.md) - [Delete](api-ref/User/delete.md) - [GrantPermission](api-ref/User/grantPermission.md) - [RevokePermission](api-ref/User/revokePermission.md) #### Versions - [Overview](api-ref/Versions/index.md) - [List](api-ref/Versions/list.md) - [Monitoring metrics](metrics.md) - [Audit Trails events](at-ref.md) - [Public materials](public-talks.md) - [Release notes](release-notes.md) ## FAQ - [General questions](qa/general.md) - [Connection](qa/connection.md) - [Updating a cluster](qa/update.md) - [Cluster configuration](qa/configuration.md) - [Moving and restoring a cluster](qa/backup.md) - [Upgrading the PostgreSQL major version](qa/version-update.md) - [Users and roles](qa/users.md) - [High availability and load balancing](qa/ha.md) - [Monitoring and logs](qa/monitoring.md) - [Error messages](qa/errors.md) - [All questions on one page](qa/all.md)