On 2/17/20 08:23, Jeremy Schneider wrote:
> FWIW, Bertrand blogged an even faster way to do this about a month ago -
> using pageinspect and processing blocks instead of rows
>
> https://bdrouvot.wordpress.com/2020/01/18/retrieve-postgresql-variable-length-storage-information-thanks-to-pageinspect
FWIW, Bertrand blogged an even faster way to do this about a month ago - using
pageinspect and processing blocks instead of rows
https://bdrouvot.wordpress.com/2020/01/18/retrieve-postgresql-variable-length-storage-information-thanks-to-pageinspect/
-J
Sent from my TI-83
> On Feb 17, 2020, at
Hi Jeremy,
This happend on PostgreSQL v9.6 which crashed 2 weeks ago.
Since then we have upgraded and restored our server, but my example is
from the older, corrupt database.
Nick
On 15 Feb 2020, at 5:30, Jeremy Schneider wrote:
On Feb 14, 2020, at 04:39, Nick Renders wrote:
I get the fo
The problem is that I don't know which column is corrupt. But I found a
solution: by simply copying the record into another variable, the values
are parsed and the TOAST errors are thrown.
In case anyone's interested, here's my code, based on an example from
http://www.databasesoup.com/2013/10
> On Feb 14, 2020, at 04:39, Nick Renders wrote:
>
> I get the following message:
>
> ERROR: missing chunk number 0 for toast value 8289525 in pg_toast_5572299
What version of PostgreSQL are you running? I’ve seen this a number of times
the past couple years; curious if the lurking bug is
"Nick Renders" writes:
> I thought I would write a little PL script that would loop through all
> the data and report any inconsistencies. However, I can't get it to work
> properly.
> ...
> 1) The function has no problem executing the SELECT statement. It is
> only when "rcontents" is returned
On 14/2/20 2:39 μ.μ., Nick Renders wrote:
Hello,
We recently suffered a database crash which resulted in some corrupt records.
I thought I would write a little PL script that would loop through all the data
and report any inconsistencies. However, I can't get it to work properly.
For instanc
