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 report. I have developed a patch (attached) >that seems

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

2004-08-10 Thread Tom Lane
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 report. I have developed a patch (attached) that seems to fix it for me. Please test and see if you can still cause the pro

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

2004-08-09 Thread Tom Lane
> Okay, so theoretically it should work ... I'm trying it now to see > if I can reproduce the problem locally. It took several tries, but eventually I did reproduce it. It seems the triggering condition is for the REDO pointer to be before the checkpoint record itself. Not sure why, yet, but it

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

2004-08-09 Thread Tom Lane
OKADA Satoshi <[EMAIL PROTECTED]> writes: > Tom Lane wrote: >> Is this actually the official beta1 version, or is it a snapshot from >> last week sometime? >> > I got it from > ftp.postgresql.org/pub/source/v8.0.0beta/postgresql-8.0.0beta1.tar.gz, and > xlog.c revision number is 1.157. Okay, so

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.postgresql.org/pub/source/v8.0.0beta/postgresql-8.0.0bet

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

2004-08-09 Thread Tom Lane
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? In the first commit that had pg_start_backup(), there wasn't any logic to ensure that the recovery repl

[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