WAL corruption while replication
WAL corruption while replication
От:
Parkirat Bagga <parkiratbagga@gmail.com>
Дата:
Hi, How to recover, if master postgres WAL got corrupted before it is applied to the standby server? Will I loose all the data present in the WAL segment? How can I partially apply the WAL? Regards, Parkirat Singh Bagga. -- View this message in context: http://postgresql.1045698.n5.nabble.com/WAL-corruption-while-replication-tp5728705.html Sent from the PostgreSQL - admin mailing list archive at Nabble.com.
Re: WAL corruption while replication
От:
"Albe Laurenz" <laurenz.albe@wien.gv.at>
Дата:
Parkirat Bagga wrote: > How to recover, if master postgres WAL got corrupted before it is applied to > the standby server? > > Will I loose all the data present in the WAL segment? > > How can I partially apply the WAL? During normal recovery: ----------------------- WAL will be replayed until the point of corruption, then the server will stop recovering and come up. The last WAL segment will be applied until the point of corruption. There is no way to recover past a corruption in a WAL segment. On a standby: ------------- If you have streaming replication, you may not even notice the problem if the standby is already connected to the primary, because it does not read WAL archives in that case. If you don't have streaming replication, the standby will keep trying to apply the corrupted WAL segment and will get stuck. There's no way to get the standby past the point of corruption. The same will happen in streaming replication if the primary does not have the required information any more and the standby has to use the WAL archives. Yours, Laurenz Albe
Re: WAL corruption while replication
От:
Parkirat Bagga <parkiratbagga@gmail.com>
Дата:
Thanks Albe for the clarification. Regards, Parkirat Singh Bagga. -- View this message in context: http://postgresql.1045698.n5.nabble.com/WAL-corruption-while-replication-tp5728705p5728878.html Sent from the PostgreSQL - admin mailing list archive at Nabble.com.