Purpose
To know how to detect locks in postgres db
Applicable in CAST Version
Release | Yes/No |
|---|---|
| 8.3.x |  |
| 8.2.x | |
Applicable RDBMS
RDBMS | Yes/No |
|---|---|
| Oracle Server |  |
| Microsoft SQL Server | |
| CSS2 |  |
| CSS1 | |
Applicable Platform or <Sub Platform Version>
Platform or <Sub Platform Version> | Yes/No |
|---|---|
Details
To detect locks in PostgreSQL by using PGADMIN4:
Connect to the server that you need to monitor
- Go to the locks tab
- On the lock window check any process that has it mode as "ExclusiveLock".
If any process has this mode we can determine that there is a lock on it.
Notes/comments
