Skip site navigation (1) Skip section navigation (2)

Peripheral Links

Header And Logo

PostgreSQL
| The world's most advanced open source database.

Site Navigation

Search for
  Advanced Search

Re: Recovery from multi trouble


  • From: OKADA Satoshi <okada(dot)satoshi(at)lab(dot)ntt(dot)co(dot)jp>
  • To: Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
  • Cc: pgsql-hackers(at)postgresql(dot)org
  • Subject: Re: Recovery from multi trouble
  • Date: Mon, 19 Dec 2005 17:17:40 +0900
  • Message-id: <43A66CA4(dot)2010603(at)lab(dot)ntt(dot)co(dot)jp>

Tom Lane wrote:

>OKADA Satoshi <okada(dot)satoshi(at)lab(dot)ntt(dot)co(dot)jp> writes:
>  
>
>>The loss of log was simulated by deleting the latest xlog file. 
>>    
>>
>
>What does that have to do with reality?  Postgres is very careful not to
>use an xlog file until it's been fully metadata-synced.  You might as
>well complain that PG doesn't recover after "rm -rf /" ...
>  
>
In this case(postmaster abnormal end ,and log is lost), I understand
that database cannot recover normally.


Though a database cannot recover normally, postmaster does not output
a clear message showing this situation. I think that it is a problem.


Thanks, OKADA Satoshi



Home | Main Index | Thread Index

Privacy Policy | PostgreSQL Archives hosted by Command Prompt, Inc. | Designed by tinysofa
Copyright © 1996 – 2008 PostgreSQL Global Development Group