Horton

Re: log messages for archive recovery progress

Euler Taveira de Oliveira <euler@timbira.com>

View thread
From: Euler Taveira de Oliveira <euler@timbira.com>
To: "Satoshi Nagayasu / Uptime Technologies, LLC." <snaga@uptime.jp>
Cc: pgsql-hackers@postgresql.org
Date: 2012-01-11T01:51:06Z
Lists: pgsql-hackers 
On 08-01-2012 11:59, Satoshi Nagayasu / Uptime Technologies, LLC. wrote:
>> [2011-12-08 15:14:36 JST] 16758: LOG:  restored log file "000000080000000000000046" from archive
>> [2011-12-08 15:14:36 JST] 16758: LOG:  recoverying 000000080000000000000046
>> [2011-12-08 15:14:36 JST] 16758: LOG:  restored log file "000000080000000000000047" from archive
>> [2011-12-08 15:14:36 JST] 16758: LOG:  recoverying 000000080000000000000047
>> cp: cannot stat `/backups/archlog/000000080000000000000048': No such file or directory
>> [2011-12-08 15:14:37 JST] 16758: LOG:  could not restore file "000000080000000000000048" from archive
>> [2011-12-08 15:14:37 JST] 16758: LOG:  attempting to look into pg_xlog
>> [2011-12-08 15:14:37 JST] 16758: LOG:  recoverying 000000080000000000000048
> 
What about just 'restored log file "000000080000000000000048" from pg_xlog'
instead of the last two messages? If you can't read from pg_xlog emit 'could
not restore file "000000080000000000000048" from pg_xlog'.


-- 
   Euler Taveira de Oliveira - Timbira       http://www.timbira.com.br/
   PostgreSQL: Consultoria, Desenvolvimento, Suporte 24x7 e Treinamento