> For the complete documentation index, see [llms.txt](https://123cluster.gitbook.io/123cluster/llms.txt). Markdown versions of documentation pages are available by appending `.md` to page URLs; this page is available as [Markdown](https://123cluster.gitbook.io/123cluster/postgresql.md).

# PostgreSQL

## Create a Cluster

1. ### Click the 'add a new cluster' button and select PostgreSQL.

   <figure><img src="https://123cluster.com/wp-content/uploads/2024/04/pg_create_cluster1.5978324d7fec8573c0a5-1024x507.png" alt=""><figcaption></figcaption></figure>
2. ### Fill the required information about the database cluster and click next.

   <figure><img src="https://2061072632-files.gitbook.io/~/files/v0/b/gitbook-x-prod.appspot.com/o/spaces%2Fk8IgCuO8enq5mfH0cUMv%2Fuploads%2FjxS9OwkUTvrYY2gcTeyf%2F%D0%B8%D0%B7%D0%BE%D0%B1%D1%80%D0%B0%D0%B6%D0%B5%D0%BD%D0%B8%D0%B5.png?alt=media&amp;token=fe90ac41-8ae5-41bd-8956-cc6675698012" alt=""><figcaption></figcaption></figure>
3. ### Fill additional required information and click 'Check' to verify validity.

   <figure><img src="https://2061072632-files.gitbook.io/~/files/v0/b/gitbook-x-prod.appspot.com/o/spaces%2Fk8IgCuO8enq5mfH0cUMv%2Fuploads%2FZsLTQkRoWGxsadf219Gm%2F%D0%B8%D0%B7%D0%BE%D0%B1%D1%80%D0%B0%D0%B6%D0%B5%D0%BD%D0%B8%D0%B5.png?alt=media&amp;token=6d6160e0-8310-4a7b-9f6d-110af2224934" alt=""><figcaption></figcaption></figure>
4. ### 'Rest API' Button will copy to clipboard for your DevOps tools.

   <br>

   <figure><img src="https://2061072632-files.gitbook.io/~/files/v0/b/gitbook-x-prod.appspot.com/o/spaces%2Fk8IgCuO8enq5mfH0cUMv%2Fuploads%2F7MsLLPqcP1KNnjpY8j3v%2Fpg_create_cluster4.b12eb789c312bb4de112-2048x1010.png?alt=media&amp;token=77ba26be-7105-425b-b0e3-f6bcca743486" alt=""><figcaption></figcaption></figure>
5. ### Click 'Submit' to create the cluster.

## Restore a node or cluster

1. ### Drag the selected backup onto the primary.

   <br>

   <figure><img src="https://2061072632-files.gitbook.io/~/files/v0/b/gitbook-x-prod.appspot.com/o/spaces%2Fk8IgCuO8enq5mfH0cUMv%2Fuploads%2F873ZyppvXOldzxmMFooZ%2F%D0%B8%D0%B7%D0%BE%D0%B1%D1%80%D0%B0%D0%B6%D0%B5%D0%BD%D0%B8%D0%B5.png?alt=media&amp;token=525288a6-d0f9-4a40-a5d1-ec0c41a37fb0" alt=""><figcaption></figcaption></figure>
2. ### Click the correct option for your restoration point.

   <br>

   <figure><img src="https://2061072632-files.gitbook.io/~/files/v0/b/gitbook-x-prod.appspot.com/o/spaces%2Fk8IgCuO8enq5mfH0cUMv%2Fuploads%2Fk6CbB7C8oz8saK6G1Jin%2F%D0%B8%D0%B7%D0%BE%D0%B1%D1%80%D0%B0%D0%B6%D0%B5%D0%BD%D0%B8%D0%B5.png?alt=media&amp;token=8aa40d2e-ff7a-49ed-90ae-06bf8c49957a" alt=""><figcaption></figcaption></figure>
3. ### To avoid loss of data, type 'restore me' into the text box to confirm your decision.

   <br>

   <figure><img src="https://2061072632-files.gitbook.io/~/files/v0/b/gitbook-x-prod.appspot.com/o/spaces%2Fk8IgCuO8enq5mfH0cUMv%2Fuploads%2Fwhpt8OIgsYmMeTGSXzLS%2F%D0%B8%D0%B7%D0%BE%D0%B1%D1%80%D0%B0%D0%B6%D0%B5%D0%BD%D0%B8%D0%B5.png?alt=media&amp;token=8000bda3-0e34-440f-8ae4-0a76a07f9a2b" alt=""><figcaption></figcaption></figure>
4. ### 'Rest API' Button will copy to clipboard for your DevOps tools.

   <br>

   <figure><img src="https://2061072632-files.gitbook.io/~/files/v0/b/gitbook-x-prod.appspot.com/o/spaces%2Fk8IgCuO8enq5mfH0cUMv%2Fuploads%2F2kf4ASj8E2Bwcr9W0PK7%2F%D0%B8%D0%B7%D0%BE%D0%B1%D1%80%D0%B0%D0%B6%D0%B5%D0%BD%D0%B8%D0%B5.png?alt=media&amp;token=85251900-a09c-4504-967a-7d9403abc520" alt=""><figcaption></figcaption></figure>
5. ### Click 'Submit' to initiate the restore.

## Create a standby

1. ### Switch to the 'Standbys' tab on your cluster inventory.

   <figure><img src="https://2061072632-files.gitbook.io/~/files/v0/b/gitbook-x-prod.appspot.com/o/spaces%2Fk8IgCuO8enq5mfH0cUMv%2Fuploads%2Fu8danAJO3NTEUGZwkQ8K%2F%D0%B8%D0%B7%D0%BE%D0%B1%D1%80%D0%B0%D0%B6%D0%B5%D0%BD%D0%B8%D0%B5.png?alt=media&amp;token=9d861333-0a58-4016-82e2-7ea5199e4bd4" alt=""><figcaption></figcaption></figure>

2. ### Drag the object labeled 'Drag me on to Primary to create a standby' onto the primary

   <br>

   <figure><img src="https://2061072632-files.gitbook.io/~/files/v0/b/gitbook-x-prod.appspot.com/o/spaces%2Fk8IgCuO8enq5mfH0cUMv%2Fuploads%2FWTu2cxGKYGGH5V3Kdpo0%2F%D0%B8%D0%B7%D0%BE%D0%B1%D1%80%D0%B0%D0%B6%D0%B5%D0%BD%D0%B8%D0%B5.png?alt=media&amp;token=fdf77370-62f4-4fd4-9a56-86cd7d5384fe" alt=""><figcaption></figcaption></figure>

3. ### Fill in the required information for your standby node and click next.

   <br>

   <figure><img src="https://2061072632-files.gitbook.io/~/files/v0/b/gitbook-x-prod.appspot.com/o/spaces%2Fk8IgCuO8enq5mfH0cUMv%2Fuploads%2Ffx3fq1lpdAesJopKvNiY%2F%D0%B8%D0%B7%D0%BE%D0%B1%D1%80%D0%B0%D0%B6%D0%B5%D0%BD%D0%B8%D0%B5.png?alt=media&amp;token=874ea52b-53d5-4f07-9cd8-cdd2ed68b3ae" alt=""><figcaption></figcaption></figure>

4. ### Fill additional required information and verify settings' validity by clicking the 'Check' button.

   <br>

   <figure><img src="https://2061072632-files.gitbook.io/~/files/v0/b/gitbook-x-prod.appspot.com/o/spaces%2Fk8IgCuO8enq5mfH0cUMv%2Fuploads%2FbKBzCcitMyWMp8UpcYOk%2F%D0%B8%D0%B7%D0%BE%D0%B1%D1%80%D0%B0%D0%B6%D0%B5%D0%BD%D0%B8%D0%B5.png?alt=media&amp;token=1a959150-fdfe-4dd9-bc38-0efa795949d0" alt=""><figcaption></figcaption></figure>

5. ### 'Rest API' Button will copy to clipboard for your DevOps tools.

   <br>

   <figure><img src="https://2061072632-files.gitbook.io/~/files/v0/b/gitbook-x-prod.appspot.com/o/spaces%2Fk8IgCuO8enq5mfH0cUMv%2Fuploads%2FYfoqcMfcigud3l7b0Yii%2F%D0%B8%D0%B7%D0%BE%D0%B1%D1%80%D0%B0%D0%B6%D0%B5%D0%BD%D0%B8%D0%B5.png?alt=media&amp;token=11693c13-c7e8-44b8-951d-d70a27cd823f" alt=""><figcaption></figcaption></figure>

6. ### Click 'Submit' to create the Standby.

## Create a database

1. ### Switch to the 'Databases' tab on your cluster inventory.

   <br>

   <figure><img src="https://2061072632-files.gitbook.io/~/files/v0/b/gitbook-x-prod.appspot.com/o/spaces%2Fk8IgCuO8enq5mfH0cUMv%2Fuploads%2Fy6nPRCESd4qk0WO2FfMp%2F%D0%B8%D0%B7%D0%BE%D0%B1%D1%80%D0%B0%D0%B6%D0%B5%D0%BD%D0%B8%D0%B5.png?alt=media&amp;token=5f7a7c44-cf27-4000-b28f-60c859e980bf" alt=""><figcaption></figcaption></figure>
2. ### Drag the object labeled 'Drag me on to Primary to create a database' onto the primary.

   <br>

   <figure><img src="https://2061072632-files.gitbook.io/~/files/v0/b/gitbook-x-prod.appspot.com/o/spaces%2Fk8IgCuO8enq5mfH0cUMv%2Fuploads%2Fk9Cu0AH24hgMLpK7dwbW%2F%D0%B8%D0%B7%D0%BE%D0%B1%D1%80%D0%B0%D0%B6%D0%B5%D0%BD%D0%B8%D0%B5.png?alt=media&amp;token=08f0a63a-3002-4417-95cd-3a540ed49b6d" alt=""><figcaption></figcaption></figure>
3. ### Choose a name for your database and click the 'Check' button to ensure it is available.

   <br>

   <figure><img src="https://2061072632-files.gitbook.io/~/files/v0/b/gitbook-x-prod.appspot.com/o/spaces%2Fk8IgCuO8enq5mfH0cUMv%2Fuploads%2FtXrxA6NhcnlNoyuIKjg6%2Fpg_create_database3.d93cc7809ad0d7959e70-2048x990.png?alt=media&amp;token=e09fc99d-e71f-46f7-bb6a-10a5c34e8c79" alt=""><figcaption></figcaption></figure>
4. ### You may opt into the auto-delete function, your database will be deleted at your desired date.

   <br>

   <figure><img src="https://2061072632-files.gitbook.io/~/files/v0/b/gitbook-x-prod.appspot.com/o/spaces%2Fk8IgCuO8enq5mfH0cUMv%2Fuploads%2F2ddqQwJrxXKrVoVT47Pn%2Fpg_create_database4.f9a41eafe5b8ea4746cd-2048x990.png?alt=media&amp;token=e4f8cb1e-287f-4f66-b645-b034f964ae1e" alt=""><figcaption></figcaption></figure>
5. ### 'Rest API' Button will copy to clipboard for your DevOps tools.

   <br>

   <figure><img src="https://2061072632-files.gitbook.io/~/files/v0/b/gitbook-x-prod.appspot.com/o/spaces%2Fk8IgCuO8enq5mfH0cUMv%2Fuploads%2FfobhGeKe99LQBrdEZ6hw%2F%D0%B8%D0%B7%D0%BE%D0%B1%D1%80%D0%B0%D0%B6%D0%B5%D0%BD%D0%B8%D0%B5.png?alt=media&amp;token=a67ff5e3-d5a8-4185-8efc-b347db997dab" alt=""><figcaption></figcaption></figure>
6. ### Click 'Submit' to create the Database.

## Start and stop a node

1. ### Double click the primary node to enter the node configuration.

   <br>

   <figure><img src="https://2061072632-files.gitbook.io/~/files/v0/b/gitbook-x-prod.appspot.com/o/spaces%2Fk8IgCuO8enq5mfH0cUMv%2Fuploads%2F1SXJykKcy8RsFqus849f%2F%D0%B8%D0%B7%D0%BE%D0%B1%D1%80%D0%B0%D0%B6%D0%B5%D0%BD%D0%B8%D0%B5.png?alt=media&amp;token=7b94732f-d39c-4caa-9208-39016bfa2b88" alt=""><figcaption></figcaption></figure>
2. ### To stop the node, click the 'Stop' button.

   <br>

   <figure><img src="https://2061072632-files.gitbook.io/~/files/v0/b/gitbook-x-prod.appspot.com/o/spaces%2Fk8IgCuO8enq5mfH0cUMv%2Fuploads%2FiQP1tLa4JsFvK2jmYzyV%2F%D0%B8%D0%B7%D0%BE%D0%B1%D1%80%D0%B0%D0%B6%D0%B5%D0%BD%D0%B8%D0%B5.png?alt=media&amp;token=f85a49df-f054-4ccf-ba93-a549eab5c068" alt=""><figcaption></figcaption></figure>
3. ### The instance status is shown on the left, a red star indicates the node is stopped.

   <figure><img src="https://2061072632-files.gitbook.io/~/files/v0/b/gitbook-x-prod.appspot.com/o/spaces%2Fk8IgCuO8enq5mfH0cUMv%2Fuploads%2FUbhMAqjPGbNKIPveeU6V%2F%D0%B8%D0%B7%D0%BE%D0%B1%D1%80%D0%B0%D0%B6%D0%B5%D0%BD%D0%B8%D0%B5.png?alt=media&amp;token=e78b94e4-f1fe-4452-8ce4-a3278360cd97" alt=""><figcaption></figcaption></figure>
4. ### To restart the node, click the 'Start' button.

   <br>

   <figure><img src="https://2061072632-files.gitbook.io/~/files/v0/b/gitbook-x-prod.appspot.com/o/spaces%2Fk8IgCuO8enq5mfH0cUMv%2Fuploads%2FPSUXGfh9YwpdbpN8pIja%2F%D0%B8%D0%B7%D0%BE%D0%B1%D1%80%D0%B0%D0%B6%D0%B5%D0%BD%D0%B8%D0%B5.png?alt=media&amp;token=2366cae5-e35a-4fd5-b73f-6d41f6b78a8f" alt=""><figcaption></figcaption></figure>

## Set node config and limits

1. ### Double click the primary node to enter the node configuration.

   <br>

   <figure><img src="https://2061072632-files.gitbook.io/~/files/v0/b/gitbook-x-prod.appspot.com/o/spaces%2Fk8IgCuO8enq5mfH0cUMv%2Fuploads%2FnHlMxusZexRyRCs4MQqK%2F%D0%B8%D0%B7%D0%BE%D0%B1%D1%80%D0%B0%D0%B6%D0%B5%D0%BD%D0%B8%D0%B5.png?alt=media&amp;token=3e9d8f50-b9a0-44ed-8721-fefaa06e49f9" alt=""><figcaption></figcaption></figure>

2. ### These are the current setting of your node.

   <figure><img src="https://2061072632-files.gitbook.io/~/files/v0/b/gitbook-x-prod.appspot.com/o/spaces%2Fk8IgCuO8enq5mfH0cUMv%2Fuploads%2FFB4XJaJUoAVqhC8C2GKW%2F%D0%B8%D0%B7%D0%BE%D0%B1%D1%80%D0%B0%D0%B6%D0%B5%D0%BD%D0%B8%D0%B5.png?alt=media&amp;token=8674b329-033c-4377-b1d5-4e0410d5dd14" alt=""><figcaption></figcaption></figure>

3. ### Click the 'change' button to open the node settings.

   <br>

   <figure><img src="https://2061072632-files.gitbook.io/~/files/v0/b/gitbook-x-prod.appspot.com/o/spaces%2Fk8IgCuO8enq5mfH0cUMv%2Fuploads%2Fgtwj4G9tuzUBbW77CyZg%2F%D0%B8%D0%B7%D0%BE%D0%B1%D1%80%D0%B0%D0%B6%D0%B5%D0%BD%D0%B8%D0%B5.png?alt=media&amp;token=9a2973fa-7f68-44ae-a128-72a9eeda4ee1" alt=""><figcaption></figcaption></figure>

4. ### Open the drop-down menu to modify your node.

   <br>

   <figure><img src="https://2061072632-files.gitbook.io/~/files/v0/b/gitbook-x-prod.appspot.com/o/spaces%2Fk8IgCuO8enq5mfH0cUMv%2Fuploads%2FBbYRnez4EpCuvfN3BYBY%2F%D0%B8%D0%B7%D0%BE%D0%B1%D1%80%D0%B0%D0%B6%D0%B5%D0%BD%D0%B8%D0%B5.png?alt=media&amp;token=8bbcd04f-f1ac-4660-a97d-5b35de14c41c" alt=""><figcaption></figcaption></figure>

5. ### 'Rest API' Button will copy to clipboard for your DevOps tools.

   <br>

   <figure><img src="https://2061072632-files.gitbook.io/~/files/v0/b/gitbook-x-prod.appspot.com/o/spaces%2Fk8IgCuO8enq5mfH0cUMv%2Fuploads%2FMUuCvS6FFujfhRnSl4gO%2F%D0%B8%D0%B7%D0%BE%D0%B1%D1%80%D0%B0%D0%B6%D0%B5%D0%BD%D0%B8%D0%B5.png?alt=media&amp;token=2d700216-f74c-4c06-8906-0b455f979c79" alt=""><figcaption></figcaption></figure>

6. ### Click 'Submit' to confirm your changes.

## Backup a node or a cluster

1. ### Switch to your 'backup' tab on your cluster inventory.

   <br>

   <figure><img src="https://2061072632-files.gitbook.io/~/files/v0/b/gitbook-x-prod.appspot.com/o/spaces%2Fk8IgCuO8enq5mfH0cUMv%2Fuploads%2FbCdUmnoIZc8oJltd9PrO%2F%D0%B8%D0%B7%D0%BE%D0%B1%D1%80%D0%B0%D0%B6%D0%B5%D0%BD%D0%B8%D0%B5.png?alt=media&amp;token=fec9d9a9-a5f3-48a0-a9a4-c4468abb7b83" alt=""><figcaption></figcaption></figure>
2. ### To create a backup, drag your primary node.onto your backups inventory.

   <br>

   <figure><img src="https://2061072632-files.gitbook.io/~/files/v0/b/gitbook-x-prod.appspot.com/o/spaces%2Fk8IgCuO8enq5mfH0cUMv%2Fuploads%2F7cLwhxYJQpT6KXMwE4wM%2F%D0%B8%D0%B7%D0%BE%D0%B1%D1%80%D0%B0%D0%B6%D0%B5%D0%BD%D0%B8%D0%B5.png?alt=media&amp;token=9bb92aa6-c0e4-4280-910a-7fdf64238bfe" alt=""><figcaption></figcaption></figure>
3. ### Select your desired backup strategy, standard backup or schedule a routine backup.

   <br>

   <figure><img src="https://2061072632-files.gitbook.io/~/files/v0/b/gitbook-x-prod.appspot.com/o/spaces%2Fk8IgCuO8enq5mfH0cUMv%2Fuploads%2F7ialdZHtJ9hY2ZhiodrP%2F%D0%B8%D0%B7%D0%BE%D0%B1%D1%80%D0%B0%D0%B6%D0%B5%D0%BD%D0%B8%D0%B5.png?alt=media&amp;token=c4b10f8c-7b91-43f6-90ba-860aaa397349" alt=""><figcaption></figcaption></figure>
4. ### Select a destination for your backup to be stored and whether or not you would like your backup to be compressed.

   <br>

   <figure><img src="https://2061072632-files.gitbook.io/~/files/v0/b/gitbook-x-prod.appspot.com/o/spaces%2Fk8IgCuO8enq5mfH0cUMv%2Fuploads%2FPgDKR0lyaiJOjJ0VPYMI%2F%D0%B8%D0%B7%D0%BE%D0%B1%D1%80%D0%B0%D0%B6%D0%B5%D0%BD%D0%B8%D0%B5.png?alt=media&amp;token=dba800b5-9636-445b-b2a7-1b40dd153400" alt=""><figcaption></figcaption></figure>
5. ### 'Rest API' Button will copy to clipboard for your DevOps tools.

   <br>

   <figure><img src="https://2061072632-files.gitbook.io/~/files/v0/b/gitbook-x-prod.appspot.com/o/spaces%2Fk8IgCuO8enq5mfH0cUMv%2Fuploads%2FjiXuzWixS7MDqLoNjVQj%2F%D0%B8%D0%B7%D0%BE%D0%B1%D1%80%D0%B0%D0%B6%D0%B5%D0%BD%D0%B8%D0%B5.png?alt=media&amp;token=06967a9c-656e-48ba-bfd9-e48a804aefe7" alt=""><figcaption></figcaption></figure>
6. ### Click 'Submit' to start your backup.

## Backup a database

1. ### Click the 'Physical layout' switch to view the databases in the cluster.

   <br>

   <figure><img src="https://2061072632-files.gitbook.io/~/files/v0/b/gitbook-x-prod.appspot.com/o/spaces%2Fk8IgCuO8enq5mfH0cUMv%2Fuploads%2FIgXlf4FRGaxWPuRw8PK5%2F%D0%B8%D0%B7%D0%BE%D0%B1%D1%80%D0%B0%D0%B6%D0%B5%D0%BD%D0%B8%D0%B5.png?alt=media&amp;token=caee52b5-51f9-4fe6-8235-2c05a050a1b7" alt=""><figcaption></figcaption></figure>
2. ### Switch to your 'Import/Export' tab to view your database backup inventory.

   <br>

   <figure><img src="https://2061072632-files.gitbook.io/~/files/v0/b/gitbook-x-prod.appspot.com/o/spaces%2Fk8IgCuO8enq5mfH0cUMv%2Fuploads%2F7QNGmAbsO8hsSKJqFemY%2F%D0%B8%D0%B7%D0%BE%D0%B1%D1%80%D0%B0%D0%B6%D0%B5%D0%BD%D0%B8%D0%B5.png?alt=media&amp;token=d38ee4ca-d09a-417c-a735-97f4a48c6248" alt=""><figcaption></figcaption></figure>
3. ### Drag your desired database onto your database inventory.

   <br>

   <figure><img src="https://2061072632-files.gitbook.io/~/files/v0/b/gitbook-x-prod.appspot.com/o/spaces%2Fk8IgCuO8enq5mfH0cUMv%2Fuploads%2FaEMNo60FQscRIwZdRjhp%2F%D0%B8%D0%B7%D0%BE%D0%B1%D1%80%D0%B0%D0%B6%D0%B5%D0%BD%D0%B8%D0%B5.png?alt=media&amp;token=e5c08236-4c2e-4c9d-88db-0c57fe83c94f" alt=""><figcaption></figcaption></figure>
4. ### Choose a name for your backup database, select additional options and click next.

   <br>

   <figure><img src="https://2061072632-files.gitbook.io/~/files/v0/b/gitbook-x-prod.appspot.com/o/spaces%2Fk8IgCuO8enq5mfH0cUMv%2Fuploads%2FWPduAaq4UNMVIzNLgS9R%2F%D0%B8%D0%B7%D0%BE%D0%B1%D1%80%D0%B0%D0%B6%D0%B5%D0%BD%D0%B8%D0%B5.png?alt=media&amp;token=5b46f359-8bf2-4335-a992-33d955717f0c" alt=""><figcaption></figcaption></figure>
5. ### 'Rest API' Button will copy to clipboard for your DevOps tools.

   <br>

   <figure><img src="https://2061072632-files.gitbook.io/~/files/v0/b/gitbook-x-prod.appspot.com/o/spaces%2Fk8IgCuO8enq5mfH0cUMv%2Fuploads%2FT8jZZEzceqoGqfSg4APu%2Fpg_backup_database5.81adf0b02ecfc6ef4174-2048x1008.png?alt=media&amp;token=5726ed02-5f9c-4c27-9720-c764b2649340" alt=""><figcaption></figcaption></figure>
6. ### Click 'Submit' to start your backup.

## Restore a database

1. ### Switch to your 'Import/Export' tab to view your database inventory.

   <br>

   <figure><img src="https://2061072632-files.gitbook.io/~/files/v0/b/gitbook-x-prod.appspot.com/o/spaces%2Fk8IgCuO8enq5mfH0cUMv%2Fuploads%2F6k1KOZhcm6vbqIVMISZV%2F%D0%B8%D0%B7%D0%BE%D0%B1%D1%80%D0%B0%D0%B6%D0%B5%D0%BD%D0%B8%D0%B5.png?alt=media&amp;token=7def940c-6a48-4ec1-895d-076e9d721c3c" alt=""><figcaption></figcaption></figure>
2. ### Drag your desired backup onto your primary node.

   <br>

   <figure><img src="https://2061072632-files.gitbook.io/~/files/v0/b/gitbook-x-prod.appspot.com/o/spaces%2Fk8IgCuO8enq5mfH0cUMv%2Fuploads%2FBsm7JKMpLxisE95dcUSw%2F%D0%B8%D0%B7%D0%BE%D0%B1%D1%80%D0%B0%D0%B6%D0%B5%D0%BD%D0%B8%D0%B5.png?alt=media&amp;token=d6d21560-995a-4644-8a72-4fc8ddf35917" alt=""><figcaption></figcaption></figure>
3. ### Type 'restore me' into the text box to avoid accidental loss of data.

   <br>

   <figure><img src="https://2061072632-files.gitbook.io/~/files/v0/b/gitbook-x-prod.appspot.com/o/spaces%2Fk8IgCuO8enq5mfH0cUMv%2Fuploads%2FyMYizAieEpxJDQr5jNqT%2F%D0%B8%D0%B7%D0%BE%D0%B1%D1%80%D0%B0%D0%B6%D0%B5%D0%BD%D0%B8%D0%B5.png?alt=media&amp;token=8fbecfba-35b8-408f-af15-806138b93cd6" alt=""><figcaption></figcaption></figure>
4. ### 'Rest API' Button will copy to clipboard for your DevOps tools.

   <br>

   <figure><img src="https://2061072632-files.gitbook.io/~/files/v0/b/gitbook-x-prod.appspot.com/o/spaces%2Fk8IgCuO8enq5mfH0cUMv%2Fuploads%2FR5fsirW4jfAQ4ZMd6oQ5%2F%D0%B8%D0%B7%D0%BE%D0%B1%D1%80%D0%B0%D0%B6%D0%B5%D0%BD%D0%B8%D0%B5.png?alt=media&amp;token=ff3550b2-b5f9-4d93-971b-4ad2d3e59a68" alt=""><figcaption></figcaption></figure>
5. ### Click 'Submit' to restore.

## Drop a node

1. ### Drag the node you with to drop onto the bin, can be either primary or a standby.

   <br>

   <figure><img src="https://2061072632-files.gitbook.io/~/files/v0/b/gitbook-x-prod.appspot.com/o/spaces%2Fk8IgCuO8enq5mfH0cUMv%2Fuploads%2F9aBBLhXBHwmNvH0h2gME%2F%D0%B8%D0%B7%D0%BE%D0%B1%D1%80%D0%B0%D0%B6%D0%B5%D0%BD%D0%B8%D0%B5.png?alt=media&amp;token=b79fef05-e3ee-4fb0-9e66-f097d2a008b8" alt=""><figcaption></figcaption></figure>
2. ### Type 'drop me' into the text box to confirm your decision.

   <br>

   <figure><img src="https://2061072632-files.gitbook.io/~/files/v0/b/gitbook-x-prod.appspot.com/o/spaces%2Fk8IgCuO8enq5mfH0cUMv%2Fuploads%2F2kwzOv8eK0u2X4c8QcHy%2F%D0%B8%D0%B7%D0%BE%D0%B1%D1%80%D0%B0%D0%B6%D0%B5%D0%BD%D0%B8%D0%B5.png?alt=media&amp;token=eeaf546d-907b-49be-a17c-a1b89a32d6e3" alt=""><figcaption></figcaption></figure>
3. ### 'Rest API' Button will copy to clipboard for your DevOps tools.

   <br>

   <figure><img src="https://2061072632-files.gitbook.io/~/files/v0/b/gitbook-x-prod.appspot.com/o/spaces%2Fk8IgCuO8enq5mfH0cUMv%2Fuploads%2Fq5Tgv61jxlnakrio7lAn%2F%D0%B8%D0%B7%D0%BE%D0%B1%D1%80%D0%B0%D0%B6%D0%B5%D0%BD%D0%B8%D0%B5.png?alt=media&amp;token=c9539324-5203-4cf7-a95d-bba84e82c97a" alt=""><figcaption></figcaption></figure>
4. ### Click 'Submit' to drop the node.

## Drop a database

1. ### Click the 'Physical layout' switch to view the databases in the cluster.

   <br>

   <figure><img src="https://2061072632-files.gitbook.io/~/files/v0/b/gitbook-x-prod.appspot.com/o/spaces%2Fk8IgCuO8enq5mfH0cUMv%2Fuploads%2FRnmGEod6PxpE8qKAk5cn%2F%D0%B8%D0%B7%D0%BE%D0%B1%D1%80%D0%B0%D0%B6%D0%B5%D0%BD%D0%B8%D0%B5.png?alt=media&amp;token=384a4546-8254-4f0a-9e26-7614aaf7569d" alt=""><figcaption></figcaption></figure>
2. ### Drag the database you wish to drop onto the bin.

   <br>

   <figure><img src="https://2061072632-files.gitbook.io/~/files/v0/b/gitbook-x-prod.appspot.com/o/spaces%2Fk8IgCuO8enq5mfH0cUMv%2Fuploads%2Fj2iZ1tfqkahhvRB0zWHc%2F%D0%B8%D0%B7%D0%BE%D0%B1%D1%80%D0%B0%D0%B6%D0%B5%D0%BD%D0%B8%D0%B5.png?alt=media&amp;token=aed486be-0dcf-4816-a444-5dfde0743d75" alt=""><figcaption></figcaption></figure>
3. ### Type 'drop me' into the text box to confirm your decision.

   <br>

   <figure><img src="https://2061072632-files.gitbook.io/~/files/v0/b/gitbook-x-prod.appspot.com/o/spaces%2Fk8IgCuO8enq5mfH0cUMv%2Fuploads%2FD9w0pgbJJ6ViM3sZWaR9%2F%D0%B8%D0%B7%D0%BE%D0%B1%D1%80%D0%B0%D0%B6%D0%B5%D0%BD%D0%B8%D0%B5.png?alt=media&amp;token=74104837-2cb2-476e-9fdc-8da766de922a" alt=""><figcaption></figcaption></figure>
4. ### 'Rest API' Button will copy to clipboard for your DevOps tools.

   <br>

   <figure><img src="https://2061072632-files.gitbook.io/~/files/v0/b/gitbook-x-prod.appspot.com/o/spaces%2Fk8IgCuO8enq5mfH0cUMv%2Fuploads%2FOOnc9hjc7Cll2XbAb0Ez%2F%D0%B8%D0%B7%D0%BE%D0%B1%D1%80%D0%B0%D0%B6%D0%B5%D0%BD%D0%B8%D0%B5.png?alt=media&amp;token=8f49176c-fa55-4dba-93fd-230f46b1834b" alt=""><figcaption></figcaption></figure>
5. ### Click 'Submit' to drop the database.

## Drop a backup or export

1. ### Switch to your 'Import/Export' tab to view your database inventory.

   <figure><img src="https://123cluster.com/wp-content/uploads/2024/04/pg_drop_export1.c9621d0641bc1e50c37c-1024x498-1.png" alt=""><figcaption></figcaption></figure>
2. ### Drag the export you wish to drop onto the bin.

   <figure><img src="https://123cluster.com/wp-content/uploads/2024/04/pg_drop_export2.a7b2764fb8ffc8404eae-1024x498-1.png" alt=""><figcaption></figcaption></figure>
3. ### 'Rest API' Button will copy to clipboard for your DevOps tools.

   <figure><img src="https://123cluster.com/wp-content/uploads/2024/04/pg_drop_export3.c2f919bd57b3d83f0d6a-1024x498-1.png" alt=""><figcaption></figcaption></figure>
4. ### Click 'Yes' to drop the export.