Home > mailing lists

pg_dump blocks insert update on table - Mailing list pgsql-admin

From	Bindra
Subject	pg_dump blocks insert update on table
Date	February 29, 2024 15:06:40
Msg-id	CABeMV7Pq07Ebe8Guh50qna=Om6mLa6Q6MJC_odagRTfe7WPW-Q@mail.gmail.com Whole thread Raw
Responses	Re: pg_dump blocks insert update on table
List	pgsql-admin

Hi team,

We are using PostgreSQL 11.17

While doing pg_dumpall, it blocks insert/update on some table where copy statemnets is executed.

Request to help on immediate basis as we are facing on production system.

Thanks and regards

Bindra Bambharoliya

From: Laurenz Albe
Date: 29 February 2024, 08:00:09
Subject: Re: Need help - Unable to grant a role

From: Tom Lane
Date: 29 February 2024, 17:14:58
Subject: Re: pg_dump blocks insert update on table