Thread: WAL Recovery

WAL Recovery

From
Ashish Karalkar
Date:
Hello List Members,

I have PostgreSQL 8.2.4 on Suse Linux

Whne I am doing recovery from WAL archives I see in the logger that "000001.history file not found" infact server has not created such file insted it created 000001.backup  file which contains the history which documents also suggest is history file.
Should I ignore this message in logger?

Secondly, the logger says for e.g file 57 not fond in archive area which is present in pg_xlog and was not archived when server went down
 
file upto 56 are there in archive.

can anybody please explain why server giving message for filer 57 not found in archive area.

With Regards
Ashish...





Explore your hobbies and interests. Click here to begin.

Re: WAL Recovery

From
Simon Riggs
Date:
On Wed, 2007-11-28 at 06:05 +0000, Ashish Karalkar wrote:

> I have PostgreSQL 8.2.4 on Suse Linux
>
> Whne I am doing recovery from WAL archives I see in the logger that
> "000001.history file not found" infact server has not created such
> file insted it created 000001.backup  file which contains the history
> which documents also suggest is history file.
> Should I ignore this message in logger?

Yes. I will add a note to the docs to mention this.

> Secondly, the logger says for e.g file 57 not fond in archive area
> which is present in pg_xlog and was not archived when server went down
>
> file upto 56 are there in archive.
>
> can anybody please explain why server giving message for filer 57 not
> found in archive area.

http://www.postgresql.org/docs/8.2/static/continuous-archiving.html#BACKUP-PITR-RECOVERY

--
  Simon Riggs
  2ndQuadrant  http://www.2ndQuadrant.com


Re: WAL Recovery

From
Ashish Karalkar
Date:
Thanks Simon for your replay,
Yes I have followed the same instruction givn on the link, still it is happining , should i ignore this message too?

With Regards
Ashish


Simon Riggs <simon@2ndquadrant.com> wrote:
On Wed, 2007-11-28 at 06:05 +0000, Ashish Karalkar wrote:

> I have PostgreSQL 8.2.4 on Suse Linux
>
> Whne I am doing recovery from WAL archives I see in the logger that
> "000001.history file not found" infact server has not created such
> file insted it created 000001.backup file which contains the history
> which documents also suggest is history file.
> Should I ignore this message in logger?

Yes. I will add a note to the docs to mention this.

> Secondly, the logger says for e.g file 57 not fond in archive area
> which is present in pg_xlog and was not archived when server went down
>
> file upto 56 are there in archive.
>
> can anybody please explain why server giving message for filer 57 not
> found in archive area.

http://www.postgresql.org/docs/8.2/static/continuous-archiving.html#BACKUP-PITR-RECOVERY

--
Simon Riggs
2ndQuadrant http://www.2ndQuadrant.com



5, 50, 500, 5000 - Store N number of mails in your inbox. Click here.

Re: WAL Recovery

From
Simon Riggs
Date:
On Wed, 2007-11-28 at 11:00 +0000, Ashish Karalkar wrote:
> Thanks Simon for your replay,
> Yes I have followed the same instruction givn on the link, still it is
> happining , should i ignore this message too?

Yes.

--
  Simon Riggs
  2ndQuadrant  http://www.2ndQuadrant.com