Moving and restoring a cluster PostgreSQL

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

• Can I change the retention period of automatic backups?

• Do I need the wal2json plugin if there is only data replication and no copying?

• Can I make a local dump of a database backup?

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

• How do I migrate a database or 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 restore a backup to an existing cluster?

• How do I restore the cluster state to 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 a different cloud network?Can I restore a cluster backup to a running Managed Service for PostgreSQL instance in a different cloud network?

You can only recover a cluster from a backup within a single cloud network.

To migrate data between cloud networks, follow the migration guide.

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

When creating or modifying a cluster, you can set the retention period for automatic backups.

Do I need the wal2json plugin if data is only replicated but not copied?Do I need the wal2json plugin if data is only replicated but not copied?

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

Can I make a local dump of a database backup?Can I make a local dump of a database backup?

You cannot use the service to make a local dump of a DB backup from Yandex Cloud but you can use the pg_dump utility.

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 Migrating databases.

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

You can migrate a database or 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 restore a backup only to a new cluster.

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

You can restore a backup only to a new cluster.

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

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