Moving and restoring a PostgreSQL cluster

• Can I restore a cluster backup to a running Managed Service for PostgreSQL instance in another cloud network?

• Can I change the retention period for automatic backups?

• Do I need the wal2json plugin if I am only doing replication and not copying?

• Can I download a database backup to my local machine?

• How do I move a local PostgreSQL database dump to Yandex Cloud?

• How do I migrate a database or a table from one cluster to another?

• How do I transfer data between clusters in different folders or clouds?

• How do I move a cluster to another cloud?

• How do I restore a backup to an existing cluster?

• How do I restore a cluster to the state of the selected backup?

• Can I recover a single database from a backup?

Can I restore a cluster backup to a running Managed Service for PostgreSQL instance in another cloud network?Can I restore a cluster backup to a running Managed Service for PostgreSQL instance in another cloud network?

Yes, you can switch to another cloud network when restoring a cluster from a backup.

Can I change the retention period for automatic backups?Can I change the retention period for automatic backups?

You can set a retention period for automatic backups:

• When creating or updating a cluster. Possible values: between 7 and 60 days.

• When creating backup policies. Possible values: between 7 and 1095 days (up to three years).

Do I need the wal2json plugin if I am only doing data replication and not copying?Do I need the wal2json plugin if I am only doing data replication and not copying?

Yes, you need this plugin even if you do not copy data.

Can I download a database backup to my local machine?Can I download a database backup to my local machine?

While Yandex Cloud service does not support local backup downloads, you can use the pg_dump utility as an alternative.

How do I move a local PostgreSQL database dump to Yandex Cloud?How do I move a local PostgreSQL database dump to Yandex Cloud?

Follow the steps described in this Migrating databases tutorial.

How do I migrate a database or a table from one cluster to another?How do I migrate a database or a table from one cluster to another?

You can migrate a database or a table using Data Transfer or pg_dump.

For more information on using Data Transfer for migration, see Database migration.

How do I transfer data between clusters in different folders or clouds?How do I transfer data between clusters in different folders or clouds?

You can transfer data using Data Transfer or pg_dump.

For more information on using Data Transfer for migration, see Database migration.

How do I move a cluster to another cloud?How do I move a cluster to another cloud?

You can move a cluster using Data Transfer or pg_dump.

For more information on using Data Transfer for migration, see Database migration.

How do I restore a backup to an existing cluster?How do I restore a backup to an existing cluster?

You can only restore a backup to a new cluster.

How do I restore a cluster to the state of the selected backup?How do I restore a cluster to the state of the selected backup?

You can only restore a backup to a new cluster.

Can I restore a single database from a backup?Can I restore a single database from a backup?

No, you cannot select specific databases. You can only restore the entire cluster with all its databases.