Phew. Well #MastodonNZ it looks like your database is mostly fixed. The only thing still being repaired is the stats table, which I ended up deciding to just rebuild from scratch. This means your post stats will be inaccurate for a day or so whilst all 170 million are recalculated.

Any #PostgreSQL exports around to help me out here? After a storage server crash, I've ended up with (at least one) table having corrupt time data in it. There is, apparently, no way to pg_dump and ignore errors, and \COPY also doesn't appear to continue-on-error.

What I want to do is just get a list of the IDs of the rows with the corrupt time entries so I can either fix them, or just delete them.

This is the 'status_stats' table from #MastodonNZ, and has about 70m rows.

My current plan is that I've copied the schema of status_stats to status_stats_new, changing the time rows to just 'text' and I'm doing 'insert into status_stats_new select * from status_stats ON CONFLICT DO NOTHING;' then a left join to find missing ones.

IS THERE A BETTER WAY? Halp!