Hi Siraj,
As per my experience there is two methods;
1. Standby db data directory move some other location. Create a new empty data directory
Take the base backup again —- Preferred one
2. If enable the archive log in your environment
Take the missing wal files to correct time wal files. Move all files to wal directory location — this is bit complex
Thanks & Best Regards,
Nikhil,
On Thu, 4 Jul 2024 at 11:18 PM, Siraj G <tosiraj.g@xxxxxxxxx> wrote:
Hello -Is there any way we can roll forward the replica instance in PgSQL streaming replication environment? Say, WALs are deleted and there is a gap in the replica, what are the ways to sync the replica with its primary?RegardsSiraj