Postgres Pro
Downloads
Home   >   mailing lists

Re: Pg_dump - Mailing list pgsql-admin

From Holger Jakobs
Subject Re: Pg_dump
Date
Msg-id 404a126a-6229-7d83-9b86-70304a5693bc@jakobs.com
Whole thread Raw
In response to Pg_dump  (Rajesh Kumar <rajeshkumar.dba09@gmail.com>)
Responses Re: Pg_dump
Re: Pg_dump
List pgsql-admin
Tree view 
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
Attachment

pgsql-admin by date:

Previous
From: Rajesh Kumar
Date:
Subject: Pg_dump
Next
From: Scott Ribe
Date:
Subject: Re: Pg_dump