Postgres Pro
Downloads
Home   >   mailing lists

Re: pg_dump and locks - Mailing list pgsql-admin

From Laurenz Albe
Subject Re: pg_dump and locks
Date
Msg-id a753f06cc79cef66e4340a15a8b5ee36585d2027.camel@cybertec.at
Whole thread Raw
In response to pg_dump and locks  (Yambu <hyambu@gmail.com>)
List pgsql-admin
Tree view 
On Mon, 2021-07-19 at 12:37 +0200, Yambu wrote:
> May i know if pg_dump locks tables , and prevents updates/deletions or inserts on tables being dumped?

I locks tables, but these locks don't prevent concurrent data modification.

Yours,
Laurenz Albe
-- 
Cybertec | https://www.cybertec-postgresql.com

pgsql-admin by date:

Previous
From: Yambu
Date:
Subject: pg_dump and locks
Next
From: Laurenz Albe
Date:
Subject: Re: Handling Huge wal files