Re: pg_dump and locks

From: Laurenz Albe <laurenz(dot)albe(at)cybertec(dot)at>
To: Yambu <hyambu(at)gmail(dot)com>, Pgsql-admin <pgsql-admin(at)lists(dot)postgresql(dot)org>
Subject: Re: pg_dump and locks
Date: 2021-07-19 10:53:13
Message-ID: a753f06cc79cef66e4340a15a8b5ee36585d2027.camel@cybertec.at
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-admin

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

In response to

Browse pgsql-admin by date

  From Date Subject
Next Message Laurenz Albe 2021-07-19 10:53:57 Re: Handling Huge wal files
Previous Message Yambu 2021-07-19 10:37:42 pg_dump and locks