Re: A query in Streaming Replication

2020-06-22 Thread Sreerama Manoj
Hello, Thanks for you reply >> If files are assumed to > >> be sound, pg_rewind will adjust the old master as a new standby > To use pg_rewind, we should either enable *wal_log_hints *or initialize data directory with checksum enabled. These are not default and will not be enabled in most of t

Re: A query in Streaming Replication

2020-06-14 Thread Sreerama Manoj
Hello, Can anyone check this and respond please!! Thanks and regards, Manoj. On Sat, Jun 13, 2020, 20:26 Sreerama Manoj wrote: > Hello, > I use streaming replication in async mode. When master gets down, > slave will be promoted using a trigger file. During thi

Re: A query in Streaming Replication

2020-06-13 Thread Sreerama Manoj
Hello, Forgot to add the version details. I'm using postgres 10.7 . On Sat, Jun 13, 2020, 20:26 Sreerama Manoj wrote: > Hello, > I use streaming replication in async mode. When master gets down, > slave will be promoted using a trigger file. During this process ".part

A query in Streaming Replication

2020-06-13 Thread Sreerama Manoj
Hello, I use streaming replication in async mode. When master gets down, slave will be promoted using a trigger file. During this process ".partial" file will be created and a WAL file with same ID will be created in a different time line in slave. When master comes back as slave, it will be