On 4/5/18 1:46 PM, molofeev wrote:
>
>> 4. Obviously the data in the corrupted block is not easily recoverable.
>> If you need to recover the remaining data in the table, it could
>> probably best be done by zeroing only this specific block. Whether this
>> is worth doing will depend on whether it would be easier to just
>> recreate the data.
> If fsync was disabled when I work with table, can I restore block
> 3220146 (by zeroing or maybe remove it)?
Honestly, if you've disabled fsync and it crashed, then all bets are off
and the best thing you can do is rebuilding the database. This is hardly
the only corrupted block.
regards
--
Tomas Vondra http://www.2ndQuadrant.com
PostgreSQL Development, 24x7 Support, Remote DBA, Training & Services
