Strahinja Kustudic

I agree, that would be a much better option. We randomly encounter pgcompact temp tables and indices all the time, and they shouldn't exist. On Tue, Mar 31, 2015, 03:24...

Yeah, sorry, you are correct, only indices. On Tue, Mar 31, 2015, 11:58 Sergey Konoplev [email protected] wrote: > Putting it down to my TODO then. > > BTW, pgcompact does...

Or even better, maybe WAL-G could do that and display for what version is a specific backup when it's listed?

I was looking into that flag, but couldn't find it, then I realized that it's not in the latest version, but only in master for now :D It would be...

I know about the TOAST index corruption. That is one of the reasons why we upgraded to 12.10 a few months ago and we reindexed the whole DB. I realized...

We upgraded to WAL-G 2.0 a few months ago and yet again we get the same error from time to time on different hosts and tables. Any ideas on how...

These errors happened very rarely on the older versions of WAL-G (2-3 fails a month), so it's not strange that we didn't have that many errors with 2.0. It's still...

I restored the latest backup that failed with toast errors on my workstation and I got the exact same error as our automatic tests reported. What was new is that...

Here are all the backups: ``` base_00000002000193F800000014 2022-09-08T22:34:36Z 00000002000193F800000014 base_00000002000193FB00000085_D_00000002000193F800000014 2022-09-08T23:36:36Z 00000002000193FB00000085 base_0000000200019408000000AF_D_00000002000193FB00000085 2022-09-09T04:45:03Z 0000000200019408000000AF base_000000020001941100000021_D_0000000200019408000000AF 2022-09-09T08:40:47Z 000000020001941100000021 base_000000020001941A00000048_D_000000020001941100000021 2022-09-09T12:41:03Z 000000020001941A00000048 base_0000000200019423000000CC_D_000000020001941A00000048 2022-09-09T16:41:14Z 0000000200019423000000CC ``` I restored `base_0000000200019423000000CC_D_000000020001941A00000048` with the...

> I still do not understand what it might be. Do you use fsync = on and data_checksums = on? `fsync = on`, but `data_checksums = off`. But why would...