Re: Roll forward the replica instance

[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]

 



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?

Regards
Siraj

[Index of Archives]     [Postgresql Home]     [Postgresql General]     [Postgresql Performance]     [Postgresql PHP]     [Postgresql Jobs]     [PHP Users]     [PHP Databases]     [PHP Home]     [PHP on Windows]     [Kernel Newbies]     [PHP Classes]     [PHP Databases]     [Yosemite Forum]

  Powered by Linux