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 -- Sent via pgsql-admin mailing list (pgsql-admin@xxxxxxxxxxxxxx) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-admin
