Re: [HACKERS] Recovery from multi trouble

2006-03-26 Thread OKADA Satoshi
operation by the database administrator. Therefore, we think new startup option of postmaster; * Introduce new startup option(ex. postmaster -R). * When postmaster can't read xlog and startup with this option, postmaster stop startup process with "PANIC". We will make a patch. Do you think this patch? OKADA Satoshi NTT Cyberspace Lab. ---(end of broadcast)--- TIP 5: don't forget to increase your free space map settings

Re: [HACKERS] Recovery from multi trouble

2005-12-19 Thread OKADA Satoshi
Tom Lane wrote: >OKADA Satoshi <[EMAIL PROTECTED]> 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

[HACKERS] Recovery from multi trouble

2005-12-18 Thread OKADA Satoshi
m was not properly shut down; automatic recovery in progress LOG: record with zero length at 0/160 LOG: redo is not required LOG: database system is ready LOG: transaction ID wrap limit is 1073742415, limited by database "testdb" LOG: shutting down LOG: database system

Re: [HACKERS] PITR - Some data is not recovered.

2004-08-10 Thread OKADA Satoshi
Tom Lane wrote: >OKADA Satoshi <[EMAIL PROTECTED]> writes: > > >>I'm testing PITR using pgbench and postgresql ver.8.0bata. >>I think that result of recovery is wrong. >> >> > >Many thanks for this bug rep

Re: [HACKERS] PITR - Some data is not recovered.

2004-08-09 Thread OKADA Satoshi
Tom Lane wrote: >OKADA Satoshi <[EMAIL PROTECTED]> writes: > >>I'm testing PITR using pgbench and postgresql ver.8.0bata. >> > >Is this actually the official beta1 version, or is it a snapshot from >last week sometime? > I got it from ftp.postgr

[HACKERS] PITR - Some data is not recovered.

2004-08-09 Thread OKADA Satoshi
I'm testing PITR using pgbench and postgresql ver.8.0bata. I think that result of recovery is wrong. My test procedure is as follows: I edited postgresql.conf for PITR and started the postmaster. And I executed "pgbench -t 2". % pgbench -t 2 I did backup procedur