Postgres Pro
Downloads
Home   >   mailing lists

Re: pg_dump fails when a table is in ACCESS SHARE MODE - Mailing list pgsql-sql

From David G. Johnston
Subject Re: pg_dump fails when a table is in ACCESS SHARE MODE
Date
Msg-id CAKFQuwbETSv7wgxqtN-7mHvonwbWAF_P3UW2z38b+biWG=RTpw@mail.gmail.com
Whole thread Raw
In response to Re: pg_dump fails when a table is in ACCESS SHARE MODE  (Viral Shah <viralshah009@gmail.com>)
List pgsql-sql
Tree view
On Friday, May 1, 2020, Viral Shah <viralshah009@gmail.com> wrote:
Now, this does explain why I need to increase the max_transaction_locks so that I can account for all the locks pg_locks is running into while pg_dump is in progress. I am still trying to understand why pg_get_statisticsobjdef() creates locks (AccessShare) on all the base tables at once leading to this issue?

You are dumping your entire database as a consistent point-in-time whole - how would that be doable without locking every data containing relation is the database?

David J.

pgsql-sql by date:

Previous
From: Viral Shah
Date:
Subject: Re: pg_dump fails when a table is in ACCESS SHARE MODE
Next
From: Craig Jackson
Date:
Subject: Re: Table/log file name which store the queries which got executed inlast 1 month