Re: log messages for archive recovery progress - Mailing list pgsql-hackers

From Robert Haas
Subject Re: log messages for archive recovery progress
Date
Msg-id CA+TgmoZqP1pyveGbe8Cu-4XCnZjXNfzSX2sOwxjBg5gO9jXwAA@mail.gmail.com
Whole thread Raw
In response to Re: log messages for archive recovery progress  (Simon Riggs <simon@2ndQuadrant.com>)
Responses Re: log messages for archive recovery progress  (Simon Riggs <simon@2ndQuadrant.com>)
List pgsql-hackers
On Wed, Jan 11, 2012 at 9:01 AM, Simon Riggs <simon@2ndquadrant.com> wrote:
> On Wed, Jan 11, 2012 at 1:54 PM, Satoshi Nagayasu <snaga@uptime.jp> wrote:
>
>> However, I'm a bit afraid that it will confuse DBA if we use
>> "restored" under the pg_xlog replay context, because we have
>> already used "restored" that means a WAL file as successfully
>> "copied" (not "replayed") from archive directory into pg_xlog
>> directory under the archive recovery context.
>>
>> So, to determine the status of copying WAL files from
>> archive directory, I think we can use "restored", or
>> "could not restore" on failure.
>>
>> And to determine the status of replaying WAL files
>> in pg_xlog directory (even if a WAL is copied from archive),
>> we have to use "recover" or "replay".
>
> Agreed. I can change "restored" to "using", so we have two message types
>
> LOG:  restored log file "000000080000000000000047" from archive
> LOG:  using pre-existing log file "000000080000000000000047" from pg_xlog

using seems pretty fuzzy to me.  replaying?

--
Robert Haas
EnterpriseDB: http://www.enterprisedb.com
The Enterprise PostgreSQL Company


pgsql-hackers by date:

Previous
From: Joey Adams
Date:
Subject: Re: JSON for PG 9.2
Next
From: Simon Riggs
Date:
Subject: pgbench post-connection command