Copy a PostgreSQL Database
A clear, step-by-step guide that details the process of copying a PostgreSQL database within your cluster. This overview focuses on executing the essential commands to duplicate your database, ensuring the copy is accurately synchronized and fully operational—all without delving into advanced copy configurations or long-term maintenance tasks.
Here's the databases inventory—your comprehensive list of all databases for this cluster and other PostgreSQL clusters.
The database you want to copy can reside in this cluster or another. For this guide, we’ll show both scenarios.
Simply drag the selected database onto the primary instance to initiate the copy process.
If copying a database from another cluster, choose between a one-time copy or an ongoing live replication.
If copying a database from this cluster, decide whether to overwrite the current database or copy its data to a new database with a different name.
Instantly, a REST API command is generated—your key to automating future database copying operations with your DEVOPS tool.
Once everything is configured, press Submit to start the copy process.
You'll see a status update indicating that the database is being copied, followed by confirmation that the database was successfully copied.
That’s it! You can now see the copied database in the database layout tab and in the databases inventory.
