Yandex.Cloud
  • Services
  • Why Yandex.Cloud
  • Pricing
  • Documentation
  • Contact us
Get started
Yandex Managed Service for PostgreSQL
  • Getting started
  • Step-by-step instructions
    • All instructions
    • Information about existing clusters
    • Creating clusters
    • Connecting to databases
    • Stop and start the cluster
    • SQL queries in the management console
    • Changing cluster and database settings
    • Connecting to DataLens
    • Managing PostgreSQL hosts
    • Database management
    • How to manage PostgreSQL extensions
    • Managing database users
    • Granting permissions and roles
    • Managing backups
    • Deleting clusters
    • Database migration to the Cloud
    • Creating a logical replica of Amazon RDS for PostgreSQL in Managed Service for PostgreSQL
  • Solutions
    • Creating a PostgreSQL cluster for 1C
  • Concepts
    • Relationship between service resources
    • Host classes
    • Network in Yandex Managed Service for PostgreSQL
    • Quotas and limits
    • Storage types
    • Backups
    • Assigning roles
    • Replication
    • Supported clients
  • Access management
  • Pricing policy
    • Current pricing policy
    • Archive
      • Before January 1, 2019
      • From January 1 to March 1, 2019
      • From March 1, 2019 to February 1, 2020
  • API reference
    • Authentication in the API
    • gRPC
      • Overview
      • BackupService
      • ClusterService
      • DatabaseService
      • ResourcePresetService
      • UserService
      • OperationService
    • REST
      • Overview
      • Backup
        • Overview
        • get
        • list
      • Cluster
        • Overview
        • addHosts
        • backup
        • create
        • delete
        • deleteHosts
        • get
        • list
        • listBackups
        • listHosts
        • listLogs
        • listOperations
        • move
        • rescheduleMaintenance
        • restore
        • start
        • startFailover
        • stop
        • streamLogs
        • update
        • updateHosts
      • Database
        • Overview
        • create
        • delete
        • get
        • list
        • update
      • ResourcePreset
        • Overview
        • get
        • list
      • User
        • Overview
        • create
        • delete
        • get
        • grantPermission
        • list
        • revokePermission
        • update
      • Operation
        • Overview
        • get
  • Questions and answers
    • General questions
    • Questions about PostgreSQL
    • All questions on the same page
  1. Questions and answers
  2. Questions about PostgreSQL

Questions about PostgreSQL

    How to import data to a PostgreSQL database cluster in Managed Service for PostgreSQL?

    Use the pg_dump built-in tool to migrate data to a PostgreSQL cluster in Managed Service for PostgreSQL.

    What PostgreSQL versions does Managed Service for PostgreSQL support?

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

    Is DB cluster backup enabled by default?

    Yes, backup is enabled by default. For PostgreSQL clusters, a full backup is performed once a day, saving all the database cluster transaction logs. This allows you to restore the cluster state to any point in time during the backup storage period, except for the last 30 seconds.

    Are PostgreSQL database cluster connections encrypted?

    Connections between a database cluster and an application are always encrypted using SSL. You cannot disable cluster connection encryption.

    What is a read-only replica in PostgreSQL?

    A read-only replica is a host in a PostgreSQL DB cluster that can only be read. Its data is synced with the master host (applies only if the cluster has more than 1 host). You can use a read-only replica to reduce the load on the DB master host with a large number of read requests.

    What PostgreSQL extensions are supported in Managed Service for PostgreSQL?

    The list of supported PostgreSQL extensions is provided in Managing PostgreSQL extensions.

    What limitations are imposed on PostgreSQL database clusters?

    For more information about Managed Service for PostgreSQL limitations, see Quotas and limits. Characteristics of clusters that can be created using Managed Service for PostgreSQL are given in Host classes.

    Which LC_COLLATE and LC_CTYPE values are set for databases by default?

    When databases are created, LC_CTYPE=C and LC_COLLATE=C are set by default. You can't change these settings for the database you create along with the cluster. However, you can create a new database and set the values you need for it.

    Language
    Careers
    Privacy policy
    Terms of use
    © 2021 Yandex.Cloud LLC