Need help recovering

[Michael Garriss]

We had a significant production outage with a box running 8.0 Beta 4,
140GB data, 190GB index. We think it was a bad RAID controller card.
Our transaction logs are gone but we have raw data.

How can we recover this data? Can the transaction logs be reset? Can
we safely set this zero_damaged_pages parameter?

Ahh!!

--
Michael Garriss
Senior Software Engineer
Absolute Performance, Inc.


---------------------------(end of broadcast)---------------------------
TIP 7: don't forget to increase your free space map settings

[Alvaro Herrera]

On Wed, Jan 19, 2005 at 07:39:29AM -0700, Michael Garriss wrote:

> We had a significant production outage with a box running 8.0 Beta 4,
> 140GB data, 190GB index. We think it was a bad RAID controller card.
> Our transaction logs are gone but we have raw data.
>
> How can we recover this data? Can the transaction logs be reset? Can
> we safely set this zero_damaged_pages parameter?

What transaction logs? Do you mean pg_clog, or pg_xlog? If the former,
use your latest backup (i.e. forget it, unless you rarely rolled back
any transaction). If the latter, try pg_resetxlog (you will likely lose
some things after the last checkpoint, and some indexes may not be in
correct shape).

What are the exact error messages you are getting?

--
Alvaro Herrera (<alvherre[@]dcc.uchile.cl>)
"The ability to monopolize a planet is insignificant
next to the power of the source"

---------------------------(end of broadcast)---------------------------
TIP 2: you can get off all lists at once with the unregister command
(send "unregister YourEmailAddressHere" to [email]majordomo@postgresql.org[/email])