Re: Roll forward the replica instance

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(dot)g(at)gmail(dot)com> 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?
>
> Regards
> Siraj
>