Re: Online base backup from the hot-standby - Mailing list pgsql-hackers

From Fujii Masao
Subject Re: Online base backup from the hot-standby
Date
Msg-id CAHGQGwGkS94Lzq0mxGS7-4cMdDWGmqm04k79VTxWq34tPnU4Gw@mail.gmail.com
Whole thread Raw
In response to Re: Online base backup from the hot-standby  (Robert Haas <robertmhaas@gmail.com>)
List pgsql-hackers
On Thu, Aug 18, 2011 at 12:09 AM, Robert Haas <robertmhaas@gmail.com> wrote:
> Ugh, you're right.  But then you might have problems if the state
> changes again before all backends have picked up the previous change.

Right.

> What I've thought about before is making one backend (say, bgwriter)
> store its latest value in shared memory, protected by some lock that
> would already be held at the time the value is needed.  Everyone else
> uses the shared memory copy instead of relying on their local value.

Sounds reasonable.

Regards,

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


pgsql-hackers by date:

Previous
From: Greg Smith
Date:
Subject: Re: Displaying accumulated autovacuum cost
Next
From: Fujii Masao
Date:
Subject: Re: Online base backup from the hot-standby