From: Chris Browne <cbbrowne@acm.org>
To: pgsql-sql@postgresql.org
Subject: Re: Database recovery in postgres 7.2.4.
Date: Thu, 02 Nov 2006 17:41:46 -0500
Message-ID: <60wt6dh3o5.fsf@dba2.int.libertyrms.com> (raw)
References: <1162139808.031657.23340@f16g2000cwb.googlegroups.com>
<1162203909.082487.192540@m7g2000cwm.googlegroups.com>
"Santosh" <ssbhujbal@gmail.com> writes:
> 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?
If they were not committed, then there is no way to do so.
Uncommitted work is properly discarded when the database is brought
back online.
--
let name="cbbrowne" and tld="linuxfinances.info" in name ^ "@" ^ tld;;
http://linuxdatabases.info/info/sgml.html
"I've seen a look in dogs' eyes, a quickly vanishing look of amazed
contempt, and I am convinced that basically dogs think humans are
nuts." -- John Steinbeck
Reply instructions:
You may reply publicly to this message via plain-text email
using any one of the following methods:
* Reply to all the recipients using the --to and --cc options:
reply via email
To: pgsql-sql@postgresql.org
Cc: cbbrowne@acm.org
Subject: Re: Database recovery in postgres 7.2.4.
In-Reply-To: <60wt6dh3o5.fsf@dba2.int.libertyrms.com>
* Save the following mbox file, import it into your mail client,
and reply-to-all from there: mbox
This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox