Questions about PostgreSQL

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

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

Which PostgreSQL versions does Managed Service for PostgreSQL support?

Managed Service for PostgreSQL supports only PostgreSQL 10 and 11.

Is DB cluster backup enabled by default?

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

Is a PostgreSQL DB cluster connection 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 one 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 extensions for PostgreSQL are supported in Managed Service for PostgreSQL?

The list of supported extensions for PostgreSQL is given in the section Managing PostgreSQL extensions.

What limitations are imposed on PostgreSQL database clusters?

Learn more about Managed Service for PostgreSQL limitations in the section Quotas and limits. The section Host classes provides characteristics of clusters that can be created using Managed Service for PostgreSQL.