Received: from localhost (wm.hub.org [200.46.204.128])
	by postgresql.org (Postfix) with ESMTP id 468C89FB2E2
	for <pgsql-sql-postgresql.org@postgresql.org>;
	Thu,  2 Nov 2006 18:13:22 -0400 (AST)
Received: from postgresql.org ([200.46.204.71])
	by localhost (mx1.hub.org [200.46.204.128]) (amavisd-new, port 10024)
	with ESMTP id 91741-05 for <pgsql-sql-postgresql.org@postgresql.org>;
	Thu,  2 Nov 2006 22:13:19 +0000 (UTC)
X-Greylist: from auto-whitelisted by SQLgrey-
Received: from floppy.pyrenet.fr (floppy.pyrenet.fr [194.116.145.2])
	by postgresql.org (Postfix) with ESMTP id A8A019FA3C0
	for <pgsql-sql@postgresql.org>; Thu,  2 Nov 2006 18:13:18 -0400 (AST)
Received: by floppy.pyrenet.fr (Postfix, from userid 106)
	id 69F3B30AF7; Thu,  2 Nov 2006 23:13:17 +0100 (MET)
From: "Santosh" <ssbhujbal@gmail.com>
X-Newsgroups: pgsql.sql
Subject: Database recovery in postgres 7.2.4.
Date: 30 Oct 2006 02:25:09 -0800
Organization: http://groups.google.com
Lines: 34
Message-ID: <1162203909.082487.192540@m7g2000cwm.googlegroups.com>
References: <1162139808.031657.23340@f16g2000cwb.googlegroups.com>
Mime-Version: 1.0
Content-Type: text/plain; charset="iso-8859-1"
X-Complaints-To: groups-abuse@google.com
In-Reply-To: <1162139808.031657.23340@f16g2000cwb.googlegroups.com>
User-Agent: G2/1.0
X-HTTP-UserAgent: Mozilla/4.0 (compatible; MSIE 6.0; Windows NT 5.1; SV1;
	FunWebProducts; .NET CLR 1.1.4322),gzip(gfe),gzip(gfe)
Complaints-To: groups-abuse@google.com
Injection-Info: m7g2000cwm.googlegroups.com; posting-host=220.225.32.4;
	posting-account=vI08ag0AAAClOLY8fb-vMNFzS_HaNgr2
To: pgsql-sql@postgresql.org
X-Virus-Scanned: Maia Mailguard 1.0.1
X-Archive-Number: 200611/69
X-Sequence-Number: 26721

Hi All.

My setup is as follows:
OS: Sun Solaris 5.8.
Postgres: 7.2.4

I have very large database, which contain 15 tables and each table is
contain more than 10,00,000 records.

My application is parsing text data files and inserting records into
database.

When this process was running last night, machine was got down because
of power failure.

Today when I come back to office and I have compaired record count in
data files and in database and find that some records are missing in
database.

Then I have checked postgres log and found log similar to as follows:
=================================
DEBUG:  The DataBase system was not properly shut down
	Automatic recovery is in progress...
DEBUG:  Redo starts at (0, 1064)
=================================

I have read some WAL related stuff on postgres site but not found any
solution to recover those uncommited records.

Can any one tell me how to recover those missing records?

Thanks,
Santosh