On Tue, Sep 15, 2020 at 07:58:39PM +0200, Magnus Hagander wrote:
> Try reading them "row by row" until it breaks. That is, SELECT * FROM ...
> LIMIT
> 1, then LIMIT 2 etc. For more efficiency use a binary search starting at what
> seems like a reasonable place looking at the size of the table vs t
On Tue, Sep 15, 2020 at 11:15 AM Vasu Madhineni <
> vasumdba1...@gmail.com> wrote:
>
> Hi All,
>
> In one of my postgres databases multiple
>
>
>>> //Magnus
>>>
>>>
>>> On Tue, Sep 15, 2020 at 12:46 PM Vasu Madhineni
>>> wrote:
>>>
>>>> Is it possible to identify which rows are corrupted in particular
>>>> tables.
>>>>
>>>> On Tue
t;> Is it possible to identify which rows are corrupted in particular tables.
>>>
>>> On Tue, Sep 15, 2020 at 5:36 PM Magnus Hagander
>>> wrote:
>>>
>>>>
>>>>
>>>> On Tue, Sep 15, 2020 at 11:15 AM Vasu Madhineni
>>>> wrote:
&
ander
>> wrote:
>>
>>>
>>>
>>> On Tue, Sep 15, 2020 at 11:15 AM Vasu Madhineni
>>> wrote:
>>>
>>>> Hi All,
>>>>
>>>> In one of my postgres databases multiple tables got corrupted and
>>>> follow
t;>
>> On Tue, Sep 15, 2020 at 11:15 AM Vasu Madhineni
>> wrote:
>>
>>> Hi All,
>>>
>>> In one of my postgres databases multiple tables got corrupted and
>>> followed the below steps but still the same error.
>>>
>>> 1.SE
Is it possible to identify which rows are corrupted in particular tables.
On Tue, Sep 15, 2020 at 5:36 PM Magnus Hagander wrote:
>
>
> On Tue, Sep 15, 2020 at 11:15 AM Vasu Madhineni
> wrote:
>
>> Hi All,
>>
>> In one of my postgres databases multiple tables
On Tue, Sep 15, 2020 at 11:15 AM Vasu Madhineni
wrote:
> Hi All,
>
> In one of my postgres databases multiple tables got corrupted and followed
> the below steps but still the same error.
>
> 1.SET zero_damaged_pages = on
> 2. VACUUM ANALYZE, VACUUM FULL
> but still s
Hi All,
In one of my postgres databases multiple tables got corrupted and followed
the below steps but still the same error.
1.SET zero_damaged_pages = on
2. VACUUM ANALYZE, VACUUM FULL
but still same error.
moh_fa=# VACUUM FULL;
ERROR: could not read block 9350 in file "base/1156523/12
