WAL corruption while replication

[Parkirat Bagga]

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.

[Albe Laurenz]

Post by Parkirat Bagga
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

[Parkirat Bagga]

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.