Re: Corrupted disk

Tony Nelson wrote:
> I am ok, because I have a dump from last night, and wal since then.
>   

Dumps made with pg_dump are easy to restore from.  But they're fixed in 
time:  there is no applying WALs to them in order to update them.  
Anything that's happened to the server since then you can't add.

If you made a filesystem copy of the server using 
pg_start_backup/pg_stop_backup, and you save all of the WAL files after 
the backup began, that's also useful.  You can store from that backup 
and apply all the WAL that's happened since then.

> Can I drop/create/restore from this dump?  Or should I restore from last nights full and apply the WAL?
>   

If last night's backup with a filesystem one done with 
pg_start_backup/pg_stop_backup, and you have WAL since then, I would 
favor that set as likely to work fine.  But it sounds like what you have 
might instead be a pg_dump backup and some WAL files; you can't apply 
the WAL to such a dump. 

Whatever you do, you want to make a full filesystem copy of the server's 
data directory--with the server shutdown--before you do anything else.  
It's possible to recover from page errors and extract the available data 
using the right data recovery techniques, especially if there's a 
pg_dump available too; we offer some services in this area.  But if any 
serious changes are made to the database before we get to it, odds of 
successful recovery can drop fast.

-- 
Greg Smith   2ndQuadrant US    greg@2ndQuadrant.com   Baltimore, MD
PostgreSQL Training, Services, and 24x7 Support  www.2ndQuadrant.us
"PostgreSQL 9.0 High Performance": http://www.2ndQuadrant.com/books