Step-by-step guides for Managed Service for PostgreSQL

ClustersClusters

• Getting information on existing clusters
• Creating a cluster
• Updating cluster settings
• Stopping and starting a cluster
• Managing cluster hosts
• Migrating cluster hosts to a different availability zone
• Managing replication slots
• Managing backups
• Managing disk space
• Maintenance
• PostgreSQL version upgrade
• Deleting a cluster

DatabasesDatabases

• Connecting to a database in a cluster
• SQL queries in Yandex WebSQL
• Copying and populating a table from a local machine
• Managing databases

PostgreSQL usersPostgreSQL users

• User management
• Assigning privileges and roles to users

PostgreSQL extensions and dictionariesPostgreSQL extensions and dictionaries

• Managing extensions
• Using pg_cron
• Using pg_repack
• Using pgaudit
• Using pgcrypto
• Using postgresql_anonymizer
• Using a Hunspell dictionary for full-text search

Logs and monitoringLogs and monitoring

• Viewing cluster logs
• Performance diagnostics
• Monitoring the state of clusters and hosts
• Connecting to a cluster from DataLens