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

Re: Fatal Error during PITR Recovery

From: Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
To: gnanam(at)zoniac(dot)com
Cc: pgsql-admin(at)postgresql(dot)org
Subject: Re: Fatal Error during PITR Recovery
Date: 2010-06-09 15:56:42
Message-ID: (view raw, whole thread or download thread mbox)
Lists: pgsql-admin
"Gnanakumar" <gnanam(at)zoniac(dot)com> writes:
> My production is running PostgreSQL v8.2.3 on CentOS release 5.2 (Final).

> As part of our routine, we just wanted to make sure and practice once in a
> while, whether PITR recovery process is performed without fail.  When I
> started the recovery process, after sometime, I see the following error in
> the serverlog.

> []:2010-06-09 04:44:59 EDTLOG:  could not fsync segment 0 of relation
> 1663/169462/252056: No such file or directory
> []:2010-06-09 04:44:59 EDTCONTEXT:  xlog redo checkpoint: redo 13/3FE33EB0;
> undo 0/0; tli 1; xid 0/331456443; oid 256783; multi 337; offset 676; online
> []:2010-06-09 04:44:59 EDTFATAL:  storage sync failed on magnetic disk: No
> such file or directory

This is probably a bug we fixed in 8.2.4:

2007-04-12 11:04  tgl

	* src/backend/commands/dbcommands.c (REL8_2_STABLE): Cancel pending
	fsync requests during WAL replay of DROP DATABASE, per bug report
	from David Darville.  Back-patch as far as 8.1, which may or may
	not have the problem but it seems a safe change anyway.

You really ought to be running a less ancient minor release of PG --- 8.2.x
is up to 8.2.17.  Your OS sounds a bit long in the tooth as well.

			regards, tom lane

In response to


pgsql-admin by date

Next:From: Kevin KempterDate: 2010-06-09 16:10:44
Subject: insert OS command results into a table on a remote system ?
Previous:From: Balkrishna SharmaDate: 2010-06-09 15:46:25
Subject: Only standby Server in Cloud(Amazon), not the primary

Privacy Policy | About PostgreSQL
Copyright © 1996-2017 The PostgreSQL Global Development Group