Bindra <11bindra11@gmail.com> writes:
> We are using PostgreSQL 11.17
You realize that 11.x is out of support, right?
> While doing pg_dumpall, it blocks insert/update on some table where copy
> statemnets is executed.
pg_dump only takes AccessShareLock on tables it dumps. That does not
block inserts or updates. What may be happening is that you have some
third process that is trying to take an exclusive lock on the table.
It will queue up behind pg_dump's nonexclusive lock, and then other
operations such as insert/update will block behind it. This is just
speculation since you've provided zero detail, but that's what I'd
look for. The pg_locks view could help you identify the culprit.
regards, tom lane