46.7. Base Backup Processes

46.7. Base Backup Processes
Prev	Up	Chapter 46. Activity	Home	Next

46.7. Base Backup Processes #

46.7.1. Viewing Base Backup Processes
46.7.2. Canceling a Base Backup Process
46.7.3. Terminating the User Session for a Base Backup Process

You can view information about base backup processes (usually these are standard backup processes). The information is based on the pg_stat_progress_basebackup view.

46.7.1. Viewing Base Backup Processes #

Go to base backup processes in one of the following ways:

Using the monitoring section:
1. In the navigation panel, go to Monitoring → Activity.
2. Select Base backup, and then in the top-right corner of the page, select the instance and database.
Using the configuration section of an instance:
1. In the navigation panel, go to Infrastructure → Instances.
2. Click the name of the instance.
3. In the navigation panel, go to Activity.
4. Select Base backup, and then in the top-right corner of the page, select the database.

The table of base backup processes with the following columns will be displayed:

PID: The ID of the backend.
State: The state of the backend.
For more information about possible values, refer to the official Postgres Pro documentation on the pg_stat_activity module (refer to the state column).
Wait event: The name and type of the wait event for the backend.
For more information, refer to the official Postgres Pro documentation on the pg_stat_activity module (refer to wait_event_type and wait_event columns).
Phase: The base backup phase.
For more information about possible values, refer to the official Postgres Pro documentation.
Client address: The network address of the client that initiated the base backup.
Backend duration: Backend duration (base backup duration).
Started time: The backend start date and time (base backup start date and time).
Sent, %: The percentage of data sent to the client when performing the base backup.
This column includes additional information:
- Total size: The total size of data to be sent to the client.
- Sent size: The size of data sent to the client.
Tablespace total: The total number of tablespaces to be processed when performing a base backup.
Tablespaces streamed: The number of tablespaces processed when performing base backup.
Actions.
For more information about available actions, refer to the corresponding instructions.

46.7.2. Canceling a Base Backup Process #

Canceling a backup process does not terminate a user session.

To cancel a base backup process:

Go to base backup processes in one of the following ways:
- Using the monitoring section:
  1. In the navigation panel, go to Monitoring → Activity.
  2. Select Base backup, and then in the top-right corner of the page, select the instance and database.
- Using the configuration section of an instance:
  1. In the navigation panel, go to Infrastructure → Instances.
  2. Click the name of the instance.
  3. In the navigation panel, go to Activity.
  4. Select Base backup, and then in the top-right corner of the page, select the database.
Click next to the base backup process.
Click Execute.

46.7.3. Terminating the User Session for a Base Backup Process #

When the user session is terminated, the base backup process is canceled automatically.

To terminate the user session for a base backup process:

Go to base backup processes in one of the following ways:
- Using the monitoring section:
  1. In the navigation panel, go to Monitoring → Activity.
  2. Select Base backup, and then in the top-right corner of the page, select the instance and database.
- Using the configuration section of an instance:
  1. In the navigation panel, go to Infrastructure → Instances.
  2. Click the name of the instance.
  3. In the navigation panel, go to Activity.
  4. Select Base backup, and then in the top-right corner of the page, select the database.
Click next to the base backup process.
Click Execute.

Prev	Up	Next
46.6. Reindexing or Index Creation Processes	Home	46.8. Copying Processes