Re: Fwd: Annoying corruption in PostgreSQL.

2023-10-30 Thread Stephen Frost
Greetings, Please don't top-post on these lists. * Kirill Reshke (reshkekir...@gmail.com) wrote: > We have physical backups and we can PITR. But restoring a cluster to some > point in the past is a bit of a different task: we need our client's > approval for these operations, since we are a Manag

Re: Fwd: Annoying corruption in PostgreSQL.

2023-10-27 Thread Tomas Vondra
On 10/27/23 23:10, Kirill Reshke wrote: > > Sorry, seems that i replied only to Tomas, so forwarding message. > -- Forwarded message - > From: *Kirill Reshke* <mailto:reshkekir...@gmail.com>> > Date: Sat, 28 Oct 2023 at 02:06 > Subject: Re: Annoying cor

Fwd: Annoying corruption in PostgreSQL.

2023-10-27 Thread Kirill Reshke
Sorry, seems that i replied only to Tomas, so forwarding message. -- Forwarded message - From: Kirill Reshke Date: Sat, 28 Oct 2023 at 02:06 Subject: Re: Annoying corruption in PostgreSQL. To: Tomas Vondra Hi Tomas! Thanks for the explanation! 1) 11 to 15. This week there

Re: Annoying corruption in PostgreSQL.

2023-10-27 Thread Tomas Vondra
On 10/27/23 14:19, Kirill Reshke wrote: > Hi hackers! > > We run a large amount of PostgreSQL clusters in our production. They > differ by versions (we have 11-16 pg), load, amount of data, schema, > etc. From time to time, postgresql corruption happens. It says > ERROR,XX001,"missing chunk num

Annoying corruption in PostgreSQL.

2023-10-27 Thread Kirill Reshke
Hi hackers! We run a large amount of PostgreSQL clusters in our production. They differ by versions (we have 11-16 pg), load, amount of data, schema, etc. From time to time, postgresql corruption happens. It says ERROR,XX001,"missing chunk number 0 for toast value 18767319 in pg_toast_2619",,"