Re: Pg_dump

From: Holger Jakobs <holger(at)jakobs(dot)com>
To: pgsql-admin(at)lists(dot)postgresql(dot)org
Cc: rajeshkumar(dot)dba09(at)gmail(dot)com
Subject: Re: Pg_dump
Date: 2023-12-07 18:13:40
Message-ID: 404a126a-6229-7d83-9b86-70304a5693bc@jakobs.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-admin

Am 07.12.23 um 19:11 schrieb Rajesh Kumar:
> Hi
>
> Will pg_dump cause blocking queries? If so how to take dump without
> blocking?

Readers don't block writers, writers don't block readers in PostgreSQL.

pg_dump is a reader.

--
Holger Jakobs, Bergisch Gladbach, Tel. +49-178-9759012

In response to

  • Pg_dump at 2023-12-07 18:11:50 from Rajesh Kumar

Responses

Browse pgsql-admin by date

  From Date Subject
Next Message Scott Ribe 2023-12-07 18:26:15 Re: Pg_dump
Previous Message Rajesh Kumar 2023-12-07 18:11:50 Pg_dump