RDBMS Information - PostgreSQL - How to unblock a process

Description

When using the CSS Tools or running analysis or snapshot, you may face process that are stuck or is facing performance issue. This page will help you to troubleshoot this.

Sub Platform Version

Sub Platform VersionYes/No
Postgres 9.6✅
Postgres 9.2✅

Applicable Platform or

Platform or Yes/No

Action Plan

  1. Open PgAdmin
  2. Connect to the Database Server where the schema to backup is stored.
  3. Click Tools > Server status
  4. In the section Activity, identify if there is line where a process appears and is blocked. The process is under the column “Application name”
  5. For instance, in the below screenshot, the process pg_dump process is blocked by a task:
  6. If the pg_dump process is blocked by a query, select that query and cancel it.

Notes/Comments

Related Pages