Moving and restoring a PostgreSQL cluster
Can I restore a cluster backup to a running Managed Service for PostgreSQL instance on 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 instructions.
Do I need the wal2json plugin if there is only data replication and no copying?
Yes, you need the plugin even if you do not copy data.
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 Nebius AI but you can use the pg_dump utility
How do I move a local PostgreSQL database dump to Nebius AI?
Follow the instructions in Migrating databases.
How do I 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.
Why can a data transfer through creating and restoring a logical dump fail with an error?
Restoring a logical dump may fail with one of the following errors:
ERROR: role "<source username>" does not exist
ERROR: must be member of role "<source username>"
The errors occur because the target cluster does not have the user (or the privileges of the user) who created the logical dump in the source cluster.
To resolve the errors:
- In the target cluster, add a user with access to the migrated database and the same name as the user who created the logical dump in the source cluster.
- Use this user to restore the logical dump or grant their privileges to the user who is restoring the logical dump.