Request a Demo
46.7. Base Backup Processes
Prev UpChapter 46. ActivityHome 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:

  1. 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.

  2. Click Cancel current request next to the base backup process.

  3. 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:

  1. 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.

  2. Click Cancel session next to the base backup process.

  3. Click Execute.

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