Postgres Pro
Downloads
Home   >   mailing lists

lock mode for ControlFileLock which pg_start_backup uses - Mailing list pgsql-hackers

From Fujii Masao
Subject lock mode for ControlFileLock which pg_start_backup uses
Date
Msg-id 3f0b79eb1003081733j33223935he59f015162a21a51@mail.gmail.com
Whole thread Raw
Responses Re: lock mode for ControlFileLock which pg_start_backup uses
Re: lock mode for ControlFileLock which pg_start_backup uses
List pgsql-hackers
Tree view 
Hi,

Currently pg_start_backup() accesses the shared ControlFile
by using ControlFileLock with LW_EXCLUSIVE lock mode. But
since that access is read-only operation, LW_SHARED should
be chosen instead of LW_EXCLUSIVE.

The attached patch changes the lock mode which pg_start_backup()
uses. Is it worth applying this patch?

Regards,

--
Fujii Masao
NIPPON TELEGRAPH AND TELEPHONE CORPORATION
NTT Open Source Software Center
Attachment

pgsql-hackers by date:

Previous
From: Bruce Momjian
Date:
Subject: Re: Re: incorrect exit code from psql with single transaction + violation of deferred FK constraint
Next
From: Andrew Dunstan
Date:
Subject: Re: invalid UTF-8 via pl/perl