RE: Table locking during backup

> Not sure why would it matter that the pg_dump connection is read-only, this > is about locking because > pg_dump needs to ensure the schema does not change while it's running. > pg_dump does not do > > LOCK TABLE gm.tableabc; > > but > > LOCK TABLE gm.tableabc IN ACCESS SHARE MODE; > > Wh

Table locking during backup

cause that behaviour. Artur Zając