Re: pg_page_repair: a tool/extension to repair corrupted pages in postgres with streaming/physical replication

2022-06-22 Thread Masahiko Sawada
Hi, On Wed, Jun 22, 2022 at 2:44 PM RKN Sai Krishna wrote: > > Hi, > > Problem: Today when a data page is corrupted in the primary postgres with > physical replication (sync or async standbys), there seems to be no way to > repair it easily and we rely on PITR to recreate the postgres server

pg_page_repair: a tool/extension to repair corrupted pages in postgres with streaming/physical replication

2022-06-21 Thread RKN Sai Krishna
Hi, Problem: Today when a data page is corrupted in the primary postgres with physical replication (sync or async standbys), there seems to be no way to repair it easily and we rely on PITR to recreate the postgres server or drop the corrupted table (of course this is not an option for important